pgsql-hackers since 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)
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. 13, 2023

Thread Author Time
Re: Removing unneeded self joins 📎 Andrei Lepikhov 02:55
Re: [dynahash] do not refill the hashkey after hash_search Nathan Bossart 03:07
Re: PGDOCS - add more links in the pub/sub reference pages 📎 Peter Smith 03:32
Re: Wait events for delayed checkpoints Thomas Munro 03:51
Re: pg_upgrade's interaction with pg_resetwal seems confusing Amit Kapila 03:59
Re: Add support for AT LOCAL Michael Paquier 04:07
Re: Invalidate the subscription worker in cases where a user loses their superuser status vignesh C 04:34
Re: Add support for AT LOCAL Vik Fearing 05:03
Re: pg_upgrade's interaction with pg_resetwal seems confusing Dilip Kumar 05:07
Re: Add support for AT LOCAL Michael Paquier 05:07
Re: Tab completion for AT TIME ZONE Michael Paquier 05:31
Re: pg_upgrade's interaction with pg_resetwal seems confusing Amit Kapila 05:36
Re: PostgreSQL domains and NOT NULL constraint Tom Lane 05:37
Re: Invalidate the subscription worker in cases where a user loses their superuser status Amit Kapila 05:38
Re: Tab completion for AT TIME ZONE Vik Fearing 06:01
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Laurenz Albe 06:14
Re: [PATCH] Add support function for containment operators 📎 jian he 06:26
Re: A new strategy for pull-up correlated ANY_SUBLINK Andy Fan 07:04
Re: New WAL record to detect the checkpoint redo location Michael Paquier 07:29
Re: A new strategy for pull-up correlated ANY_SUBLINK 📎 Andy Fan 07:29
Re: Tab completion for AT TIME ZONE Michael Paquier 07:32
Re: pg_stat_statements and "IN" conditions Michael Paquier 08:07
Re: On login trigger: take three Alexander Korotkov 08:26
Re: pg_upgrade's interaction with pg_resetwal seems confusing Dilip Kumar 08:33
Re: Synchronizing slots from primary to standby 📎 shveta malik 08:35
Re: A new strategy for pull-up correlated ANY_SUBLINK 📎 Alena Rybakina 08:39
Re: Removing unneeded self joins a.rybakina 08:56
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set Daniel Gustafsson 09:02
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound Aleksander Alekseev 09:03
Re: Removing unneeded self joins Andrei Lepikhov 09:03
Re: LLVM 16 (opaque pointers) Dmitry Dolgov 09:06
Re: Questions about the new subscription parameter: password_required 📎 Benoit Lobréau 09:18
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Dean Rasheed 09:21
Re: Removing unneeded self joins a.rybakina 09:42
Re: pg_logical_emit_message() misses a XLogFlush() Amit Kapila 09:50
Re: Oversight in reparameterize_path_by_child leading to executor crash Andrei Lepikhov 10:18
Re: pg_upgrade's interaction with pg_resetwal seems confusing Amit Kapila 10:44
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date 📎 Tomas Vondra 10:44
RE: pg_upgrade's interaction with pg_resetwal seems confusing 📎 Hayato Kuroda (Fujitsu) 11:43
Re: PostgreSQL domains and NOT NULL constraint Erki Eessaar 12:01
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Dean Rasheed 12:04
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Tomas Vondra 12:17
Re: [RFC] Add jit deform_counter Daniel Gustafsson 12:20
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 13:35
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" David Steele 14:40
Re: LLVM 16 (opaque pointers) 📎 Dmitry Dolgov 14:44
Re: LLVM 16 (opaque pointers) Andres Freund 14:55
Re: LLVM 16 (opaque pointers) Andres Freund 14:56
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Dean Rasheed 15:28
Re: pg_stat_statements and "IN" conditions Nathan Bossart 16:37
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 17:39
Re: Performance degradation on concurrent COPY into a single relation in PG16. 📎 Andres Freund 18:30
Re: Questions about the new subscription parameter: password_required Jeff Davis 18:54
Re: unnest multirange, returned order Daniel Fredouille 19:33
Re: should frontend tools use syncfs() ? Nathan Bossart 20:23
Re: LLVM 16 (opaque pointers) Thomas Munro 20:32
Re: LLVM 16 (opaque pointers) Thomas Munro 20:34
Re: On login trigger: take three 📎 Alexander Korotkov 23:10

Oct. 14, 2023

Thread Author Time
Re: Fix output of zero privileges in psql Erik Wienhold 00:45
Re: Fix output of zero privileges in psql Erik Wienhold 00:46
Re: Fix output of zero privileges in psql Erik Wienhold 01:04
Re: PostgreSQL domains and NOT NULL constraint Vik Fearing 02:23
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 02:33
Re: Included xid in restoring reorder buffer changes from disk log message 📎 vignesh C 02:37
Re: JSON Path and GIN Questions Erik Wienhold 02:50
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Amit Kapila 04:13
[Doc] Glossary Term Definitions Edits 📎 Andrew Atkinson 04:16
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 05:15
Re: [Doc] Glossary Term Definitions Edits David Rowley 05:24
Re: [Doc] Glossary Term Definitions Edits Erik Wienhold 05:55
Re: PostgreSQL domains and NOT NULL constraint Erki Eessaar 07:31
Re: logical decoding and replication of sequences, take 2 Amit Kapila 11:53
Re: PostgreSQL domains and NOT NULL constraint Vik Fearing 14:00
Re: [Doc] Glossary Term Definitions Edits 📎 Andrew Atkinson 14:54
Re: The danger of deleting backup_label 📎 David Steele 15:30
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" David Steele 15:42
Re: PostgreSQL domains and NOT NULL constraint Tom Lane 16:09
Rename backup_label to recovery_control 📎 David Steele 18:19
Re: Where can I find the doxyfile? John Morris 18:54
Re: Where can I find the doxyfile? 📎 Bohdan Mart 19:25
Re: JSON Path and GIN Questions David E. Wheeler 19:27
Re: False "pg_serial": apparent wraparound” in logs 📎 Imseih (AWS), Sami 19:29
Re: Requiring recovery.signal or standby.signal when recovering with a backup_label David Steele 19:45
Patch: Improve Boolean Predicate JSON Path Docs 📎 David E. Wheeler 20:40
Re: Patch: Improve Boolean Predicate JSON Path Docs David E. Wheeler 20:45
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 22:34
Re: Patch: Improve Boolean Predicate JSON Path Docs Erik Wienhold 23:51

Oct. 15, 2023

Thread Author Time
Re: Asymmetric partition-wise JOIN Alexander Korotkov 00:18
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov 00:57
Re: Asymmetric partition-wise JOIN Andrei Lepikhov 05:40
Re: A failure in 031_recovery_conflict.pl on Debian/s390x Alexander Lakhin 06:00
Re: PostgreSQL domains and NOT NULL constraint Erki Eessaar 07:22
Re: Asymmetric partition-wise JOIN Alexander Korotkov 10:25
Re: pg_upgrade's interaction with pg_resetwal seems confusing vignesh C 16:25
Re: Making aggregate deserialization (and WAL receive) functions slightly faster Tom Lane 16:56
Re: Logging parallel worker draught Imseih (AWS), Sami 17:48
Can concurrent create index concurrently block each other? Konstantin Knizhnik 18:33
Re: Can concurrent create index concurrently block each other? Avinash Vallarapu 19:24
Re: Can concurrent create index concurrently block each other? Tom Lane 19:59
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 📎 Peter Geoghegan 20:50
Re: Optimizing "boundary cases" during backward scan B-Tree index descents 📎 Peter Geoghegan 20:54
Re: Add support for AT LOCAL Thomas Munro 21:16
Re: Add support for AT LOCAL Tom Lane 21:57
Re: Add support for AT LOCAL Thomas Munro 22:24
Re: Add support for AT LOCAL Tom Lane 22:47
Re: Questions about the new subscription parameter: password_required Peter Smith 22:47
Re: Add support for AT LOCAL Thomas Munro 22:50
Re: Patch: Improve Boolean Predicate JSON Path Docs 📎 David E. Wheeler 23:04
Re: POC, WIP: OR-clause support for indexes a.rybakina 23:21
Re: On login trigger: take three 📎 Alexander Korotkov 23:47

Oct. 16, 2023

Thread Author Time
interval_scale not work as expected? jian he 00:00
pgsql: Add support event triggers on authenticated login Alexander Korotkov 00:18
Re: interval_scale not work as expected? Tom Lane 00:28
Re: PGDOCS - add more links in the pub/sub reference pages 📎 Peter Smith 00:45
Re: Synchronizing slots from primary to standby Ajin Cherian 00:50
Re: run pgindent on a regular basis / scripted manner Peter Geoghegan 00:52
Re: On login trigger: take three Michael Paquier 01:00
Re: Check each of base restriction clauses for constant-FALSE-or-NULL Richard Guo 01:01
Re: On login trigger: take three Alexander Korotkov 01:05
Re: Add support for AT LOCAL Michael Paquier 01:28
Re: Add support for AT LOCAL Michael Paquier 01:58
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 📎 Michael Paquier 02:22
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Tom Lane 02:47
Re: Add support for AT LOCAL Thomas Munro 02:53
Re: Add support for AT LOCAL Tom Lane 03:02
Re: Patch: Improve Boolean Predicate JSON Path Docs Erik Wienhold 03:03
Re: Add support for AT LOCAL Thomas Munro 03:07
UniqueKey v2 📎 zhihuifan1213 03:09
Re: Add support for AT LOCAL Tom Lane 03:30
Re: Rename backup_label to recovery_control Kyotaro Horiguchi 04:16
Re: Add support for AT LOCAL Michael Paquier 04:22
Re: Rename backup_label to recovery_control Kyotaro Horiguchi 04:26
Re: Rename backup_label to recovery_control Michael Paquier 04:29
Re: SQL:2011 application time jian he 04:33
Re: Asymmetric partition-wise JOIN Andrei Lepikhov 04:51
Re: Add support for AT LOCAL Noah Misch 04:58
RE: pg_upgrade's interaction with pg_resetwal seems confusing 📎 Hayato Kuroda (Fujitsu) 05:03
Re: UniqueKey v2 jian he 05:09
Re: Add support for AT LOCAL Noah Misch 05:50
Re: Add support for AT LOCAL Tom Lane 05:54
Re: Requiring recovery.signal or standby.signal when recovering with a backup_label Michael Paquier 05:54
Re: Add support for AT LOCAL Noah Misch 06:05
Re: Requiring recovery.signal or standby.signal when recovering with a backup_label Bowen Shi 06:21
Re: Can concurrent create index concurrently block each other? Konstantin Knizhnik 06:32
Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Michael Paquier 07:16
Re: pg_logical_emit_message() misses a XLogFlush() 📎 Michael Paquier 07:17
Re: Add support for AT LOCAL Michael Paquier 07:29
Re: False "pg_serial": apparent wraparound” in logs Michael Paquier 07:58
Re: Some performance degradation in REL_16 vs REL_15 Anton A. Melnikov 08:04
Re: remaining sql/json patches 📎 Nikita Malakhov 08:20
Re: Removing unneeded self joins 📎 Andrei Lepikhov 08:28
Re: LLVM 16 (opaque pointers) Ronan Dunklau 08:31
Re: remaining sql/json patches Nikita Malakhov 08:33
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Amit Kapila 09:13
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Ashutosh Bapat 09:25
Re: RFC: Logging plan of the running query Ashutosh Bapat 09:46
Re: remaining sql/json patches Amit Langote 09:47
Re: remaining sql/json patches Nikita Malakhov 09:59
Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} 📎 Nazir Bilal Yavuz 10:07
PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 📎 Quan Zongliang 10:15
Postgres Architecture Timothy Nelson 10:40
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Alvaro Herrera 11:36
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Daniel Gustafsson 11:53
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] Pavel Stehule 12:05
Re: Pro et contra of preserving pg_proc oids during pg_upgrade Nikita Malakhov 12:10
Re: remaining sql/json patches jian he 12:49
Re: Rename backup_label to recovery_control David Steele 13:43
Re: remaining sql/json patches Anton A. Melnikov 13:44
Re: list of acknowledgments for PG16 Alvaro Herrera 13:46
Re: Add support for AT LOCAL Tom Lane 13:54
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Tomas Vondra 14:03
Re: Rename backup_label to recovery_control Robert Haas 14:19
Re: The danger of deleting backup_label Robert Haas 14:55
Re: [PoC] pg_upgrade: allow to upgrade publisher node vignesh C 14:58
Re: Server crash on RHEL 9/s390x platform against PG16 Robert Haas 15:06
Re: Postgres Architecture Jonah H. Harris 15:07
Re: Rename backup_label to recovery_control David Steele 15:15
Re: BRIN minmax multi - incorrect distance for infinite timestamp/date Ashutosh Bapat 15:32
event trigger sgml touch-up 📎 Erik Rijkers 15:34
Re: index prefetching 📎 Tomas Vondra 15:34
Re: The danger of deleting backup_label David Steele 15:45
Re: Requiring recovery.signal or standby.signal when recovering with a backup_label Laurenz Albe 15:48
Re: Fix output of zero privileges in psql Laurenz Albe 15:56
Re: Rename backup_label to recovery_control Michael Banck 16:06
Re: Rename backup_label to recovery_control Robert Haas 16:12
Re: Asymmetric partition-wise JOIN Ashutosh Bapat 16:21
Re: The danger of deleting backup_label Robert Haas 16:25
Improving Physical Backup/Restore within the Low Level API David G. Johnston 16:26
Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE Michael Christofides 16:29
Re: The danger of deleting backup_label David Steele 17:00
Re: Rename backup_label to recovery_control David Steele 17:16
Re: Rename backup_label to recovery_control David Steele 17:23
Re: Improving Physical Backup/Restore within the Low Level API Laurenz Albe 17:26
Re: Rename backup_label to recovery_control Laurenz Albe 17:28
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound 📎 Robert Haas 18:06
Re: Improving Physical Backup/Restore within the Low Level API David G. Johnston 18:18
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression Robert Haas 18:54
Re: The danger of deleting backup_label Robert Haas 19:06
Re: Improving Physical Backup/Restore within the Low Level API Laurenz Albe 19:09
Re: Improving Physical Backup/Restore within the Low Level API David G. Johnston 19:36

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