pgsql-hackers since 2020-09-04 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

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Sept. 4, 2020

Thread Author Time
RE: On login trigger: take three [email protected] 00:11
Re: proposal: possibility to read dumped table's name from file Tom Lane 00:15
Re: 回复:how to create index concurrently on partitioned table 📎 Michael Paquier 00:51
Re: Disk-based hash aggregate's cost model Jeff Davis 00:53
Re: Switch to multi-inserts for pg_depend Michael Paquier 01:15
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 01:21
Re: Support for NSS as a libpq TLS backend Michael Paquier 01:23
Re: [NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Michael Paquier 01:25
Re: Refactor ReindexStmt and its "concurrent" boolean Michael Paquier 01:51
Concurrent failure in create_am with buildfarm member conchuela Michael Paquier 02:03
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 02:04
Rare deadlock failure in create_am test Tom Lane 02:13
Re: [PATCH] - Provide robust alternatives for replace_string Alvaro Herrera 02:15
Re: Clang UndefinedBehaviorSanitize (Postgres14) Detected undefined-behavior Noah Misch 02:36
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 02:43
Re: Get memory contexts of an arbitrary backend process Kasahara Tatsuhito 02:47
RE: New statistics for tuning WAL buffer size [email protected] 02:50
Re: Clang UndefinedBehaviorSanitize (Postgres14) Detected undefined-behavior Tom Lane 02:53
Re: default partition and concurrent attach partition Amit Langote 02:57
Re: [PATCH] Redudant initilization Bruce Momjian 02:57
Re: Clang UndefinedBehaviorSanitize (Postgres14) Detected undefined-behavior Peter Geoghegan 03:01
Re: Clang UndefinedBehaviorSanitize (Postgres14) Detected undefined-behavior Tom Lane 03:06
Re: Clang UndefinedBehaviorSanitize (Postgres14) Detected undefined-behavior Noah Misch 03:10
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 03:21
Re: New statistics for tuning WAL buffer size Fujii Masao 03:42
Re: history file on replica and double switchover Fujii Masao 04:53
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Peter Eisentraut 05:46
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Tom Lane 05:52
Re: [PATCH] Detect escape of ErrorContextCallback stack pointers (and from PG_TRY() ) Craig Ringer 06:13
Re: Compatible defaults for LEAD/LAG Pavel Stehule 06:33
Re: Change JOIN tutorial to focus more on explicit joins Peter Eisentraut 06:52
Re: [PATCH] Detect escape of ErrorContextCallback stack pointers (and from PG_TRY() ) Craig Ringer 06:55
Division in dynahash.c due to HASH_FFACTOR Jakub Wartak 07:01
Re: POC: rational number type (fractions) Heikki Linnakangas 08:12
Re: INSERT ON CONFLICT and RETURNING Konstantin Knizhnik 09:29
Re: Change JOIN tutorial to focus more on explicit joins 📎 Jürgen Purtz 09:36
Re: Rare deadlock failure in create_am test Thomas Munro 10:02
Re: autovac issue with large number of tables 📎 Kasahara Tatsuhito 10:50
Re: Creating foreign key on partitioned table is too slow Ashutosh Bapat 11:34
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe 11:59
Re: Division in dynahash.c due to HASH_FFACTOR Tomas Vondra 12:04
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Peter Eisentraut 12:21
Re: [PATCH] Redudant initilization Ranier Vilela 12:39
Re: Get memory contexts of an arbitrary backend process Tomas Vondra 12:46
Re: Disk-based hash aggregate's cost model Tomas Vondra 12:56
Re: Ideas about a better API for postgres_fdw remote estimates Ashutosh Bapat 13:23
Re: Rare deadlock failure in create_am test Tom Lane 13:58
Re: [PATCH] Redudant initilization Bruce Momjian 14:01
Re: Allow continuations in "pg_hba.conf" files Fabien COELHO 14:05
Re: Report error position in partition bound check Ashutosh Bapat 14:12
Re: Rare deadlock failure in create_am test Alvaro Herrera 14:20
Re: Division in dynahash.c due to HASH_FFACTOR Alvaro Herrera 14:34
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera 14:41
Re: Ideas about a better API for postgres_fdw remote estimates Tomas Vondra 14:57
Re: Allow continuations in "pg_hba.conf" files Tom Lane 15:00
Re: [PATCH]Fix ja.po error Alvaro Herrera 15:04
Re: Improving connection scalability: GetSnapshotData() Konstantin Knizhnik 15:24
[PATCH] Comments related to " buffer descriptors“ cache line size" 📎 Kelly Min 15:31
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe 15:37
Re: Add session statistics to pg_stat_database 📎 Laurenz Albe 15:50
Re: On login trigger: take three 📎 Konstantin Knizhnik 15:59
Re: Rare deadlock failure in create_am test Tom Lane 16:41
Re: [PATCH] Redudant initilization Ranier Vilela 16:55
Re: LogwrtResult contended spinlock Andres Freund 17:05
Re: LogwrtResult contended spinlock Andres Freund 17:13
Re: [PATCH] Comments related to " buffer descriptors“ cache line size" Bruce Momjian 17:28
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera 17:31
Re: Improving connection scalability: GetSnapshotData() Andres Freund 17:35
Re: [PATCH] Redudant initilization Tom Lane 17:40
Re: pg_dump bug for extension owned tables Andrew Dunstan 18:00
Improve pg_dump dumping publication tables 📎 Hsu, John 18:03
Re: Global snapshots 📎 Alexey Kondratov 18:31
Re: Disk-based hash aggregate's cost model Jeff Davis 18:31
Re: Improving connection scalability: GetSnapshotData() Andres Freund 18:53
Re: report expected contrecord size Alvaro Herrera 19:00
Re: Disk-based hash aggregate's cost model Tomas Vondra 19:01
Re: pg_dump bug for extension owned tables Fabrízio de Royes Mello 19:10
Re: Improving connection scalability: GetSnapshotData() 📎 Andres Freund 19:11
Re: Disk-based hash aggregate's cost model Jeff Davis 19:33
Re: A micro-optimisation for walkdir() Alvaro Herrera 19:37
Re: Concurrent failure in create_am with buildfarm member conchuela Alvaro Herrera 19:38
Questionable ping logic in LogicalRepApplyLoop Tom Lane 19:41
Re: BUG #16419: wrong parsing BC year in to_date() function David G. Johnston 19:45
Re: A micro-optimisation for walkdir() Juan José Santamaría Flecha 20:03
Re: [Patch] Add missing libraries to Libs.private of libpq.pc 📎 Peter Eisentraut 20:07
Re: BUG #16419: wrong parsing BC year in to_date() function Bruce Momjian 20:12
Re: [PATCH] Comments related to " buffer descriptors“ cache line size" Thomas Munro 20:26
Re: A micro-optimisation for walkdir() Alvaro Herrera 20:28
Re: A micro-optimisation for walkdir() Juan José Santamaría Flecha 20:34
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path Peter Eisentraut 20:36
Re: Questionable ping logic in LogicalRepApplyLoop Alvaro Herrera 20:41
Re: A micro-optimisation for walkdir() Alvaro Herrera 20:43
Re: Any objections to implementing LogicalDecodeMessageCB for pgoutput? Cary Huang 20:54
Re: BUG #16419: wrong parsing BC year in to_date() function 📎 Peter Eisentraut 21:05
Re: [PATCH] Redudant initilization 📎 Ranier Vilela 21:20
Re: Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration Peter Eisentraut 21:24
Re: PATCH: Batch/pipelining support for libpq Alvaro Herrera 21:26
Re: A micro-optimisation for walkdir() Tom Lane 21:39
Re: Questionable ping logic in LogicalRepApplyLoop Tom Lane 21:41
Re: A micro-optimisation for walkdir() Andres Freund 21:45
Re: A micro-optimisation for walkdir() Alvaro Herrera 21:52
Re: A micro-optimisation for walkdir() Thomas Munro 23:15

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

Browse Archives

Prev | Next