pgsql-hackers since 2021-11-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)

Advanced Search

Browse Archives

Prev | Next

Nov. 4, 2021

Thread	Author	Time
Re: Added schema level support for publication.	Peter Smith	00:11
Re: pgbench bug candidate: negative "initial connection time"	Yugo NAGATA	00:31
Re: Failed transaction statistics to measure the logical replication progress	Greg Nancarrow	00:53
RE: Added schema level support for publication.	houzj.fnst@fujitsu.com	00:55
Re: Added schema level support for publication.	Peter Smith	01:39
Re: Logical insert/update/delete WAL records for custom table AMs	Jeff Davis	01:39
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	近藤雄太	01:56
Re: Consider parallel for lateral subqueries with limit	Greg Nancarrow	02:06
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Michael Paquier	02:16
Re: extended stats on partitioned tables 📎	Justin Pryzby	02:20
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Thomas Munro	02:39
Re: row filtering for logical replication	Peter Smith	02:46
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Thomas Munro	02:56
Re: row filtering for logical replication	Amit Kapila	03:08
RE: row filtering for logical replication	houzj.fnst@fujitsu.com	03:21
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Tom Lane	03:33
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Thomas Munro	03:37
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Tom Lane	03:45
Re: enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes	Bharath Rupireddy	04:05
Re: Data is copied twice when specifying both child and parent table in publication	Amit Kapila	04:13
Re: Added schema level support for publication. 📎	vignesh C	04:23
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 📎	Bharath Rupireddy	04:24
Re: row filtering for logical replication	Peter Smith	05:19
Re: parallel vacuum comments 📎	Masahiko Sawada	05:24
Re: Added schema level support for publication.	Peter Smith	05:35
Re: Data is copied twice when specifying both child and parent table in publication	Greg Nancarrow	06:53
Re: CREATEROLE and role ownership hierarchies	Shinya Kato	07:00
Re: Teach pg_receivewal to use lz4 compression 📎	Michael Paquier	07:31
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Michael Paquier	07:38
Re: should we enable log_checkpoints out of the box?	Michael Paquier	07:41
Re: Add proper planner support for ORDER BY / DISTINCT aggregates	Ronan Dunklau	07:59
Re: Data is copied twice when specifying both child and parent table in publication	Amit Kapila	08:10
Re: Teach pg_receivewal to use lz4 compression 📎	Michael Paquier	08:21
Re: Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	08:46
[sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE	Andreas Seltenreich	08:46
Re: CREATE ROLE IF NOT EXISTS	Daniel Gustafsson	08:53
Re: Logical insert/update/delete WAL records for custom table AMs	Amit Kapila	09:03
Re: [patch] [doc] Further note required activity aspect of automatic checkpoint and archving	Daniel Gustafsson	09:36
Re: Teach pg_receivewal to use lz4 compression	gkokolatos	09:53
Re: Columns correlation and adaptive query optimization	Daniel Gustafsson	09:56
Re: Make Append Cost aware of some run time partition prune case	Daniel Gustafsson	10:10
Re: [PATCH] Added TRANSFORM FOR for COMMENT tab completion 📎	Ken Kato	10:18
Re: partial heap only tuples	Daniel Gustafsson	10:23
Re: Printing backtrace of postgres processes	Daniel Gustafsson	10:36
Re: [PATCH] rename column if exists	Daniel Gustafsson	10:46
Re: [PATCH] More docs on what to do and not do in extension code	Daniel Gustafsson	10:55
Re: PROXY protocol support 📎	Magnus Hagander	11:03
RE: Allow escape in application_name 📎	kuroda.hayato@fujitsu.com	11:42
Re: lastOverflowedXid does not handle transaction ID wraparound	Simon Riggs	11:45
Re: Add missing function abs (interval)	Daniel Gustafsson	12:08
Re: [PROPOSAL] new diagnostic items for the dynamic sql	Daniel Gustafsson	12:09
Re: LogwrtResult contended spinlock	Daniel Gustafsson	12:12
Re: should INSERT SELECT use a BulkInsertState?	Daniel Gustafsson	12:24
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Daniel Gustafsson	12:34
Re: pgbench logging broken by time logic changes	Daniel Gustafsson	12:38
Re: RFC: Logging plan of the running query	torikoshia	12:49
Re: Supply restore_command to pg_rewind via CLI argument	Daniel Gustafsson	12:55
Re: Automatic notification of top transaction IDs	Daniel Gustafsson	13:05
Re: [PATCH] rename column if exists	David G. Johnston	13:26
Possible Documentation Update for ALTER STATISTICS	Ahmet Gedemenli	13:35
Re: pg14 psql broke \d datname.nspname.relname	Hamlin, Garick L	13:37
Re: Missing include <openssl/x509.h> in be-secure-openssl.c?	Tom Lane	13:54
Re: Extending amcheck to check toast size and compression	Robert Haas	14:53
Re: should we enable log_checkpoints out of the box? 📎	Bharath Rupireddy	14:58
Re: Automatic notification of top transaction IDs	Robert Haas	15:01
Re: should we enable log_checkpoints out of the box?	Robert Haas	15:04
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎	Andrey Borodin	15:52
Re: Skipping logical replication transactions on subscriber side	vignesh C	15:57
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM?	Peter Geoghegan	15:58
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. 📎	Jeff Davis	16:03
Re: pg14 psql broke \d datname.nspname.relname	Mark Dilger	16:08
Re: WIP: expression evaluation improvements	Robert Haas	16:30
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Robert Haas	16:37
Re: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE	Justin Pryzby	16:53
Re: Teach pg_receivewal to use lz4 compression 📎	gkokolatos	17:02
Re: should we enable log_checkpoints out of the box?	Fujii Masao	17:20
Re: should we enable log_checkpoints out of the box? 📎	Bharath Rupireddy	17:49
Re: Allow escape in application_name	Fujii Masao	18:14
Re: [RFC] building postgres with meson -v 📎	Peter Eisentraut	18:17
Re: [RFC] building postgres with meson -v	Andres Freund	18:48
Re: Time to drop plpython2?	Peter Eisentraut	18:58
Re: parallel vacuum comments	Andres Freund	19:00
Re: parallel vacuum comments	Peter Geoghegan	19:42
Re: Time to drop plpython2?	Andres Freund	19:54
Re: should we enable log_checkpoints out of the box?	Andres Freund	20:04
Re: Time to drop plpython2?	Tom Lane	20:26
Re: pglz compression performance, take two 📎	Tomas Vondra	20:47
Re: parallel vacuum comments	Peter Geoghegan	21:25
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Jeff Davis	21:25
Re: Possible Documentation Update for ALTER STATISTICS 📎	Tomas Vondra	22:07
Re: inefficient loop in StandbyReleaseLockList()	Andres Freund	22:12
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Andres Freund	22:42
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Andres Freund	22:46
Re: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE	Tomas Vondra	22:56
Re: Extending amcheck to check toast size and compression 📎	Mark Dilger	22:58
Re: Logical insert/update/delete WAL records for custom table AMs	Jeff Davis	23:23
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Jeff Davis	23:35
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Jeff Davis	23:38
Re: WIP: expression evaluation improvements	Andres Freund	23:47

Nov. 5, 2021

Thread	Author	Time
Re: pgsql: Fix WAL replay in presence of an incomplete record	Tom Lane	00:13
Re: inefficient loop in StandbyReleaseLockList()	Tom Lane	00:21
Re: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE	Tomas Vondra	01:09
Re: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE 📎	Tomas Vondra	01:10
RE: parallel vacuum comments	houzj.fnst@fujitsu.com	02:15
Re: inefficient loop in StandbyReleaseLockList()	Michael Paquier	02:40
Re: Teach pg_receivewal to use lz4 compression	Michael Paquier	02:47
Re: inefficient loop in StandbyReleaseLockList()	Tom Lane	02:47
Re: Allow escape in application_name	Kyotaro Horiguchi	03:17
Re: Data is copied twice when specifying both child and parent table in publication	Greg Nancarrow	03:20
Re: [PATCH] Added TRANSFORM FOR for COMMENT tab completion 📎	Ken Kato	03:31
Re: On login trigger: take three	Greg Nancarrow	04:03
Re: Add missing function abs (interval)	Isaac Morland	04:06
Re: Logical insert/update/delete WAL records for custom table AMs	Amit Kapila	04:30
Re: row filtering for logical replication 📎	Peter Smith	05:13
Re: row filtering for logical replication	Peter Smith	05:18
Re: row filtering for logical replication	Peter Smith	05:20
Re: row filtering for logical replication	Peter Smith	05:21
Re: row filtering for logical replication	Peter Smith	05:27
Re: parallel vacuum comments	Masahiko Sawada	05:28
Re: enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes 📎	Bharath Rupireddy	05:42
Re: parallel vacuum comments	Masahiko Sawada	05:45
Re: pglz compression performance, take two 📎	Andrey Borodin	05:50
consistently use "ProcSignal" instead of "procsignal" in code comments 📎	Bharath Rupireddy	05:52
Re: [PATCH] Added TRANSFORM FOR for COMMENT tab completion	Michael Paquier	06:30
Re: Map WAL segment files on PMEM as WAL buffers 📎	Takashi Menjo	06:47
Re: lastOverflowedXid does not handle transaction ID wraparound	Kyotaro Horiguchi	07:31
RE: Added schema level support for publication.	houzj.fnst@fujitsu.com	07:44
Re: Teach pg_receivewal to use lz4 compression	gkokolatos	07:50
RE: Failed transaction statistics to measure the logical replication progress 📎	osumi.takamichi@fujitsu.com	08:11
Re: row filtering for logical replication	Amit Kapila	08:49
Re: [PATCH] rename column if exists	Daniel Gustafsson	09:21
Re: [PATCH] Added TRANSFORM FOR for COMMENT tab completion	Daniel Gustafsson	09:39
Re: Support for NSS as a libpq TLS backend 📎	Daniel Gustafsson	10:01
Re: Supply restore_command to pg_rewind via CLI argument 📎	Andrey Borodin	10:10
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM?	Andrey Borodin	10:26
Re: Feature request for adoptive indexes	Hayk Manukyan	11:17
Re: [PATCH] rename column if exists	Isaac Morland	12:03
Re: pgsql: Fix WAL replay in presence of an incomplete record	Alvaro Herrera	12:06
Re: [PATCH] rename column if exists	Daniel Gustafsson	12:07
Re: pgsql: Fix WAL replay in presence of an incomplete record	Alvaro Herrera	12:28
Re: WIP: expression evaluation improvements	Robert Haas	12:34
Re: [PATCH] Added TRANSFORM FOR for COMMENT tab completion	Michael Paquier	12:35
Re: [PATCH] Added TRANSFORM FOR for COMMENT tab completion	Fujii Masao	12:36
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Robert Haas	12:40
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Robert Haas	12:42
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Robert Haas	12:54
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.	Alvaro Herrera	13:13
Re: pg14 psql broke \d datname.nspname.relname	Alvaro Herrera	13:33
Re: Extending amcheck to check toast size and compression	Robert Haas	13:34
Re: removing global variable ThisTimeLineID	Alvaro Herrera	13:49
Re: pg14 psql broke \d datname.nspname.relname	Tom Lane	13:59
Re: remove internal support in pgcrypto?	Peter Eisentraut	14:04
Re: remove internal support in pgcrypto?	Daniel Gustafsson	14:12
Re: [PATCH] rename column if exists	David G. Johnston	14:22
Re: should we enable log_checkpoints out of the box?	Alvaro Herrera	14:27
Re: should we enable log_checkpoints out of the box?	Michael Banck	14:29
Re: pg14 psql broke \d datname.nspname.relname	Robert Haas	14:37
Re: [PATCH] rename column if exists	Tom Lane	14:40
Re: Parallel vacuum workers prevent the oldest xmin from advancing	Matthias van de Meent	14:45
Re: should we enable log_checkpoints out of the box?	Alvaro Herrera	14:50
Re: pg14 psql broke \d datname.nspname.relname	Mark Dilger	14:58
Re: [PATCH] rename column if exists	David G. Johnston	15:00
Re: should we enable log_checkpoints out of the box?	Robert Haas	15:04
Re: [PATCH] rename column if exists	Tom Lane	15:08
Re: should we enable log_checkpoints out of the box?	Bruce Momjian	15:26
Re: should we enable log_checkpoints out of the box?	Jan Wieck	15:36
Re: [PATCH] rename column if exists	Robert Haas	15:37
Re: [PATCH] rename column if exists	David G. Johnston	15:47
Re: refactoring basebackup.c 📎	Robert Haas	15:50
Re: [PATCH] rename column if exists	David G. Johnston	15:58
Re: WIP: expression evaluation improvements	Andres Freund	16:48
Re: [PATCH] Full support for index LP_DEAD hint bits on standby 📎	Michail Nikolaev	16:51
Re: removing global variable ThisTimeLineID	Robert Haas	16:58
Re: WIP: expression evaluation improvements	Robert Haas	17:09
Re: WIP: expression evaluation improvements	Andres Freund	17:20
Re: WIP: expression evaluation improvements	Andres Freund	17:27
Re: WIP: expression evaluation improvements	Robert Haas	18:13
Re: [PROPOSAL] new diagnostic items for the dynamic sql 📎	Dinesh Chemuduru	18:27
Commitfest 2021-11 Patch Triage - Part 1	Daniel Gustafsson	21:15
Re: Portability report: ninja	Andres Freund	21:42
Re: jsonb crash	Justin Pryzby	22:38
Re: WIP: expression evaluation improvements	Andres Freund	23:01

Nov. 6, 2021

Thread	Author	Time
Draft release notes for next week's releases	Tom Lane	00:27
Re: Commitfest 2021-11 Patch Triage - Part 1	Andy Fan	01:00
Re: Commitfest 2021-11 Patch Triage - Part 1	Andy Fan	01:12
Re: Schema variables - new implementation for Postgres 15 📎	Justin Pryzby	01:39
Re: [PATCH] Don't block HOT update by BRIN index 📎	Tomas Vondra	02:16
Re: Draft release notes for next week's releases	Justin Pryzby	02:48
amcheck's verify_heapam(), and HOT chain verification	Peter Geoghegan	02:51
Re: amcheck's verify_heapam(), and HOT chain verification	Mark Dilger	03:18
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	03:45
Re: Extending amcheck to check toast size and compression	Tom Lane	03:56
Re: Extending amcheck to check toast size and compression	Mark Dilger	08:04
AW: VS2022: Support Visual Studio 2022 on Windows 📎	Hans Buschmann	09:29
Re: using extended statistics to improve join estimates	Andy Fan	10:03
Re: Draft release notes for next week's releases	Tom Lane	13:34
Re: Schema variables - new implementation for Postgres 15	Justin Pryzby	14:57
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	15:40
Re: GiST operator class for bool	Tomas Vondra	16:09
Re: lastOverflowedXid does not handle transaction ID wraparound	Alexander Korotkov	16:16

Browse Archives

Prev | Next