pgsql-hackers before 2023-10-13 02:55

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. 10, 2023

Thread Author Time
Re: Lowering the default wal_blocksize to 4K Andres Freund 23:29
Re: [PATCH] hstore: Fix parsing on Mac OS X: isspace() is locale specific Michael Paquier 23:34
Re: stopgap fix for signal handling during restore_command Andres Freund 23:40

Oct. 11, 2023

Thread Author Time
Re: broken master regress tests Jeff Davis 00:08
Re: PGDOCS - add more links in the pub/sub reference pages Peter Smith 00:28
Re: PGDOCS - add more links in the pub/sub reference pages 📎 Peter Smith 00:31
Re: broken master regress tests Andres Freund 00:54
Re: Pre-proposal: unicode normalized text 📎 Jeff Davis 01:08
interval_ops shall stop using btequalimage (deduplication) 📎 Noah Misch 01:33
Re: Lowering the default wal_blocksize to 4K Thomas Munro 01:39
Re: Fix typo in psql zh_CN.po Richard Guo 01:58
Re: Retire has_multiple_baserels() Richard Guo 01:59
Re: Lowering the default wal_blocksize to 4K Andres Freund 02:47
Re: Problem, partition pruning for prepared statement with IS NULL clause. David Rowley 02:49
Re: Fix typo in psql zh_CN.po Tom Lane 02:51
Re: stopgap fix for signal handling during restore_command 📎 Nathan Bossart 02:54
Re: interval_ops shall stop using btequalimage (deduplication) Peter Geoghegan 03:12
Re: Doc: Minor update for enable_partitionwise_aggregate 📎 Andrew Atkinson 03:21
Re: interval_ops shall stop using btequalimage (deduplication) Noah Misch 03:29
Re: stopgap fix for signal handling during restore_command Nathan Bossart 03:29
Re: Fix typo in psql zh_CN.po jinser 03:34
Re: stopgap fix for signal handling during restore_command Andres Freund 03:39
Re: REL_15_STABLE: pgbench tests randomly failing on CI, Windows only Noah Misch 03:40
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Michael Paquier 03:40
Re: Problem, partition pruning for prepared statement with IS NULL clause. 📎 tender wang 03:44
Re: interval_ops shall stop using btequalimage (deduplication) Peter Geoghegan 03:51
Re: Removing unneeded self joins Andrei Lepikhov 03:51
Re: stopgap fix for signal handling during restore_command Michael Paquier 04:02
Re: SQL:2011 application time Paul Jungwirth 04:22
Re: interval_ops shall stop using btequalimage (deduplication) Peter Geoghegan 04:35
Re: SQL:2011 application time Paul Jungwirth 04:47
Re: remaining sql/json patches Amit Langote 05:08
Re: Doc: Minor update for enable_partitionwise_aggregate David Rowley 06:38
Re: CREATE DATABASE with filesystem cloning Peter Eisentraut 06:40
Re: [PoC] run SQL over ciphertext Peter Eisentraut 06:43
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Drouvot, Bertrand 06:48
Add null termination to string received in parallel apply worker 📎 Zhijie Hou (Fujitsu) 06:48
Re: Pre-proposal: unicode normalized text Peter Eisentraut 06:51
Re: Pre-proposal: unicode normalized text Peter Eisentraut 06:56
Re: [PoC] run SQL over ciphertext Mingyu Li 07:04
Re: RFC: Logging plan of the running query Ashutosh Bapat 07:22
Re: [PoC] run SQL over ciphertext Mingyu Li 07:34
Re: Pre-proposal: unicode normalized text Jeff Davis 07:37
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Amit Kapila 07:43
Re: Problem, partition pruning for prepared statement with IS NULL clause. 📎 David Rowley 07:50
Re: Pre-proposal: unicode normalized text Jeff Davis 07:53
Re: False "pg_serial": apparent wraparound” in logs Michael Paquier 08:37
Re: LLVM 16 (opaque pointers) 📎 Thomas Munro 08:59
Re: Problem, partition pruning for prepared statement with IS NULL clause. tender wang 09:06
Re: Problem, partition pruning for prepared statement with IS NULL clause. Sergei Glukhov 09:09
Re: Add null termination to string received in parallel apply worker Peter Smith 09:11
Re: Problem, partition pruning for prepared statement with IS NULL clause. 📎 David Rowley 09:19
Re: LLVM 16 (opaque pointers) Ronan Dunklau 09:31
Re: Problem, partition pruning for prepared statement with IS NULL clause. Sergei Glukhov 09:59
Re: Logging parallel worker draught Alvaro Herrera 10:11
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 10:57
SLRU optimization - configurable buffer pool and partitioning the SLRU lock 📎 Dilip Kumar 11:04
Re: Refactoring backend fork+exec code 📎 Heikki Linnakangas 11:12
Re: Is this a problem in GenericXLogFinish()? Heikki Linnakangas 11:53
Re: Is this a problem in GenericXLogFinish()? Robert Haas 12:25
Re: Add null termination to string received in parallel apply worker Amit Kapila 12:26
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Dilip Kumar 12:27
Re: remaining sql/json patches 📎 Amit Langote 12:34
Re: CREATE DATABASE with filesystem cloning Robert Haas 12:35
Re: Lowering the default wal_blocksize to 4K Matthias van de Meent 14:09
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges 📎 Tommy Pavlicek 15:11
Re: Add null termination to string received in parallel apply worker Alvaro Herrera 15:14
Re: Logging parallel worker draught Imseih (AWS), Sami 15:26
Re: Add null termination to string received in parallel apply worker Tom Lane 16:04
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Tom Lane 17:08
Re: interval_ops shall stop using btequalimage (deduplication) Noah Misch 18:38
Re: stopgap fix for signal handling during restore_command Nathan Bossart 19:00
Re: interval_ops shall stop using btequalimage (deduplication) Peter Geoghegan 20:00
Re: Lowering the default wal_blocksize to 4K Robert Haas 20:05
Re: Lowering the default wal_blocksize to 4K Thomas Munro 20:27
Re: Lowering the default wal_blocksize to 4K Thomas Munro 20:47
Re: A new strategy for pull-up correlated ANY_SUBLINK 📎 Alena Rybakina 21:01
Regarding Postgresql Transaction isolation Ajay P S 21:30
Re: Add null termination to string received in parallel apply worker David Rowley 21:39
Re: New WAL record to detect the checkpoint redo location Thomas Munro 21:42
Re: Regarding Postgresql Transaction isolation Tom Lane 21:49
Re: The danger of deleting backup_label Thomas Munro 22:10
Re: Lowering the default wal_blocksize to 4K Andres Freund 22:11
Re: Lowering the default wal_blocksize to 4K Andres Freund 22:16
Re: The danger of deleting backup_label Michael Paquier 22:22
Re: Improve WALRead() to suck data directly from WAL buffers when possible Andres Freund 22:43
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" Thomas Munro 23:25

Oct. 12, 2023

Thread Author Time
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 00:26
Re: Eager page freeze criteria clarification Andres Freund 00:43
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" Michael Paquier 01:10
Wait events for delayed checkpoints 📎 Thomas Munro 01:10
Memory knob testing (was Re: Let's make PostgreSQL multi-threaded) Merlin Moncure 03:05
RE: Add null termination to string received in parallel apply worker Zhijie Hou (Fujitsu) 03:43
Re: Synchronizing slots from primary to standby 📎 shveta malik 03:48
Re: Synchronizing slots from primary to standby shveta malik 03:53
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges jian he 03:53
Re: Synchronizing slots from primary to standby shveta malik 04:02
Re: PGDOCS - add more links in the pub/sub reference pages Amit Kapila 04:44
Re: Remove MSVC scripts from the tree 📎 Michael Paquier 05:23
Re: Invalidate the subscription worker in cases where a user loses their superuser status Amit Kapila 05:40
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Drouvot, Bertrand 05:42
Re: Where can I find the doxyfile? 📎 John Morris 06:07
Re: Tab completion for AT TIME ZONE Michael Paquier 06:49
Re: Problem, partition pruning for prepared statement with IS NULL clause. David Rowley 07:05
Re: New WAL record to detect the checkpoint redo location Michael Paquier 07:27
Re: A new strategy for pull-up correlated ANY_SUBLINK Andy Fan 07:52
Some performance degradation in REL_16 vs REL_15 📎 Anton A. Melnikov 08:00
Re: Doc: Minor update for enable_partitionwise_aggregate David Rowley 08:18
Re: Some performance degradation in REL_16 vs REL_15 David Rowley 08:20
Re: POC: Extension for adding distributed tracing - pg_tracing 📎 Anthonin Bonnefoy 08:54
Re: Tab completion for AT TIME ZONE Dagfinn Ilmari Mannsåker 09:27
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 09:28
Special-case executor expression steps for common combinations 📎 Daniel Gustafsson 09:48
Re: cataloguing NOT NULL constraints Alexander Lakhin 10:00
Re: Logging parallel worker draught Benoit Lobréau 10:01
Re: Use virtual tuple slot for Unique node Ashutosh Bapat 10:05
Re: Special-case executor expression steps for common combinations Heikki Linnakangas 10:24
Re: [PATCH] Compression dictionaries for JSONB Aleksander Alekseev 10:28
PostgreSQL domains and NOT NULL constraint Erki Eessaar 10:38
Re: Server crash on RHEL 9/s390x platform against PG16 Suraj Kharage 10:42
Test 026_overwrite_contrecord fails on very slow machines (under Valgrind) Alexander Lakhin 11:00
pg_upgrade's interaction with pg_resetwal seems confusing Amit Kapila 11:14
Re: Removing unneeded self joins 📎 Alexander Korotkov 11:32
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 11:41
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 11:42
Re: Special-case executor expression steps for common combinations David Rowley 12:04
Re: Problem, partition pruning for prepared statement with IS NULL clause. David Rowley 12:27
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock 📎 Dilip Kumar 12:46
Re: RFC: Logging plan of the running query 📎 torikoshia 13:21
Re: Lowering the default wal_blocksize to 4K Robert Haas 13:36
Re: [RFC] Add jit deform_counter 📎 Nazir Bilal Yavuz 13:37
Re: [RFC] Add jit deform_counter Daniel Gustafsson 13:40
Re: Lowering the default wal_blocksize to 4K Robert Haas 13:46
Re: Problem, partition pruning for prepared statement with IS NULL clause. Sergei Glukhov 13:47
Re: Lowering the default wal_blocksize to 4K Ants Aasma 13:57
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" David Steele 13:58
Re: The danger of deleting backup_label David Steele 14:19
Pro et contra of preserving pg_proc oids during pg_upgrade Nikita Malakhov 14:24
Re: The danger of deleting backup_label David Steele 14:25
Re: Eager page freeze criteria clarification Robert Haas 14:26
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Tom Lane 14:34
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" David Steele 14:41
Re: PostgreSQL domains and NOT NULL constraint Tom Lane 14:54
Re: Lowering the default wal_blocksize to 4K Robert Haas 14:56
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 15:05
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 15:13
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 15:26
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 15:33
Re: Performance degradation on concurrent COPY into a single relation in PG16. Tom Lane 15:44
Re: Eager page freeze criteria clarification Melanie Plageman 15:50
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Robert Haas 15:54
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Peter Geoghegan 16:00
Re: Parent/child context relation in pg_get_backend_memory_contexts() Andres Freund 16:23
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 16:24
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Nikita Malakhov 16:56
Re: Separate memory contexts for relcache and catcache Andres Freund 17:01
Re: Pro et contra of preserving pg_proc oids during pg_upgrade David G. Johnston 17:24
Re: Eager page freeze criteria clarification Robert Haas 17:28
Re: Wait events for delayed checkpoints Robert Haas 17:32
Re: On login trigger: take three Robert Haas 17:34
Re: Special-case executor expression steps for common combinations Andres Freund 17:52
Re: Pro et contra of preserving pg_proc oids during pg_upgrade David G. Johnston 18:00
Re: New WAL record to detect the checkpoint redo location Robert Haas 18:10
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Robert Haas 18:20
Re: pg_upgrade's interaction with pg_resetwal seems confusing Robert Haas 18:30
Re: Pro et contra of preserving pg_proc oids during pg_upgrade David G. Johnston 18:38
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Robert Haas 18:43
Re: Where can I find the doxyfile? 📎 Bohdan Mart 19:19
Re: Pro et contra of preserving pg_proc oids during pg_upgrade David G. Johnston 19:36
building 32bit windows version Dave Cramer 19:49
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound 📎 Robert Haas 20:10
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Robert Haas 20:16
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Nikita Malakhov 20:30
Re: Pro et contra of preserving pg_proc oids during pg_upgrade David G. Johnston 21:46
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Peter Geoghegan 21:52
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Nikita Malakhov 21:57
Re: Pro et contra of preserving pg_proc oids during pg_upgrade David G. Johnston 22:28
BRIN minmax multi - incorrect distance for infinite timestamp/date 📎 Tomas Vondra 22:38
Re: On login trigger: take three Alexander Korotkov 22:54
Re: Wait events for delayed checkpoints Michael Paquier 23:09
Re: interval_ops shall stop using btequalimage (deduplication) 📎 Noah Misch 23:10
Re: A new strategy for pull-up correlated ANY_SUBLINK 📎 Alena Rybakina 23:14
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" Michael Paquier 23:15
Re: interval_ops shall stop using btequalimage (deduplication) Peter Geoghegan 23:21
Re: Making aggregate deserialization (and WAL receive) functions slightly faster 📎 David Rowley 23:22
Re: Test 026_overwrite_contrecord fails on very slow machines (under Valgrind) Michael Paquier 23:30
Re: LLVM 16 (opaque pointers) Andres Freund 23:31
Re: Test 026_overwrite_contrecord fails on very slow machines (under Valgrind) Andres Freund 23:46

Oct. 13, 2023

Thread Author Time
Re: Add support for AT LOCAL 📎 Vik Fearing 00:20
Re: CHECK Constraint Deferrable Vik Fearing 00:36
Re: Some performance degradation in REL_16 vs REL_15 Michael Paquier 00:40
Re: SQL:2011 application time Vik Fearing 00:48
Re: Tab completion for AT TIME ZONE Vik Fearing 01:07
Re: On login trigger: take three Robert Haas 01:18
Re: Wait events for delayed checkpoints Robert Haas 01:19
Re: PostgreSQL domains and NOT NULL constraint Vik Fearing 01:25
Re: PostgreSQL domains and NOT NULL constraint Tom Lane 01:44
Re: Some performance degradation in REL_16 vs REL_15 Andres Freund 02:05
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set Nathan Bossart 02:25
Re: PostgreSQL domains and NOT NULL constraint Vik Fearing 02:41

Browse Archives

Prev | Next