pgsql-hackers - October 2023

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

Oct. 1, 2023

Thread Author Time
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector 📎 Karl O. Pinc 00:47
Re: POC: GROUP BY optimization 📎 Andrei Lepikhov 06:32
Re: make add_paths_to_append_rel aware of startup cost Andy Fan 08:26
Skip Orderby Execution for Materialized Views 📎 Zhang Mingli 14:44
Re: Skip Orderby Execution for Materialized Views Tom Lane 14:54
Re: Regression in COPY FROM caused by 9f8377f7a2 Andrew Dunstan 14:55
Re: Skip Orderby Execution for Materialized Views Zhang Mingli 15:02
Re: Skip Orderby Execution for Materialized Views David G. Johnston 16:05
Re: Fix receiving large legal tsvector from binary format Tom Lane 17:24
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState Peter Eisentraut 18:41
Re: False "pg_serial": apparent wraparound” in logs Heikki Linnakangas 18:43
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Peter Eisentraut 18:46
Re: stopgap fix for signal handling during restore_command Peter Eisentraut 18:50
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState Tom Lane 18:53
pgstatindex vs. !indisready 📎 Noah Misch 19:53
Re: pgstatindex vs. !indisready Tom Lane 20:37
Re: pgstatindex vs. !indisready 📎 Noah Misch 20:58
Re: Making the subquery alias optional in the FROM clause Erwin Brandstetter 23:02
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector Karl O. Pinc 23:16
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector 📎 Karl O. Pinc 23:18
Re: pgstatindex vs. !indisready Peter Geoghegan 23:20
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Peter Geoghegan 23:33

Oct. 2, 2023

Thread Author Time
Re: Making the subquery alias optional in the FROM clause Tom Lane 00:01
Re: pgstatindex vs. !indisready Michael Paquier 00:24
Re: pgstatindex vs. !indisready Peter Geoghegan 00:44
Re: pgstatindex vs. !indisready Noah Misch 01:31
Re: document the need to analyze partitioned tables Laurenz Albe 02:48
Re: Document that server will start even if it's unable to open some TCP/IP ports Gurjeet Singh 03:20
Re: Regression in COPY FROM caused by 9f8377f7a2 Laurenz Albe 04:10
Re: remaining sql/json patches Amit Langote 04:24
Re: remaining sql/json patches Amit Langote 05:26
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 06:09
Trigger violates foreign key constraint Laurenz Albe 07:03
Clean up some pg_dump tests 📎 Peter Eisentraut 07:12
Re: Remove MSVC scripts from the tree 📎 Michael Paquier 07:38
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Drouvot, Bertrand 08:01
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 08:17
[PATCH] Fix memory leak in memoize for numeric key 📎 Orlov Aleksej 08:20
Re: pg_stat_get_activity(): integer overflow due to (int) * (int) for MemoryContextAllocHuge() 📎 Jakub Wartak 08:22
Re: TAP tests for psql \g piped into program Heikki Linnakangas 08:46
Re: Pre-proposal: unicode normalized text Peter Eisentraut 08:47
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Drouvot, Bertrand 08:53
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Pavel Borisov 09:15
Re: Show various offset arrays for heap WAL records Heikki Linnakangas 09:19
Replace (stat(<file>))[7] in TAP tests with -s 📎 Drouvot, Bertrand 09:35
Re: Trigger violates foreign key constraint Laurenz Albe 10:02
Re: wal recycling problem Christoph Moench-Tegeder 10:06
Re: bgwriter doesn't flush WAL stats Heikki Linnakangas 10:08
Re: Making the subquery alias optional in the FROM clause 📎 Dean Rasheed 10:49
RE: Synchronizing slots from primary to standby 📎 Hayato Kuroda (Fujitsu) 10:59
Re: Replace (stat(<file>))[7] in TAP tests with -s Dagfinn Ilmari Mannsåker 11:44
Re: Remove ParallelReadyList and worker_spi_state from typedefs.list vignesh C 12:37
Re: Eager page freeze criteria clarification Robert Haas 13:25
Re: Making the subquery alias optional in the FROM clause Tom Lane 13:39
Re: Trigger violates foreign key constraint Tom Lane 13:49
Re: Trigger violates foreign key constraint Laurenz Albe 14:11
pg*.dll and *.pdb files in psqlODBC have no version numbers Mark Hill 14:28
Re: New WAL record to detect the checkpoint redo location 📎 Robert Haas 14:42
Re: pg*.dll and *.pdb files in psqlODBC have no version numbers Tom Lane 14:45
Re: CHECK Constraint Deferrable Himanshu Upadhyaya 15:01
Re: CHECK Constraint Deferrable Himanshu Upadhyaya 15:01
Re: CHECK Constraint Deferrable Himanshu Upadhyaya 15:01
Re: CHECK Constraint Deferrable 📎 Himanshu Upadhyaya 15:03
Re: Eager page freeze criteria clarification Peter Geoghegan 15:36
Re: Initdb-time block size specification 📎 David Christensen 15:39
Re: Eliminate redundant tuple visibility check in vacuum Robert Haas 16:04
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Robert Haas 17:24
Re: commitfest app down for repairs Robert Haas 17:26
Re: Allow deleting enumerated values from an existing enumerated data type Vik Fearing 17:49
Re: Allow deleting enumerated values from an existing enumerated data type Dagfinn Ilmari Mannsåker 18:07
Re: On login trigger: take three Robert Haas 18:10
Commitfest 2023-09 has finished Peter Eisentraut 18:27
unnest multirange, returned order PG Doc comments form 18:42
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers Robert Haas 18:55
Re: CHECK Constraint Deferrable Tom Lane 19:25
Re: Pre-proposal: unicode normalized text Robert Haas 20:06
Re: pg16: XX000: could not find pathkey item to sort 📎 David Rowley 20:11
Re: CHECK Constraint Deferrable David G. Johnston 20:16
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector 📎 Karl O. Pinc 20:18
Re: Allow deleting enumerated values from an existing enumerated data type Tom Lane 20:20
Re: Eager page freeze criteria clarification Robert Haas 20:25
Re: Pre-proposal: unicode normalized text Nico Williams 20:27
Re: [PGDOCS] change function linkend to refer to a more relevant target Peter Smith 21:27
Fixup some more appendStringInfo misusages 📎 David Rowley 22:24
Re: CHECK Constraint Deferrable Vik Fearing 22:56
Re: Does anyone ever use OPTIMIZER_DEBUG? 📎 David Rowley 23:29
Re: pg*.dll and *.pdb files in psqlODBC have no version numbers Michael Paquier 23:42
Re: Replace (stat(<file>))[7] in TAP tests with -s Michael Paquier 23:44

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

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