pgsql-hackers since 2024-11-11 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

Nov. 11, 2024

Thread Author Time
Re: pg_stat_statements: Avoid holding excessive lock Michael Paquier 00:21
Re: remaining sql/json patches Amit Langote 00:28
Re: Eager aggregation, take 3 Richard Guo 00:51
Re: doc fail about ALTER TABLE ATTACH re. NO INHERIT Amit Langote 00:55
Re: In-placre persistance change of a relation Kyotaro Horiguchi 01:25
Re: Parallel workers stats in pg_stat_database Michael Paquier 01:51
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes Michael Paquier 02:04
Re: Avoiding superfluous buffer locking during nbtree backwards scans Masahiro Ikeda 02:53
Re: Avoiding superfluous buffer locking during nbtree backwards scans Peter Geoghegan 03:19
Re: meson and check-tests jian he 03:34
Re: Add html-serve target to autotools and meson Michael Paquier 04:25
Re: Avoiding superfluous buffer locking during nbtree backwards scans Masahiro Ikeda 04:36
Re: Virtual generated columns vignesh C 05:51
Re: define pg_structiszero(addr, s, r) Bertrand Drouvot 06:19
Update Unicode data to Unicode 16.0.0 📎 Peter Eisentraut 06:27
Re: Fix small typo, use InvalidRelFileNumber instead of InvalidOid Dilip Kumar 06:52
Re: RFC: Additional Directory for Extensions 📎 Peter Eisentraut 07:16
Re: Skip collecting decoded changes of already-aborted transactions Peter Smith 07:24
Re: Proper object locking for GRANT/REVOKE 📎 Bertrand Drouvot 07:53
Re: pgcrypto: better memory management?... Peter Eisentraut 08:12
Re: meson and check-tests 📎 Nazir Bilal Yavuz 08:14
Re: Commit Timestamp and LSN Inversion issue Amit Kapila 08:19
Re: Proposal to add page headers to SLRU pages 📎 Li, Yong 08:20
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes Guillaume Lelarge 08:34
clean up create|alter domain stmt incompatiable constraint error case and add regression test 📎 jian he 08:59
RE: Commit Timestamp and LSN Inversion issue Hayato Kuroda (Fujitsu) 09:49
Re: warn if GUC set to an invalid shared library Heikki Linnakangas 10:09
Re: Separate memory contexts for relcache and catcache Ashutosh Bapat 10:12
Re: [BUG] psql: Make \copy from 'text' and 'csv' formats fail on NUL bytes Joel Jacobson 10:45
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row torikoshia 11:11
Re: doc: pgevent.dll location Amit Kapila 11:11
Re: Separate memory contexts for relcache and catcache Ashutosh Bapat 11:35
Re: Virtual generated columns jian he 11:37
Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS Karina Litskevich 11:48
Re: Linkify mentions of the primary/subscriber's max_replication_slots Amit Kapila 11:53
Re: Parallel workers stats in pg_stat_database Benoit Lobréau 12:41
Re: magical eref alias names Andrei Lepikhov 12:41
Re: Introduce XID age and inactive timeout based replication slot invalidation Nisha Moond 12:42
Re: Add reject_limit option to file_fdw torikoshia 12:45
Re: Doc: typo in config.sgml 📎 Yugo Nagata 13:02
RE: Parallel heap vacuum Hayato Kuroda (Fujitsu) 13:08
Re: Support LIKE with nondeterministic collations Heikki Linnakangas 13:25
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Ashutosh Bapat 13:51
Re: Add html-serve target to autotools and meson Ashutosh Bapat 13:58
Re: Incremental Sort Cost Estimation Instability 📎 Andrei Lepikhov 14:10
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Tomas Vondra 14:17
PG17 failing tests (DST related?) Dave Page 15:29
Re: PG17 failing tests (DST related?) Tom Lane 15:35
Re: Commit Timestamp and LSN Inversion issue Tomas Vondra 15:35
explain plans for foreign servers dinesh salve 15:42
Re: Add html-serve target to autotools and meson Andres Freund 15:50
Re: PG17 failing tests (DST related?) Dave Page 16:03
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes Robert Haas 16:06
Re: Eager aggregation, take 3 Robert Haas 16:30
Offsets of `struct Port` are no longer constant 📎 Jacob Champion 16:34
Re: [PATCH] Add sortsupport for range types and btree_gist 📎 Bernd Helmle 16:41
Re: Add reject_limit option to file_fdw Fujii Masao 16:49
Re: define pg_structiszero(addr, s, r) 📎 Bertrand Drouvot 17:07
Re: Add html-serve target to autotools and meson Jacob Champion 17:11
Re: index prefetching Robert Haas 17:23
Re: Linkify mentions of the primary/subscriber's max_replication_slots Tristan Partin 17:24
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Ivan Kush 17:29
Re: Skip collecting decoded changes of already-aborted transactions 📎 Masahiko Sawada 18:00
Re: index prefetching Peter Geoghegan 18:03
Re: [PATCH] Add sortsupport for range types and btree_gist Andrey M. Borodin 18:03
Re: Parallel heap vacuum Masahiko Sawada 18:15
Re: [PoC] XMLCast (SQL/XML X025) Robert Haas 18:15
Re: RFC: Additional Directory for Extensions David E. Wheeler 18:15
Fix for pageinspect bug in PG 17 📎 Tomas Vondra 18:32
Re: index prefetching Robert Haas 18:33
Re: index prefetching Peter Geoghegan 19:00
Re: Offsets of `struct Port` are no longer constant Heikki Linnakangas 19:13
Re: Offsets of `struct Port` are no longer constant Jacob Champion 19:17
Re: Offsets of `struct Port` are no longer constant Daniel Gustafsson 19:43
Re: [PoC] XMLCast (SQL/XML X025) Jim Jones 19:43
Re: Update Unicode data to Unicode 16.0.0 Joe Conway 19:52
Re: index prefetching Peter Geoghegan 20:12
Re: UUID v7 Masahiko Sawada 20:20
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row Kirill Reshke 20:27
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Masahiko Sawada 20:56
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE Guillaume Lelarge 20:59
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 21:27
Re: Separate memory contexts for relcache and catcache Jeff Davis 21:27
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 21:34
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 📎 Tomas Vondra 22:08
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Tomas Vondra 22:10
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Masahiko Sawada 22:41
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible 📎 Jacob Champion 23:17
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Tomas Vondra 23:24
Re: POC: make mxidoff 64 bits 📎 Heikki Linnakangas 23:31

Nov. 12, 2024

Thread Author Time
Re: Eager aggregation, take 3 Richard Guo 00:27
Re: explain plans for foreign servers Andy Fan 00:33
intarray sort returns wrong result 📎 Junwang Zhao 00:58
Re: intarray sort returns wrong result Tom Lane 01:13
Optimizing FastPathTransferRelationLocks() 📎 Fujii Masao 01:16
Re: Add reject_limit option to file_fdw 📎 torikoshia 01:16
Re: intarray sort returns wrong result Junwang Zhao 01:18
Re: Skip collecting decoded changes of already-aborted transactions Peter Smith 01:39
Remove a unnecessary backslash in CopyFrom 📎 Yugo Nagata 02:46
Re: Remove a unnecessary backslash in CopyFrom Tender Wang 02:58
Re: Commit Timestamp and LSN Inversion issue Amit Kapila 03:05
Re: define pg_structiszero(addr, s, r) Michael Paquier 03:28
Re: Remove a unnecessary backslash in CopyFrom Fujii Masao 03:31
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes Michael Paquier 03:41
Re: Commit Timestamp and LSN Inversion issue Amit Kapila 04:21
Re: Commit Timestamp and LSN Inversion issue Amit Kapila 04:22
2024-11-14 release announcement draft 📎 Jonathan S. Katz 04:28
Re: 2024-11-14 release announcement draft Thomas Munro 04:54
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row Yugo Nagata 05:03
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row Yugo Nagata 05:17
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Amit Kapila 05:43
Re: Add reject_limit option to file_fdw Yugo Nagata 05:51
Re: define pg_structiszero(addr, s, r) Bertrand Drouvot 06:09
Re: Add reject_limit option to file_fdw Kirill Reshke 06:23
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Masahiko Sawada 06:32
Missing word in comment 📎 Amit Langote 06:53
Re: define pg_structiszero(addr, s, r) Michael Paquier 06:56
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Ashutosh Bapat 07:13
RE: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Zhijie Hou (Fujitsu) 07:22
Re: Fix for pageinspect bug in PG 17 Michael Paquier 07:39
Re: Support LIKE with nondeterministic collations 📎 Peter Eisentraut 07:45
RE: Fix for pageinspect bug in PG 17 Hayato Kuroda (Fujitsu) 08:04
Re: Converting contrib SQL functions to new style Michael Paquier 08:30
Re: Adding NetBSD and OpenBSD to Postgres CI 📎 Nazir Bilal Yavuz 08:38
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row torikoshia 08:38
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Alvaro Herrera 08:45
Re: doc fail about ALTER TABLE ATTACH re. NO INHERIT Alvaro Herrera 08:46
Re: Virtual generated columns jian he 08:49
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Ashutosh Bapat 09:37
Re: Update Unicode data to Unicode 16.0.0 Laurenz Albe 09:40
Fix to increment the index scan counter for the bloom filter index 📎 Masahiro Ikeda 10:01
Re: Identify huge pages accessibility using madvise Peter Eisentraut 10:07
Re: NOT ENFORCED constraint feature Peter Eisentraut 10:18
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 10:19
Re: Separate memory contexts for relcache and catcache Ashutosh Bapat 10:26
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Amit Kapila 10:27
Re: Add html-serve target to autotools and meson Ashutosh Bapat 10:30
Re: not null constraints, again Alvaro Herrera 10:43
Re: explain plans for foreign servers Ashutosh Bapat 10:46
Re: Allowing pg_recvlogical to create temporary replication slots Torsten Förtsch 10:54
Re: define pg_structiszero(addr, s, r) 📎 Bertrand Drouvot 10:56
Re: Parallel heap vacuum vignesh C 11:21
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Tomas Vondra 11:25
Extract constants from EXECUTE queries ISHAN CHHANGANI 11:28
Re: Commit Timestamp and LSN Inversion issue Tomas Vondra 12:00
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Alvaro Herrera 12:07
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Ashutosh Bapat 12:08
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Amit Kapila 12:19
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Amit Kapila 12:24
CREATE SCHEMA ... CREATE DOMAIN support 📎 Kirill Reshke 12:54
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Tomas Vondra 12:59
Re: RFC: Additional Directory for Extensions Peter Eisentraut 13:25
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY Alvaro Herrera 13:35
Parametrization minimum password lenght 📎 Emanuele Musella 13:41
Re: Parametrization minimum password lenght Tomas Vondra 13:48
Re: Commit Timestamp and LSN Inversion issue Jan Wieck 13:51
Re: Commit Timestamp and LSN Inversion issue Andres Freund 13:55
Re: Parallel workers stats in pg_stat_database Michael Banck 14:05
Re: Commit Timestamp and LSN Inversion issue Andres Freund 14:06
Re: [PATCH] Refactor SLRU to always use long file names 📎 Aleksander Alekseev 14:15
Re: Allowing pg_recvlogical to create temporary replication slots Dickson S. Guedes 14:30
Re: [PATCH] Refactor SLRU to always use long file names Aleksander Alekseev 14:37
Re: RFC: Additional Directory for Extensions David E. Wheeler 14:44
Re: Commit Timestamp and LSN Inversion issue Jan Wieck 14:45
Re: Parallel workers stats in pg_stat_database Benoit Lobréau 14:56
Re: [PoC] XMLCast (SQL/XML X025) Robert Haas 14:59
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Michail Nikolaev 15:00
Re: Commit Timestamp and LSN Inversion issue Jan Wieck 15:12
Re: meson and check-tests jian he 15:13
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE Robert Haas 15:21
Re: Parallel workers stats in pg_stat_database Michael Banck 15:24
Re: Commit Timestamp and LSN Inversion issue Andres Freund 15:34
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE Guillaume Lelarge 15:35
Re: [PATCH] Add sortsupport for range types and btree_gist Bernd Helmle 15:43
Re: Avoiding superfluous buffer locking during nbtree backwards scans 📎 Peter Geoghegan 15:55
Re: doc: pgevent.dll location Robert Haas 16:02
Re: Virtual generated columns 📎 Peter Eisentraut 16:06
Re: Virtual generated columns Peter Eisentraut 16:07
Re: Virtual generated columns Peter Eisentraut 16:08
Re: Virtual generated columns Peter Eisentraut 16:09
Re: Virtual generated columns Peter Eisentraut 16:10
Re: Virtual generated columns Peter Eisentraut 16:17
Re: define pg_structiszero(addr, s, r) 📎 Ranier Vilela 16:32
Re: Extract constants from EXECUTE queries Tomas Vondra 16:34
Re: Commit Timestamp and LSN Inversion issue Jan Wieck 16:40
Re: Virtual generated columns Alvaro Herrera 16:50
Re: doc: pgevent.dll location Peter Eisentraut 16:52
Fix array access (src/bin/pg_dump/pg_dump.c) 📎 Ranier Vilela 17:05
Re: Parallel workers stats in pg_stat_database Benoit Lobréau 17:17
Re: doc: pgevent.dll location Robert Haas 17:27
Re: Commit Timestamp and LSN Inversion issue Andres Freund 17:45
Re: Fix array access (src/bin/pg_dump/pg_dump.c) Alvaro Herrera 19:11
Re: pg_rewind WAL segments deletion pitfall 📎 Alvaro Herrera 19:18
Re: logical replication: restart_lsn can go backwards (and more), seems broken since 9.4 Masahiko Sawada 19:50
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) Peter Geoghegan 20:00
Re: doc: pgevent.dll location Peter Eisentraut 20:06
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE 📎 Guillaume Lelarge 21:02
Re: Improve error messages for database object stats manipulation functions during recovery Heikki Linnakangas 21:09
Re: doc: pgevent.dll location Robert Haas 21:11
Re: Statistics Import and Export Heikki Linnakangas 21:17

Browse Archives

Prev | Next