pgsql-hackers since 2023-10-03 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

Oct. 3, 2023

Thread Author Time
Re: CHECK Constraint Deferrable Andreas Joseph Krogh 00:06
Re: CHECK Constraint Deferrable Tom Lane 00:08
Re: Add support for AT LOCAL Vik Fearing 00:10
Re: Allow deleting enumerated values from an existing enumerated data type Vik Fearing 00:21
Re: Invalidate the subscription worker in cases where a user loses their superuser status Peter Smith 00:39
[PGDOCS] Inconsistent linkends to "monitoring" views. 📎 Peter Smith 02:11
Re: Fixup some more appendStringInfo misusages David Rowley 04:13
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Bharath Rupireddy 04:28
Re: [PoC] pg_upgrade: allow to upgrade publisher node Dilip Kumar 04:42
Differences between = ANY and IN? Maciek Sakrejda 05:01
Re: Making aggregate deserialization (and WAL receive) functions slightly faster 📎 David Rowley 05:02
Re: Differences between = ANY and IN? Tom Lane 05:15
Re: pg_stat_statements and "IN" conditions Maciek Sakrejda 06:24
Re: Differences between = ANY and IN? Maciek Sakrejda 06:34
Re: Fail hard if xlogreader.c fails on out-of-memory Michael Paquier 06:39
Re: Invalidate the subscription worker in cases where a user loses their superuser status 📎 vignesh C 06:42
Re: Invalidate the subscription worker in cases where a user loses their superuser status Peter Smith 06:51
Re: pg_stat_get_activity(): integer overflow due to (int) * (int) for MemoryContextAllocHuge() Michael Paquier 07:08
Re: pg16: XX000: could not find pathkey item to sort 📎 David Rowley 07:16
Re: Incorrect handling of OOM in WAL replay leading to data loss 📎 Michael Paquier 07:20
Re: Trigger violates foreign key constraint 📎 Laurenz Albe 07:24
Re: [PGDOCS] Inconsistent linkends to "monitoring" views. Michael Paquier 07:30
Re: [PATCH] Fix memory leak in memoize for numeric key 📎 David Rowley 08:51
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Bharath Rupireddy 09:21
Re: Doc: Minor update for enable_partitionwise_aggregate Ashutosh Bapat 09:32
Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} 📎 Nazir Bilal Yavuz 09:37
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 09:40
Re: [PGDOCS] Inconsistent linkends to "monitoring" views. Peter Smith 09:40
Re: Improvements in pg_dump/pg_restore toc format and performances vignesh C 09:47
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 10:09
Modernize const handling with readline 📎 Peter Eisentraut 10:23
Re: Skip collecting decoded changes of already-aborted transactions vignesh C 10:24
Re: Synchronizing slots from primary to standby Amit Kapila 10:54
Re: Modernize const handling with readline Aleksander Alekseev 11:28
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎 Andrei Lepikhov 11:33
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Drouvot, Bertrand 12:15
Re: bgwriter doesn't flush WAL stats Nazir Bilal Yavuz 13:08
Re: remaining sql/json patches Amit Langote 13:11
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning 📎 Ashutosh Bapat 13:12
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Bharath Rupireddy 13:32
RE: Synchronizing slots from primary to standby 📎 Hayato Kuroda (Fujitsu) 13:42
Re: On login trigger: take three Daniel Gustafsson 13:43
Re: unnest multirange, returned order Laurenz Albe 13:46
Re: CHECK Constraint Deferrable David G. Johnston 13:53
Re: Modernize const handling with readline Tom Lane 14:10
Re: On login trigger: take three Robert Haas 14:21
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 14:26
Re: trying again to get incremental backup Robert Haas 15:03
Re: Allow deleting enumerated values from an existing enumerated data type Tom Lane 15:44
Re: Allow deleting enumerated values from an existing enumerated data type Vik Fearing 15:49
Re: Remove IndexInfo.ii_OpclassOptions field Peter Eisentraut 15:56
Re: Synchronizing slots from primary to standby shveta malik 15:57
Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} Robert Haas 16:44
Re: Annoying build warnings from latest Apple toolchain Tom Lane 17:34
Re: On login trigger: take three Alexander Korotkov 17:35
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector 📎 Karl O. Pinc 17:52
Re: RFC: Logging plan of the running query James Coleman 18:00
Re: trying again to get incremental backup 📎 Robert Haas 18:21
Re: Pre-proposal: unicode normalized text Jeff Davis 19:15
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 📎 James Coleman 19:35
Re: Pre-proposal: unicode normalized text Jeff Davis 19:54
Re: Annoying build warnings from latest Apple toolchain 📎 Tom Lane 20:07
Re: Pre-proposal: unicode normalized text Nico Williams 20:15
Re: Allow deleting enumerated values from an existing enumerated data type Matthias van de Meent 21:14
Re: Allow deleting enumerated values from an existing enumerated data type Tom Lane 21:46
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector David G. Johnston 21:51
Re: Index range search optimization Pavel Borisov 21:58
Re: Pre-proposal: unicode normalized text Jeff Davis 22:34
Re: Pre-proposal: unicode normalized text Jeff Davis 22:55
Re: Pre-proposal: unicode normalized text Nico Williams 23:01
Re: Improve WALRead() to suck data directly from WAL buffers when possible Jeff Davis 23:05
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector Karl O. Pinc 23:15
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 23:17
Re: Add support for AT LOCAL Michael Paquier 23:28

Oct. 4, 2023

Thread Author Time
Re: Index range search optimization Alexander Korotkov 00:00
Re: pgstatindex vs. !indisready Michael Paquier 00:00
Re: Synchronizing slots from primary to standby Amit Kapila 00:05
Re: False "pg_serial": apparent wraparound” in logs Michael Paquier 00:07
Re: Removing unneeded self joins Alexander Korotkov 00:12
Re: unnest multirange, returned order Daniel Fredouille 00:40
Re: make add_paths_to_append_rel aware of startup cost 📎 David Rowley 00:41
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 01:00
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector David G. Johnston 02:00
回复: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Thomas wen 02:57
Re: Synchronizing slots from primary to standby Peter Smith 03:22
Re: Making aggregate deserialization (and WAL receive) functions slightly faster Michael Paquier 03:57
Re: Synchronizing slots from primary to standby shveta malik 04:26
Re: Synchronizing slots from primary to standby shveta malik 05:00
Re: Synchronizing slots from primary to standby shveta malik 05:54
Re: Row pattern recognition 📎 Tatsuo Ishii 06:03
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Michael Paquier 06:20
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector David G. Johnston 06:25
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 06:25
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 06:38
Re: Making aggregate deserialization (and WAL receive) functions slightly faster David Rowley 06:47
Re: Removing unneeded self joins Andrei Lepikhov 06:55
Re: unnest multirange, returned order Laurenz Albe 07:20
Re: Removing unneeded self joins Alexander Korotkov 07:34
RE: [PATCH] Fix memory leak in memoize for numeric key Orlov Aleksej 08:08
Re: Rethink the wait event names for postgres_fdw, dblink and etc Michael Paquier 08:19
Re: [PATCH] Add CANONICAL option to xmlserialize vignesh C 09:39
Is the logfile the only place to find the finish LSN? pgchem pgchem 09:56
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov 10:22
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Drouvot, Bertrand 10:54
Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) Tomas Vondra 11:04
Re: Synchronizing slots from primary to standby Amit Kapila 11:30
Re: Invalidate the subscription worker in cases where a user loses their superuser status Shlok Kyal 11:31
Re: Synchronizing slots from primary to standby shveta malik 11:50
Re: Synchronizing slots from primary to standby shveta malik 11:55
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 12:04
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Peter Geoghegan 12:07
Re: Eager page freeze criteria clarification Peter Geoghegan 12:16
--sync-method isn't documented to take an argument Robert Haas 13:08
Re: --sync-method isn't documented to take an argument Daniel Gustafsson 13:15
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers Robert Haas 13:17
Re: --sync-method isn't documented to take an argument Robert Haas 13:22
Re: remaining sql/json patches Amit Langote 13:26
Re: Infinite Interval Ashutosh Bapat 13:29
Re: --sync-method isn't documented to take an argument Daniel Gustafsson 13:34
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers James Coleman 13:35
Re: Document efficient self-joins / UPDATE LIMIT techniques. Laurenz Albe 13:39
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers Robert Haas 13:42
Re: Request for comment on setting binary format output per session Peter Eisentraut 14:17
Re: --sync-method isn't documented to take an argument Alvaro Herrera 14:35
Re: Modernize const handling with readline Peter Eisentraut 14:37
Re: --sync-method isn't documented to take an argument Robert Haas 14:39
Re: --sync-method isn't documented to take an argument Tom Lane 14:39
Re: Add support for AT LOCAL 📎 Vik Fearing 14:49
Re: --sync-method isn't documented to take an argument Daniel Gustafsson 14:49
Re: --sync-method isn't documented to take an argument Tom Lane 14:51
Re: stopgap fix for signal handling during restore_command Nathan Bossart 14:52
Re: --sync-method isn't documented to take an argument Nathan Bossart 14:56
Re: --sync-method isn't documented to take an argument Daniel Gustafsson 14:56
Re: --sync-method isn't documented to take an argument Alvaro Herrera 15:00
Re: --sync-method isn't documented to take an argument Tom Lane 15:07
Re: Modernize const handling with readline 📎 Aleksander Alekseev 15:09
Re: --sync-method isn't documented to take an argument Daniel Gustafsson 15:16
Re: --sync-method isn't documented to take an argument 📎 Nathan Bossart 15:27
Re: should frontend tools use syncfs() ? Nathan Bossart 15:29
Re: --sync-method isn't documented to take an argument Robert Haas 15:51
Re: --sync-method isn't documented to take an argument Nathan Bossart 16:12
Re: [PATCH] Add CANONICAL option to xmlserialize 📎 Jim Jones 16:19
Re: --sync-method isn't documented to take an argument Tom Lane 16:24
Re: Request for comment on setting binary format output per session Merlin Moncure 16:26
Re: Pre-proposal: unicode normalized text Robert Haas 17:16
Re: Pre-proposal: unicode normalized text Nico Williams 17:23
Re: Pre-proposal: unicode normalized text Robert Haas 17:47
Re: Pre-proposal: unicode normalized text Chapman Flack 18:02
Re: Pre-proposal: unicode normalized text Robert Haas 18:05
Re: Pre-proposal: unicode normalized text Isaac Morland 18:14
Re: Request for comment on setting binary format output per session Dave Cramer 18:30
Re: Request for comment on setting binary format output per session Robert Haas 19:10
Re: POC, WIP: OR-clause support for indexes 📎 a.rybakina 19:19
Re: trying again to get incremental backup Robert Haas 19:33
Re: --sync-method isn't documented to take an argument Nathan Bossart 19:50
Add annotation syntax to pg_hba.conf entries Jim Jones 20:03
Re: trying again to get incremental backup 📎 Robert Haas 20:08
Re: Pre-proposal: unicode normalized text Jeff Davis 20:15
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 20:18
Re: Add annotation syntax to pg_hba.conf entries Robert Haas 20:18
Re: Pre-proposal: unicode normalized text Jeff Davis 20:38
Re: Opportunistically pruning page before update 📎 James Coleman 21:01
Re: [PATCH] Add CANONICAL option to xmlserialize Chapman Flack 21:05
Re: Pre-proposal: unicode normalized text Nico Williams 21:15
Re: Pre-proposal: unicode normalized text Chapman Flack 21:32
Re: Pre-proposal: unicode normalized text Jeff Davis 21:37
Re: Pre-proposal: unicode normalized text Nico Williams 22:15
Re: Add annotation syntax to pg_hba.conf entries Tom Lane 22:55
Re: Pre-proposal: unicode normalized text Jeff Davis 23:01
Re: Pre-proposal: unicode normalized text Nico Williams 23:43

Oct. 5, 2023

Thread Author Time
Re: unnest multirange, returned order Daniel Fredouille 00:04
Re: unnest multirange, returned order Daniel Fredouille 00:12
Re: Pre-proposal: unicode normalized text Isaac Morland 01:02
Re: make add_paths_to_append_rel aware of startup cost Andy Fan 01:11
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 📎 James Coleman 01:12
Re: Rethink the wait event names for postgres_fdw, dblink and etc Michael Paquier 01:28
Good News Everyone! + feature proposal Jon Erdman 02:22
post-recovery amcheck expectations 📎 Noah Misch 02:52
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Michael Paquier 05:10
Re: [HACKERS] Logical replication and multimaster Jon Erdman 05:14
Re: Making aggregate deserialization (and WAL receive) functions slightly faster Michael Paquier 05:23
Re: [HACKERS] Logical replication and multimaster Jon Erdman 05:31
Re: [PoC/RFC] Multiple passwords, interval expirations Gurjeet Singh 05:41
Re: pg16: XX000: could not find pathkey item to sort 📎 David Rowley 06:26
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Drouvot, Bertrand 06:46
Re: unnest multirange, returned order 📎 Laurenz Albe 06:50
Re: Extract numeric filed in JSONB more effectively Andy Fan 06:53
Re: Modernize const handling with readline Peter Eisentraut 06:57
Re: Removing unneeded self joins Andrei Lepikhov 07:20
Re: [PATCH] Fix memory leak in memoize for numeric key David Rowley 07:33
Re: [PATCH] Add CANONICAL option to xmlserialize 📎 Jim Jones 07:38
Re: Remove MSVC scripts from the tree Peter Eisentraut 07:38
Re: make add_paths_to_append_rel aware of startup cost David Rowley 08:04
Re: Making aggregate deserialization (and WAL receive) functions slightly faster David Rowley 08:24
Re: Synchronizing slots from primary to standby 📎 Ajin Cherian 08:54
Re: [PoC] pg_upgrade: allow to upgrade publisher node Dilip Kumar 08:58
Re: pgsql: Some refactoring to export json(b) conversion functions Alvaro Herrera 09:13
Re: Removing unneeded self joins 📎 Andrei Lepikhov 09:17
Re: Good News Everyone! + feature proposal Laurenz Albe 09:22
Re: Good News Everyone! + feature proposal Aleksander Alekseev 09:24

Browse Archives

Prev | Next