pgsql-hackers since 2020-09-05 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Sept. 5, 2020

Thread Author Time
Re: WIP: WAL prefetch (another approach) Thomas Munro 00:05
Re: A micro-optimisation for walkdir() Andres Freund 00:13
Re: Improving connection scalability: GetSnapshotData() Michael Paquier 01:31
Re: Concurrent failure in create_am with buildfarm member conchuela Michael Paquier 01:37
Re: Bogus documentation for bogus geometric operators Michael Paquier 01:45
Re: WIP: BRIN multi-range indexes Michael Paquier 01:46
Weird corner-case failure mode for VPATH builds Tom Lane 01:49
Re: More tests with USING INDEX replident and dropped indexes Michael Paquier 02:36
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Jesse Zhang 04:23
Re: Implementing Incremental View Maintenance Thomas Munro 05:56
Use <unnamed> for name of unnamed portal's memory context 📎 Peter Eisentraut 06:14
Re: Use <unnamed> for name of unnamed portal's memory context Pavel Stehule 06:24
Re: Use <unnamed> for name of unnamed portal's memory context Julien Rouhaud 06:55
Re: New statistics for tuning WAL buffer size Magnus Hagander 09:40
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 10:32
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 11:53
Re: Switch to multi-inserts for pg_depend Michael Paquier 13:21
Re: Improving connection scalability: GetSnapshotData() Konstantin Knizhnik 13:58
Re: Use <unnamed> for name of unnamed portal's memory context Tom Lane 15:10
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 15:25
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Tom Lane 15:27
Re: [PATCH] Redudant initilization 📎 Ranier Vilela 16:40
Re: A micro-optimisation for walkdir() 📎 Juan José Santamaría Flecha 17:22
Re: [PATCH] Redudant initilization Tom Lane 17:29
Re: [PATCH] Redudant initilization Ranier Vilela 17:44
Dubious code in pg_rewind's process_target_file() Tom Lane 18:08
Re: Dubious code in pg_rewind's process_target_file() Tom Lane 18:18
Re: A micro-optimisation for walkdir() 📎 Ranier Vilela 18:58
Re: logtape.c stats don't account for unused "prefetched" block numbers Peter Geoghegan 19:03
Re: v13: show extended stats target in \d Justin Pryzby 21:06
Re: [PATCH] - Provide robust alternatives for replace_string 📎 Tom Lane 22:42
Re: WIP: BRIN multi-range indexes 📎 Tomas Vondra 23:20

Sept. 6, 2020

Thread Author Time
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path David Rowley 00:24
Re: Multivariate MCV list vs. statistics target Justin Pryzby 01:12
Re: Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration 📎 Michael Paquier 03:04
Re: Improving connection scalability: GetSnapshotData() Konstantin Knizhnik 11:05
Re: Optimising compactify_tuples() David Rowley 11:37
Re: Yet another fast GiST build (typo) Heikki Linnakangas 13:26
Re: Dubious code in pg_rewind's process_target_file() Heikki Linnakangas 14:54
Re: Missing "Up" navigation link between parts and doc root? Peter Eisentraut 14:59
Re: Dubious code in pg_rewind's process_target_file() Tom Lane 15:06
Re: Dubious code in pg_rewind's process_target_file() Heikki Linnakangas 15:13
Re: Dubious code in pg_rewind's process_target_file() Tom Lane 15:51
moving aggregate bad error message 📎 Jeff Janes 16:07
Re: moving aggregate bad error message Tom Lane 16:41
Re: Append with naive multiplexing of FDWs Etsuro Fujita 17:05
Re: file_fdw vs relative paths Magnus Hagander 17:31
Re: [PATCH] - Provide robust alternatives for replace_string Tom Lane 18:15
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 18:33
Re: Improving connection scalability: GetSnapshotData() Andres Freund 18:52
Re: Improving connection scalability: GetSnapshotData() Andres Freund 18:56
Re: v13: show extended stats target in \d Peter Geoghegan 20:06
Re: v13: show extended stats target in \d Justin Pryzby 20:48
Re: [PATCH] audo-detect and use -moutline-atomics compilation flag for aarch64 Zidenberg, Tsahi 21:00
Re: Disk-based hash aggregate's cost model Tomas Vondra 21:21
Re: [bug+patch] Inserting DEFAULT into generated columns from VALUES RTE Tom Lane 21:42
Re: A micro-optimisation for walkdir() Thomas Munro 22:26
Re: A micro-optimisation for walkdir() Tom Lane 22:36
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Tom Lane 23:46

Sept. 7, 2020

Thread Author Time
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiro Ikeda 00:49
Re: New statistics for tuning WAL buffer size 📎 Masahiro Ikeda 00:58
Re: Auto-vectorization speeds up multiplication of large-precision numerics Tom Lane 01:44
Re: 回复：how to create index concurrently on partitioned table 📎 Michael Paquier 01:58
Re: shared-memory based stats collector Michael Paquier 02:04
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Michael Paquier 02:06
Re: Transactions involving multiple postgres foreign servers, take 2 Michael Paquier 02:14
v13: CLUSTER segv with wal_level=minimal and parallel index creation Justin Pryzby 02:37
Re: Remove page-read callback from XLogReaderState. Michael Paquier 02:51
Re: Let people set host(no)ssl settings from initdb Michael Paquier 02:57
Re: vacuum verbose: show pages marked allvisible/frozen/hintbits Michael Paquier 03:05
Re: archive status ".ready" files may be created too early Michael Paquier 03:07
Re: [PATCH] audo-detect and use -moutline-atomics compilation flag for aarch64 Michael Paquier 03:10
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 03:14
Re: Collation versioning Michael Paquier 03:17
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation Justin Pryzby 03:34
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Pavel Stehule 03:46
Re: [PATCH] Initial progress reporting for COPY command Michael Paquier 04:13
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation Tom Lane 04:33
[doc] minor wording improvement in a couple of places 📎 Ian Barwick 04:33
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation Kyotaro Horiguchi 04:45
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 05:08
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 05:23
Re: Auto-vectorization speeds up multiplication of large-precision numerics Tom Lane 05:53
Re: SQL-standard function body 📎 Peter Eisentraut 06:00
Re: clarify "rewritten" in pg_checksums docs Michael Paquier 06:00
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 06:24
Re: A micro-optimisation for walkdir() Thomas Munro 06:29
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 06:30
Re: Online checksums verification in the backend Michael Paquier 06:58
Re: Auto-vectorization speeds up multiplication of large-precision numerics Amit Khandekar 07:10
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 07:14
Re: Online checksums patch - once again Michael Paquier 07:17
Re: New statistics for tuning WAL buffer size Fujii Masao 07:19
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Michael Paquier 07:22
Re: [POC] Fast COPY FROM command for the table with foreign partitions Michael Paquier 07:26
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 07:27
Re: Online checksums verification in the backend Julien Rouhaud 07:38
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Michael Paquier 07:40
Re: Optimising compactify_tuples() 📎 David Rowley 07:47
Re: Improvements in Copy From Surafel Temesgen 07:49
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 k.jamison@fujitsu.com 08:03
Re: Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration Peter Eisentraut 08:06
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 08:36
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation 📎 Kyotaro Horiguchi 08:40
Re: Online checksums verification in the backend Michael Paquier 08:50
Re: Transactions involving multiple postgres foreign servers, take 2 Fujii Masao 08:59
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation Noah Misch 09:32
Re: A micro-optimisation for walkdir() Magnus Hagander 09:42
Re: Yet another fast GiST build 📎 Heikki Linnakangas 09:47
Re: Allow CURRENT_ROLE in GRANTED BY Asif Rehman 10:02
Re: [doc] minor wording improvement in a couple of places Magnus Hagander 10:30
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey V. Lepikhov 10:31
Re: Bogus documentation for bogus geometric operators 📎 Emre Hasegeli 10:50
Re: Yet another fast GiST build Pavel Borisov 10:59
Re: Parallel copy vignesh C 11:00
Logical Replication - detail message with names of missing columns 📎 Bharath Rupireddy 11:00
Re: Ideas about a better API for postgres_fdw remote estimates Andrey V. Lepikhov 11:37
Re: A micro-optimisation for walkdir() Thomas Munro 11:40
Inaccurate comment, for family-1 polymorphic UNKNOWN type arguments 📎 Himanshu Upadhyaya 12:03
Re: proposal: possibility to read dumped table's name from file Surafel Temesgen 12:14
Re: Strange behavior with polygon and NaN 📎 gkokolatos 12:46
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 13:16
Re: PG 13 release notes, first draft 📎 Justin Pryzby 13:40
Re: shared-memory based stats collector Stephen Frost 13:46
Re: A micro-optimisation for walkdir() Juan José Santamaría Flecha 14:03
Re: Yet another fast GiST build 📎 Heikki Linnakangas 14:10
Re: Improving connection scalability: GetSnapshotData() 📎 Konstantin Knizhnik 14:20
Re: 回复：how to create index concurrently on partitioned table Anastasia Lubennikova 14:23
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe 14:28
Re: Transactions involving multiple postgres foreign servers, take 2 Fujii Masao 14:38
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera 14:42
Re: [doc] minor wording improvement in a couple of places John Naylor 15:16
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Tom Lane 15:20
Re: Yet another fast GiST build Andrey M. Borodin 15:24
Re: factorial function/phase out postfix operators? John Naylor 15:43
Re: Auto-vectorization speeds up multiplication of large-precision numerics Tom Lane 16:07
Re: Improving connection scalability: GetSnapshotData() Konstantin Knizhnik 16:35
Meaning of pg_stats_subscription.latest_end_time Simon.Schneider 16:48
Re: Inaccurate comment, for family-1 polymorphic UNKNOWN type arguments 📎 Tom Lane 18:54
Re: Improving connection scalability: GetSnapshotData() Andres Freund 20:45
Re: Auto-vectorization speeds up multiplication of large-precision numerics Tom Lane 20:49
Re: Disk-based hash aggregate's cost model Jeff Davis 20:55
Re: v13: show extended stats target in \d Peter Geoghegan 21:31
Re: [PATCH] audo-detect and use -moutline-atomics compilation flag for aarch64 Tom Lane 22:00
Re: A micro-optimisation for walkdir() Thomas Munro 22:03
Re: default partition and concurrent attach partition 📎 Alvaro Herrera 22:05
Re: default partition and concurrent attach partition Alvaro Herrera 22:10
Re: default partition and concurrent attach partition 📎 Alvaro Herrera 22:35
Re: A micro-optimisation for walkdir() Tom Lane 22:53
Re: default partition and concurrent attach partition Alvaro Herrera 23:44

Sept. 8, 2020

Thread Author Time
Re: Optimising compactify_tuples() Thomas Munro 00:07
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation 📎 Kyotaro Horiguchi 00:13
Re: pgbench and timestamps (bounced) Tom Lane 00:31
Re: Division in dynahash.c due to HASH_FFACTOR Thomas Munro 00:55
Re: Logical Replication - detail message with names of missing columns Kyotaro Horiguchi 01:20
Re: Transactions involving multiple postgres foreign servers, take 2 Amit Kapila 01:34
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation 📎 Kyotaro Horiguchi 01:43
Re: Evaluate expression at planning time for two more cases Tom Lane 01:45
回复: Is it possible to set end-of-data marker for COPY statement. Junfeng Yang 01:53
Re: Resetting spilled txn statistics in pg_stat_replication 📎 Masahiko Sawada 02:23
Re: [PATCH] Detect escape of ErrorContextCallback stack pointers (and from PG_TRY() ) Craig Ringer 02:27
Re: Transactions involving multiple postgres foreign servers, take 2 Fujii Masao 02:35
Re: Online checksums verification in the backend Masahiko Sawada 02:36
Re: 回复：how to create index concurrently on partitioned table 📎 Justin Pryzby 02:39
Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation Noah Misch 02:47
Re: Global snapshots Fujii Masao 02:49
Re: [PATCH] Detect escape of ErrorContextCallback stack pointers (and from PG_TRY() ) Tom Lane 02:56
Re: Remove page-read callback from XLogReaderState. Kyotaro Horiguchi 02:56
Re: Transactions involving multiple postgres foreign servers, take 2 Amit Kapila 03:03
Re: Online checksums verification in the backend Michael Paquier 03:10
Re: Logical Replication - detail message with names of missing columns Bharath Rupireddy 03:46
RE: Transactions involving multiple postgres foreign servers, take 2 tsunakawa.takay@fujitsu.com 04:00
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 04:02
Re: Improving connection scalability: GetSnapshotData() Ian Barwick 04:03
Re: Remove page-read callback from XLogReaderState. Kyotaro Horiguchi 04:09
Re: Improving connection scalability: GetSnapshotData() Andres Freund 04:11
Re: Improving connection scalability: GetSnapshotData() Ian Barwick 04:23
Re: 回复：how to create index concurrently on partitioned table Michael Paquier 04:31
Re: Improving connection scalability: GetSnapshotData() Thomas Munro 04:44
Reduce the time required for a database recovery from archive. 📎 Dmitry Shulga 04:51
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 05:16
Re: Reduce the time required for a database recovery from archive. Pavel Stehule 05:45
RE: [Patch] Optimize dropping of relation buffers using dlist tsunakawa.takay@fujitsu.com 05:49
Re: Auto-vectorization speeds up multiplication of large-precision numerics Amit Khandekar 05:50
RE: [Patch] Optimize dropping of relation buffers using dlist tsunakawa.takay@fujitsu.com 06:01
Inconsistency in determining the timestamp of the db statfile. 📎 Amit Kapila 06:10
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 06:13
Re: default partition and concurrent attach partition 📎 Amit Langote 07:27
Re: [POC] Fast COPY FROM command for the table with foreign partitions Amit Langote 07:34
Re: Remove page-read callback from XLogReaderState. 📎 Kyotaro Horiguchi 07:35
Re: shared-memory based stats collector Kyotaro Horiguchi 08:01
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Peter Eisentraut 08:12
Re: Boundary value check in lazy_tid_reaped() Masahiko Sawada 08:23
Re: Internal key management system Michael Paquier 08:23
Re: shared-memory based stats collector 📎 Kyotaro Horiguchi 08:55
Re: INSERT ON CONFLICT and RETURNING 📎 Konstantin Knizhnik 09:06
Re: Improving connection scalability: GetSnapshotData() Konstantin Knizhnik 09:27
Re: [POC] Fast COPY FROM command for the table with foreign partitions Alexey Kondratov 09:29
Re: INSERT ON CONFLICT and RETURNING Pavel Stehule 09:34
Re: Evaluate expression at planning time for two more cases Surafel Temesgen 09:59

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30