pgsql-hackers since 2022-01-21 20:23

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

Jan. 21, 2022

Thread	Author	Time
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	20:23
Re: How to get started with contribution	Stephen Frost	20:28
Re: POC: GROUP BY optimization 📎	Tomas Vondra	20:34
Re: How to get started with contribution	Tomas Vondra	20:41
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations	Peter Geoghegan	20:42
Re: How to get started with contribution	Stephen Frost	20:53
Re: Parallelize correlated subqueries that execute within each worker	Tom Lane	20:54
Re: Document atthasmissing default optimization avoids verification table scan	Andrew Dunstan	21:08
Re: A test for replay of regression tests	Andrew Dunstan	21:22
Re: Document atthasmissing default optimization avoids verification table scan	David G. Johnston	21:34
fairywren is generating bogus BASE_BACKUP commands	Robert Haas	21:42
Re: Document atthasmissing default optimization avoids verification table scan	Tom Lane	21:50
Re: fairywren is generating bogus BASE_BACKUP commands	Tom Lane	22:09
Re: fairywren is generating bogus BASE_BACKUP commands	Thomas Munro	22:10
Re: New developer papercut - Makefile references INSTALL	Andres Freund	22:11
Re: Proposal: allow database-specific role memberships 📎	Kenaniah Cerny	22:12
Re: New developer papercut - Makefile references INSTALL	Tom Lane	22:25
Re: fairywren is generating bogus BASE_BACKUP commands	Robert Haas	22:26
Re: Document atthasmissing default optimization avoids verification table scan	David G. Johnston	22:29
Re: fairywren is generating bogus BASE_BACKUP commands	Andrew Dunstan	22:35
Re: fairywren is generating bogus BASE_BACKUP commands	Tom Lane	22:35
Re: Document atthasmissing default optimization avoids verification table scan	Tom Lane	22:38
Re: do only critical work during single-user vacuum? 📎	John Naylor	22:41
Re: fairywren is generating bogus BASE_BACKUP commands	Tom Lane	22:42
Re: New developer papercut - Makefile references INSTALL	Andres Freund	22:53
Re: Synchronizing slots from primary to standby	Hsu, John	23:02
Re: fairywren is generating bogus BASE_BACKUP commands	Andres Freund	23:04
Re: Proposal: allow database-specific role memberships	David G. Johnston	23:04
Re: fairywren is generating bogus BASE_BACKUP commands	Robert Haas	23:21
Re: fairywren is generating bogus BASE_BACKUP commands	Andres Freund	23:28
Re: Document atthasmissing default optimization avoids verification table scan	James Coleman	23:29
Re: do only critical work during single-user vacuum?	Bossart, Nathan	23:32

Jan. 22, 2022

Thread	Author	Time
Re: Document atthasmissing default optimization avoids verification table scan 📎	James Coleman	00:14
Re: How to get started with contribution	vrund shah	02:42
Re: How to get started with contribution	vrund shah	02:47
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	02:54
Re: fairywren is generating bogus BASE_BACKUP commands	Robert Haas	02:55
Re: Proposal: allow database-specific role memberships 📎	Kenaniah Cerny	03:01
Re: How to get started with contribution	vrund shah	03:23
Re: fairywren is generating bogus BASE_BACKUP commands	Thomas Munro	03:43
Re: Schema variables - new implementation for Postgres 15	Julien Rouhaud	04:04
Re: row filtering for logical replication	Amit Kapila	04:21
Re: A test for replay of regression tests	Thomas Munro	05:00
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	05:30
Re: Document atthasmissing default optimization avoids verification table scan	David G. Johnston	05:35
Re: Refactoring of compression options in pg_basebackup 📎	Michael Paquier	05:46
Re: Skipping logical replication transactions on subscriber side	David G. Johnston	07:10
Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce)	Shruthi Gowda	07:17
Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) 📎	Shruthi Gowda	07:20
Re: BufferAlloc: don't take two simultaneous locks	Andrey Borodin	07:56
Re: Proposal: allow database-specific role memberships	Julien Rouhaud	09:10
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	09:41
Re: Logical replication timeout problem	Amit Kapila	11:11
Re: Document atthasmissing default optimization avoids verification table scan	James Coleman	13:18
Re: Proposal: allow database-specific role memberships 📎	Kenaniah Cerny	13:28
Re: Proposal: allow database-specific role memberships	Julien Rouhaud	14:56
Re: row filtering for logical replication	Alvaro Herrera	15:14
Re: Document atthasmissing default optimization avoids verification table scan	David G. Johnston	15:28
Re: fairywren is generating bogus BASE_BACKUP commands	Andrew Dunstan	16:00
Re: Skipping logical replication transactions on subscriber side	David G. Johnston	16:21
Re: Skipping logical replication transactions on subscriber side	David G. Johnston	16:47
Re: How to get started with contribution	Stephen Frost	17:28
pg_upgrade/test.sh and v9.5 📎	Justin Pryzby	18:37
Re: relcache not invalidated when ADD PRIMARY KEY USING INDEX	Tom Lane	18:38
Re: XLogReadRecord() error in XlogReadTwoPhaseData() 📎	Noah Misch	18:52
Re: autovacuum prioritization	Peter Geoghegan	19:48
Re: CREATEROLE and role ownership hierarchies	Stephen Frost	21:20
Re: Index Skip Scan (new UniqueKeys) 📎	Dmitry Dolgov	21:31
Re: MDAM techniques and Index Skip Scan patch	Dmitry Dolgov	21:37
Re: Parameter for planner estimate of recursive queries	Kenaniah Cerny	22:33
Re: Warning in geqo_main.c from clang 13 📎	Tom Lane	22:34

Jan. 23, 2022

Thread	Author	Time
Re: Collecting statistics about contents of JSONB columns 📎	Nikita Glukhov	00:24
Bug in ProcArrayApplyRecoveryInfo for snapshots crossing 4B, breaking replicas 📎	Tomas Vondra	00:42
Re: Warning in geqo_main.c from clang 13	Thomas Munro	00:47
Re: Parallelize correlated subqueries that execute within each worker 📎	James Coleman	01:25
Re: [Proposal] Add foreign-server health checks infrastructure	Fujii Masao	05:36
Re: Schema variables - new implementation for Postgres 15	Julien Rouhaud	08:10
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	08:25
Re: Schema variables - new implementation for Postgres 15	Julien Rouhaud	08:52
Re: [PATCH] reduce page overlap of GiST indexes built using sorted method	Andrey Borodin	09:33
Re: WIP: System Versioned Temporal Table	Trevor Gross	10:56
Re: Fix BUG #17335: Duplicate result rows in Gather node 📎	Yura Sokolov	11:56
current_schema will not use an text index ?	Marcos Pegoraro	14:00
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	14:33
Re: Schema variables - new implementation for Postgres 15	Julien Rouhaud	15:06
Re: current_schema will not use an text index ?	Tom Lane	15:16
Re: Warning in geqo_main.c from clang 13	Tom Lane	16:12
PSA: Autoconf has risen from the dead	Tom Lane	16:29
Re: psql - add SHOW_ALL_RESULTS option	Fabien COELHO	17:17
Re: fairywren is generating bogus BASE_BACKUP commands 📎	Andrew Dunstan	17:20
Re: PSA: Autoconf has risen from the dead	Joel Jacobson	18:13
Bogus duplicate command issued in pg_dump 📎	Tom Lane	18:31
Re: PSA: Autoconf has risen from the dead	Tom Lane	18:35
Re: Bogus duplicate command issued in pg_dump	David G. Johnston	19:39
Re: fairywren is generating bogus BASE_BACKUP commands	Robert Haas	19:48
Re: Bogus duplicate command issued in pg_dump	Tom Lane	19:59
Re: fairywren is generating bogus BASE_BACKUP commands	Tom Lane	20:07
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Thomas Munro	20:42
Re: Replace uses of deprecated Python module distutils.sysconfig 📎	Tom Lane	21:06
Re: fairywren is generating bogus BASE_BACKUP commands	Andrew Dunstan	21:09
Re: fairywren is generating bogus BASE_BACKUP commands	Tom Lane	21:15
Re: Support for NSS as a libpq TLS backend	Andres Freund	21:20
Re: fairywren is generating bogus BASE_BACKUP commands	Andres Freund	21:31
Re: row filtering for logical replication	Peter Smith	21:36
Re: Avoiding smgrimmedsync() during nbtree index builds	Andres Freund	21:55
Re: pg_basebackup fsyncs some files despite --no-sync (was: Adding CI to our tree)	Andres Freund	22:11
Re: [PATCH] reduce page overlap of GiST indexes built using sorted method	Andres Freund	22:17
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Andres Freund	22:26
Re: fairywren is generating bogus BASE_BACKUP commands	Andrew Dunstan	22:38
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	22:59
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	23:07
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	23:11
Re: WIP: System Versioned Temporal Table	Corey Huinker	23:16
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	23:19
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	23:24
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Noah Misch	23:29
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	23:31
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	23:46
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Thomas Munro	23:49
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	23:53

Jan. 24, 2022

Thread	Author	Time
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	00:00
Re: fairywren is generating bogus BASE_BACKUP commands	Andres Freund	00:13
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Noah Misch	00:19
Re: Index Skip Scan (new UniqueKeys)	Zhihong Yu	00:25
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Tom Lane	00:28
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	00:42
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Andres Freund	01:03
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Noah Misch	01:17
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Andres Freund	01:40
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	01:50
Re: pg_upgrade should truncate/remove its logs before running 📎	Michael Paquier	01:59
Re: XLogReadRecord() error in XlogReadTwoPhaseData() 📎	Noah Misch	02:10
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Michael Paquier	02:20
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	02:24
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Tom Lane	02:25
Re: Bogus duplicate command issued in pg_dump	Michael Paquier	02:25
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	02:31
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Andres Freund	02:34
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Andres Freund	02:38
Re: Replace uses of deprecated Python module distutils.sysconfig	Andres Freund	02:53
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	02:53
Re: row filtering for logical replication	Amit Kapila	02:53
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	02:57
Re: On login trigger: take three 📎	Greg Nancarrow	02:59
typos 📎	Justin Pryzby	03:00
Re: Replace uses of deprecated Python module distutils.sysconfig	Tom Lane	03:03
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	03:06
makefiles writing to $@ should first write to [email protected]	Justin Pryzby	03:23
Re: Catalog version access	Michael Paquier	03:30
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	03:34
Re: makefiles writing to $@ should first write to [email protected]	Michael Paquier	03:41
Re: row filtering for logical replication	Amit Kapila	03:47
Re: Replace uses of deprecated Python module distutils.sysconfig 📎	Andres Freund	03:49
Re: fairywren is generating bogus BASE_BACKUP commands	Robert Haas	03:52
Re: [PATCH] Implement INSERT SET syntax 📎	Justin Pryzby	03:58
Re: [BUG]Update Toast data failure in logical replication	Michael Paquier	03:58
Re: makefiles writing to $@ should first write to [email protected]	Julien Rouhaud	04:07
Re: Bogus duplicate command issued in pg_dump	David G. Johnston	04:20
Re: Skipping logical replication transactions on subscriber side	David G. Johnston	04:48
Re: row filtering for logical replication	Greg Nancarrow	04:59
Re: POC: GROUP BY optimization	Andrey Lepikhov	05:02
Re: RFC: Logging plan of the running query 📎	torikoshia	05:33
Re: row filtering for logical replication	Greg Nancarrow	05:48
Re: row filtering for logical replication	Peter Smith	05:53
RE: Skipping logical replication transactions on subscriber side	[email protected]	05:55
Re: row filtering for logical replication	Peter Smith	06:04
Re: row filtering for logical replication	Amit Kapila	06:09
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	06:54
Re: typos	Michael Paquier	07:01
Re: typos	Justin Pryzby	07:07
Error running configure on Mac	samay sharma	07:07
Re: Error running configure on Mac	Tom Lane	07:14
Re: [PATCH] Full support for index LP_DEAD hint bits on standby 📎	Michail Nikolaev	07:33
Re: Printing backtrace of postgres processes	torikoshia	07:35
Re: Error running configure on Mac 📎	samay sharma	07:44
Re: row filtering for logical replication	Greg Nancarrow	07:49
Re: typos	Michael Paquier	07:55
Re: Skipping logical replication transactions on subscriber side	David G. Johnston	07:59
Re: XLogReadRecord() error in XlogReadTwoPhaseData()	Noah Misch	08:02
Re: Error running configure on Mac	Andres Freund	08:09
Re: PSA: Autoconf has risen from the dead	Peter Eisentraut	08:11
Re: PSA: Autoconf has risen from the dead	Andres Freund	08:17
Re: BufferAlloc: don't take two simultaneous locks	Kyotaro Horiguchi	08:19
Re: row filtering for logical replication	Peter Smith	08:37
Re: Non-decimal integer literals 📎	Peter Eisentraut	08:41
Re: row filtering for logical replication	Amit Kapila	09:32
Re: Support tab completion for upper character inputs in psql	Peter Eisentraut	09:35
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	09:42
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	09:54
DSA failed to allocate memory 📎	Dongming Liu	09:58
Re: Make mesage at end-of-recovery less scary.	Pavel Borisov	10:23
RE: drop tablespace failed when location contains .. on win32 📎	[email protected]	11:21
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	11:33
Re: drop tablespace failed when location contains .. on win32	Michael Paquier	11:46
Re: [BUG]Update Toast data failure in logical replication	Amit Kapila	12:05
Re: missing indexes in indexlist with partitioned tables	Arne Roland	12:29
Re: Add 64-bit XIDs into PostgreSQL 15 📎	Pavel Borisov	12:38
Re: Fix BUG #17335: Duplicate result rows in Gather node 📎	Yura Sokolov	13:24
Re: Skipping logical replication transactions on subscriber side	Peter Eisentraut	14:06
Re: Skipping logical replication transactions on subscriber side	Peter Eisentraut	14:10

Browse Archives

Prev | Next