pgsql-hackers since 2024-01-13 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)
Advanced Search

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 31

Jan. 13, 2024

Thread Author Time
Re: cfbot is failing all tests on FreeBSD/Meson builds Thomas Munro 00:39
Re: cfbot is failing all tests on FreeBSD/Meson builds Tom Lane 00:51
Re: cfbot is failing all tests on FreeBSD/Meson builds Thomas Munro 00:57
Re: [17] CREATE SUBSCRIPTION ... SERVER 📎 Jeff Davis 01:17
Re: Fix minor memory leak in connection string validation Nathan Bossart 02:37
Re: Fix minor memory leak in connection string validation Tom Lane 03:18
Re: Synchronizing slots from primary to standby Amit Kapila 04:35
Re: Recovering from detoast-related catcache invalidations Xiaoran Wang 05:16
Re: plpgsql memory leaks Pavel Stehule 05:25
Re: Synchronizing slots from primary to standby Amit Kapila 07:23
Re: [PATCH] New predefined role pg_manage_extensions Michael Banck 08:20
Re: Recovering from detoast-related catcache invalidations Xiaoran Wang 09:02
Re: POC: GROUP BY optimization 📎 Andrei Lepikhov 09:08
Postgres and --config-file option Aleksander Alekseev 10:39
Re: reorganize "Shared Memory and LWLocks" section of docs Aleksander Alekseev 10:49
Re: speed up a logical replica setup Amit Kapila 11:02
Re: A failure in t/038_save_logical_slots_shutdown.pl Amit Kapila 11:12
Re: Invalidate the subscription worker in cases where a user loses their superuser status Amit Kapila 11:21
Add support for data change delta tables PavelTurk 11:41
Re: Documentation to upgrade logical replication cluster 📎 vignesh C 13:37
Re: pg_stat_statements and "IN" conditions 📎 Dmitry Dolgov 14:05
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 jian he 14:19
Re: Tidy fill hstv array (src/backend/access/heap/pruneheap.c) Ranier Vilela 14:36
Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bindx Jelte Fennema-Nio 14:37
Re: Custom explain options Tomas Vondra 14:51
Re: POC: GROUP BY optimization 📎 Alexander Korotkov 15:00
Re: Documentation to upgrade logical replication cluster vignesh C 15:50
Re: On login trigger: take three Alexander Lakhin 16:00
Re: Custom explain options Konstantin Knizhnik 16:13
Re: Recovering from detoast-related catcache invalidations Tom Lane 17:18
Re: [DOC] Add detail regarding resource consumption wrt max_connections Roberto Mello 17:31
Re: collect_corrupt_items_vacuum.patch Dmitry Koval 17:33
Re: cleanup patches for incremental backup 📎 Alexander Lakhin 18:00
Re: Recovering from detoast-related catcache invalidations Tom Lane 19:12
Re: reorganize "Shared Memory and LWLocks" section of docs 📎 Nathan Bossart 21:28
Fix a possible socket leak at Windows (src/backend/port/win32/socket.c) 📎 Ranier Vilela 21:38
Re: introduce dynamic shared memory registry 📎 Nathan Bossart 21:41
Re: Postgres and --config-file option Nathan Bossart 22:38

Jan. 14, 2024

Thread Author Time
Re: SQL:2011 application time 📎 jian he 00:00
Postgres and --config-file option David G. Johnston 00:36
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 Alexander Korotkov 01:30
Re: speed up a logical replica setup Junwang Zhao 01:42
Re: collect_corrupt_items_vacuum.patch 📎 Alexander Korotkov 02:35
Re: logicalrep_worker_launch -- counting/checking the worker limits vignesh C 05:43
Re: Asynchronous execution support for Custom Scan vignesh C 05:51
Re: Escape output of pg_amcheck test Peter Eisentraut 06:32
Re: ALTER ROLE documentation improvement 📎 vignesh C 10:47
Re: There should be a way to use the force flag when restoring databases vignesh C 10:55
Re: Add last_commit_lsn to pg_stat_database vignesh C 11:01
Re: Add connection active, idle time to pg_stat_activity vignesh C 11:04
Re: Add test module for Table Access Method vignesh C 11:09
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) vignesh C 11:18
Re: Build versionless .so for Android Matthias Kuhn 11:37
Re: Document efficient self-joins / UPDATE LIMIT techniques. vignesh C 11:44
Re: Improvements in pg_dump/pg_restore toc format and performances vignesh C 11:49
Re: POC: GROUP BY optimization 📎 Andrei Lepikhov 12:14
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache Cédric Villemain 13:36
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 13:42
Re: Tidy fill hstv array (src/backend/access/heap/pruneheap.c) John Naylor 13:55
Re: plperl and perl 5.38 Andrew Dunstan 14:02
Re: A failure in t/038_save_logical_slots_shutdown.pl 📎 Bharath Rupireddy 15:02
Re: Recovering from detoast-related catcache invalidations Noah Misch 20:14
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) Masahiko Sawada 20:34
Re: plperl and perl 5.38 Christoph Berg 21:00
Re: Custom explain options Tomas Vondra 21:47
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) Tomas Vondra 23:15
Re: Printing backtrace of postgres processes Maciek Sakrejda 23:20
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 Alexander Korotkov 23:21
Re: Built-in CTYPE provider Michael Paquier 23:23

Jan. 15, 2024

Thread Author Time
Re: POC: GROUP BY optimization 📎 Alexander Korotkov 00:19
Re: On login trigger: take three Alexander Korotkov 00:36
Re: doc: add LITERAL tag to RETURNING torikoshia 01:48
Re: ALTER ROLE documentation improvement Nathan Bossart 01:59
Re: Recovering from detoast-related catcache invalidations Xiaoran Wang 03:28
Re: Documentation to upgrade logical replication cluster Peter Smith 03:30
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed Michael Paquier 03:59
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed Tom Lane 04:08
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed Michael Paquier 04:11
Re: Compile warnings in dbcommands.c building with meson jian he 05:00
Re: the s_lock_stuck on perform_spin_delay 📎 Andy Fan 05:19
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) vignesh C 05:43
Re: An inefficient query caused by unnecessary PlaceHolderVar 📎 Richard Guo 05:50
Commitfest 2024-01 second week update vignesh C 06:05
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 06:23
Oom on temp (un-analyzed table caused by JIT) V16.1 📎 Kirk Wolak 06:24
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 06:27
Re: Show WAL write and fsync stats in pg_stat_io Michael Paquier 06:27
Re: POC: GROUP BY optimization Richard Guo 06:42
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) Masahiko Sawada 06:43
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 Pavel Stehule 06:50
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 07:03
Fix race condition in InvalidatePossiblyObsoleteSlot() 📎 Bertrand Drouvot 07:48
Re: pgbnech: allow to cancel queries during benchmark Tatsuo Ishii 07:49
Re: Add PQsendSyncMessage() to libpq 📎 Michael Paquier 07:50
Re: In-placre persistance change of a relation 📎 Kyotaro Horiguchi 07:50
Re: POC: GROUP BY optimization Alexander Korotkov 07:56
Re: [PATCH] kNN for btree 📎 Anton A. Melnikov 08:11
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎 Bertrand Drouvot 08:49
Re: Create shorthand for including all extra tests Nazir Bilal Yavuz 08:54
Re: Test slots invalidations in 035_standby_logical_decoding.pl only if dead rows are removed 📎 Alexander Lakhin 09:00
Re: Add PQsendSyncMessage() to libpq Jelte Fennema-Nio 09:01
Re: On login trigger: take three Daniel Gustafsson 09:05
RE: Documentation to upgrade logical replication cluster Hayato Kuroda (Fujitsu) 09:09
Re: Synchronizing slots from primary to standby Bertrand Drouvot 09:24
Re: On login trigger: take three Daniel Gustafsson 09:29
Re: Add test module for Table Access Method Jelte Fennema-Nio 09:36
Re: POC: GROUP BY optimization Andrei Lepikhov 09:46
Re: Add PQsendSyncMessage() to libpq Alvaro Herrera 09:49
Re: System username in pg_stat_activity Bertrand Drouvot 10:17
Re: automating RangeTblEntry node support 📎 Peter Eisentraut 10:37
Re: Synchronizing slots from primary to standby Amit Kapila 10:39
Re: Make NUM_XLOGINSERT_LOCKS configurable Jakub Wartak 10:54
Re: Postgres and --config-file option 📎 Aleksander Alekseev 11:35
Re: Lockless exit path for ReplicationOriginExitCleanup Alvaro Herrera 12:03
Re: archive modules loose ends Li, Yong 12:21
Re: Fix a possible socket leak at Windows (src/backend/port/win32/socket.c) Daniel Gustafsson 12:43
Re: POC: GROUP BY optimization 📎 Alena Rybakina 13:21
Re: postgres_fdw fails to see that array type belongs to extension David Geier 13:24
Re: Add test module for Table Access Method Aleksander Alekseev 13:26
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 Daniel Gustafsson 14:03
Re: More new SQL/JSON item methods 📎 Peter Eisentraut 14:10
Re: Custom explain options Konstantin Knizhnik 14:22
Re: Built-in CTYPE provider 📎 Daniel Verite 14:30
Re: Add test module for Table Access Method Jelte Fennema-Nio 14:40
Re: archive modules loose ends Nathan Bossart 14:50
Re: Custom explain options Tomas Vondra 15:08
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 Alexander Korotkov 15:17
minor replication slot docs edits 📎 Alvaro Herrera 15:37
Re: WIP Incremental JSON Parser 📎 Andrew Dunstan 15:48
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 Kirk Wolak 15:49
Re: Make attstattarget nullable 📎 Peter Eisentraut 15:54
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 Pavel Stehule 15:56
Re: Rework LogicalOutputPluginWriterUpdateProgress vignesh C 16:20
Re: cleanup patches for incremental backup Robert Haas 16:58
Re: Emit fewer vacuum records by reaping removable tuples during pruning 📎 Robert Haas 17:29
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 Daniel Gustafsson 17:47
ALTER TYPE OWNER fails to recurse to multirange Tom Lane 18:27
Re: Oversight in reparameterize_path_by_child leading to executor crash Robert Haas 18:30
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Robert Haas 18:34
Re: postgres_fdw fails to see that array type belongs to extension 📎 Tom Lane 19:01
Re: [PATCH] LockAcquireExtended improvement Robert Haas 19:07
Re: ALTER TYPE OWNER fails to recurse to multirange Robert Haas 19:17
Re: Oversight in reparameterize_path_by_child leading to executor crash Tom Lane 19:17
Re: ALTER TYPE OWNER fails to recurse to multirange Tom Lane 19:28
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Matthias van de Meent 19:32
Re: Built-in CTYPE provider Jeff Davis 19:42
Re: gai_strerror() is not thread-safe on Windows Robert Haas 19:52
Re: ALTER TYPE OWNER fails to recurse to multirange Robert Haas 20:01
Re: Forbid the use of invalidated physical slots in streaming replication. Robert Haas 20:17
Re: cleanup patches for incremental backup 📎 Matthias van de Meent 20:31
Re: Custom explain options Konstantin Knizhnik 20:42
Re: [17] CREATE SUBSCRIPTION ... SERVER Joe Conway 20:53
Re: Emit fewer vacuum records by reaping removable tuples during pruning Melanie Plageman 21:03
Re: Fixing backslash dot for COPY FROM...CSV Robert Haas 21:05
Re: [17] CREATE SUBSCRIPTION ... SERVER Jeff Davis 21:34
Re: make pg_ctl more friendly Nathan Bossart 21:39
Re: Add PQsendSyncMessage() to libpq Michael Paquier 23:28

Jan. 16, 2024

Thread Author Time
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) torikoshia 00:27
Re: Synchronizing slots from primary to standby Peter Smith 01:27
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already] Kirk Wolak 01:53
Re: [17] CREATE SUBSCRIPTION ... SERVER 📎 Jeff Davis 01:55
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 02:02
Re: Error "initial slot snapshot too large" in create replication slot Kyotaro Horiguchi 02:18
Re: make pg_ctl more friendly 📎 Junwang Zhao 02:32
Re: POC: GROUP BY optimization Richard Guo 02:48
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 02:53
Re: Make mesage at end-of-recovery less scary. Kyotaro Horiguchi 02:57
Re: Revise the Asserts added to bimapset manipulation functions 📎 David Rowley 03:08
Re: Add PQsendSyncMessage() to libpq 📎 Michael Paquier 03:32
Strange Bitmapset manipulation in DiscreteKnapsack() 📎 David Rowley 03:32
Re: Synchronizing slots from primary to standby shveta malik 03:33
Re: Emitting JSON to file using COPY TO 📎 jian he 03:46
Re: [17] CREATE SUBSCRIPTION ... SERVER Bharath Rupireddy 03:53
Re: Synchronizing slots from primary to standby Amit Kapila 04:07
Re: reorganize "Shared Memory and LWLocks" section of docs Bharath Rupireddy 04:32
Re: Synchronizing slots from primary to standby Dilip Kumar 04:33
Re: Add test module for Table Access Method Michael Paquier 04:58
Re: introduce dynamic shared memory registry Bharath Rupireddy 04:58
Re: Add test module for Table Access Method Bharath Rupireddy 05:15
Re: minor replication slot docs edits Bharath Rupireddy 06:08
Re: heavily contended lwlocks with long wait queues scale badly 📎 Michael Paquier 06:11
Re: Add test module for Table Access Method Japin Li 06:15
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 Masahiko Sawada 06:17
Re: speed up a logical replica setup 📎 Shubham Khanna 06:28
Re: [PATCH] Exponential backoff for auth_delay Abhijit Menon-Sen 06:30
RE: A failure in t/038_save_logical_slots_shutdown.pl Hayato Kuroda (Fujitsu) 06:43
Re: [HACKERS] Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING 📎 jian he 06:50
Re: Synchronizing slots from primary to standby Masahiko Sawada 07:28
Introduce a new API for TableAmRoutine Japin Li 07:44
Re: Emitting JSON to file using COPY TO jian he 07:45
Re: Revise the Asserts added to bimapset manipulation functions Richard Guo 08:00
Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bindx 📎 Anthonin Bonnefoy 08:13
Re: index prefetching Konstantin Knizhnik 08:13
Re: Synchronizing slots from primary to standby Bertrand Drouvot 08:42
Re: Oom on temp (un-analyzed table caused by JIT) V16.1 [Fixed Already] Daniel Gustafsson 08:43
Re: Proposal to add page headers to SLRU pages 📎 Li, Yong 09:12
Re: Strange Bitmapset manipulation in DiscreteKnapsack() Richard Guo 09:18
Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bindx Jelte Fennema-Nio 09:37
Re: Add test module for Table Access Method Aleksander Alekseev 09:39
Re: Synchronizing slots from primary to standby shveta malik 09:40

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 31