pgsql-hackers since 2022-09-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

Sept. 3, 2022

Thread Author Time
Re: json docs fix jsonb_path_exists_tz again Michael Paquier 00:59
Re: postgres_fdw hint messages Michael Paquier 01:03
Re: make additional use of optimized linear search routines Michael Paquier 01:06
Re: Backpatching nbtree VACUUM (page deletion) hardening Michael Paquier 01:14
Re: First draft of the PG 15 release notes Bruce Momjian 01:47
Re: Backpatching nbtree VACUUM (page deletion) hardening Peter Geoghegan 01:51
Re: postgres_fdw hint messages Tom Lane 02:06
Re: build remaining Flex files standalone John Naylor 03:03
Re: postgres_fdw hint messages 📎 Nathan Bossart 04:30
Re: test_decoding assertion failure for the loss of top-sub transaction relationship Amit Kapila 04:43
Re: win_flex.exe (and likely win_bison.exe) isn't concurrency safe Amit Kapila 05:03
Re: win_flex.exe (and likely win_bison.exe) isn't concurrency safe Julien Rouhaud 05:21
warning: comparison of integer expressions of different signedness related to simd.h Pavel Stehule 05:30
Re: pgbench: using prepared BEGIN statement in a pipeline could cause an error Ibrar Ahmed 05:36
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Ibrar Ahmed 05:47
Re: warning: comparison of integer expressions of different signedness related to simd.h John Naylor 05:50
Re: warning: comparison of integer expressions of different signedness related to simd.h Pavel Stehule 05:53
Re: warning: comparison of integer expressions of different signedness related to simd.h Tom Lane 05:57
Re: warning: comparison of integer expressions of different signedness related to simd.h Pavel Stehule 06:02
Re: pgbench: using prepared BEGIN statement in a pipeline could cause an error Julien Rouhaud 07:09
Re: Fix typo function circle_same (src/backend/utils/adt/geo_ops.c) Julien Rouhaud 07:36
Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Michael Paquier 08:06
Re: making relfilenodes 56 bits Dilip Kumar 08:20
vacuumlo: add test to vacuumlo for test coverage 📎 Dong Wook Lee 08:27
Re: making relfilenodes 56 bits 📎 Dilip Kumar 08:56
add test to psql for coverage with --help, \e option, encoding option Dong Wook Lee 09:08
Re: add test to psql for coverage with --help, \e option, encoding option 📎 Dong Wook Lee 09:35
Re: making relfilenodes 56 bits Amit Kapila 11:41
Re: win_flex.exe (and likely win_bison.exe) isn't concurrency safe Andrew Dunstan 13:31
Re: json docs fix jsonb_path_exists_tz again Andrew Dunstan 14:01
Re: Schema variables - new implementation for Postgres 15 📎 Julien Rouhaud 15:00
Re: Can we avoid chdir'ing in resolve_symlinks() ? Andrew Dunstan 15:06
pg_basebackup's --gzip switch misbehaves Tom Lane 15:11
Re: Can we avoid chdir'ing in resolve_symlinks() ? Tom Lane 15:21
Re: Solaris "sed" versus pre-v13 plpython tests Noah Misch 15:43
Re: Can we avoid chdir'ing in resolve_symlinks() ? Tom Lane 19:15
Re: allowing for control over SET ROLE Jeff Davis 19:46
Re: Fix typo function circle_same (src/backend/utils/adt/geo_ops.c) Daniel Gustafsson 22:39

Sept. 4, 2022

Thread Author Time
freeing LDAPMessage in CheckLDAPAuth 📎 Zhihong Yu 00:00
Re: warning: comparison of integer expressions of different signedness related to simd.h John Naylor 02:32
Re: Can we avoid chdir'ing in resolve_symlinks() ? 📎 Tom Lane 02:41
Re: Add tracking of backend memory allocated to pg_stat_activity 📎 Reid Thompson 03:34
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎 Reid Thompson 03:40
Re: making relfilenodes 56 bits Dilip Kumar 03:57
Re: Add 64-bit XIDs into PostgreSQL 15 Dilip Kumar 04:23
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud 04:31
Re: build remaining Flex files standalone John Naylor 05:16
Re: pg_basebackup's --gzip switch misbehaves Michael Paquier 05:20
Re: freeing LDAPMessage in CheckLDAPAuth Michael Paquier 05:40
Re: json docs fix jsonb_path_exists_tz again Michael Paquier 05:40
Re: freeing LDAPMessage in CheckLDAPAuth Tom Lane 05:52
Re: [RFC] building postgres with meson - v12 📎 John Naylor 06:12
Re: freeing LDAPMessage in CheckLDAPAuth Michael Paquier 07:25
Re: pgsql: pg_collation_actual_version() -> pg_collation_current_version(). Alvaro Herrera 07:38
Re: pgsql: Prefetch data referenced by the WAL, take II. Alvaro Herrera 07:54
Re: pgbench: using prepared BEGIN statement in a pipeline could cause an error Ibrar Ahmed 07:56
Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP. Alvaro Herrera 08:18
Re: Add 64-bit XIDs into PostgreSQL 15 Dilip Kumar 10:20
[BUG] Storage declaration in ECPG 📎 Andrey Sokolov 10:49
Re: freeing LDAPMessage in CheckLDAPAuth 📎 Zhihong Yu 10:58
TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) 📎 Tomas Vondra 11:04
Re: pgsql: Add ALTER SUBSCRIPTION ... SKIP. Amit Kapila 11:38
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Amit Kapila 11:49
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Tomas Vondra 12:24
Re: Fix typo function circle_same (src/backend/utils/adt/geo_ops.c) Ranier Vilela 12:39
Latest build fails Ranier Vilela 12:58
Re: Latest build fails Ranier Vilela 13:08
Re: failing to build preproc.c on solaris with sun studio Andrew Dunstan 13:46
Re: freeing LDAPMessage in CheckLDAPAuth 📎 Zhihong Yu 13:52
Re: failing to build preproc.c on solaris with sun studio Tom Lane 13:56
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Tomas Vondra 14:08
Re: failing to build preproc.c on solaris with sun studio Andrew Dunstan 14:11
Re: failing to build preproc.c on solaris with sun studio Tom Lane 14:55
Re: failing to build preproc.c on solaris with sun studio Noah Misch 15:06
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) 📎 Tomas Vondra 17:40
Re: First draft of the PG 15 release notes 📎 Jonathan S. Katz 17:41
Re: build remaining Flex files standalone Andres Freund 18:17
Re: First draft of the PG 15 release notes Nathan Bossart 18:42
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 19:27
Re: [RFC] building postgres with meson - v12 Andres Freund 21:10
Re: POC: GROUP BY optimization Tomas Vondra 22:14

Sept. 5, 2022

Thread Author Time
Re: Different compression methods for FPI Justin Pryzby 00:23
Re: Column Filtering in Logical Replication 📎 Peter Smith 00:28
Re: POC: GROUP BY optimization Jonathan S. Katz 00:50
Re: pg15b3: recovery fails with wal prefetch enabled 📎 Thomas Munro 01:28
Re: Postmaster self-deadlock due to PLT linkage resolution Thomas Munro 02:28
RE: Column Filtering in Logical Replication [email protected] 03:42
Re: Handle infinite recursion in logical replication setup Peter Smith 04:17
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Amit Kapila 04:32
Re: pg15b3: recovery fails with wal prefetch enabled 📎 Thomas Munro 04:54
Re: pg15b3: recovery fails with wal prefetch enabled Kyotaro Horiguchi 05:15
Re: pg15b3: recovery fails with wal prefetch enabled Kyotaro Horiguchi 05:34
Re: freeing LDAPMessage in CheckLDAPAuth Michael Paquier 05:37
Re: SQL/JSON features for v15 Amit Langote 06:17
Re: Refactoring postgres_fdw/connection.c Etsuro Fujita 06:17
Re: Asynchronous execution support for Custom Scan Etsuro Fujita 06:27
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Amit Kapila 06:35
Re: POC: GROUP BY optimization Michael Paquier 06:38
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Tomas Vondra 06:44
Re: Clarify restriction on partitioned tables primary key / unique indexes David Rowley 06:46
Re: Patch to address creation of PgStat* contexts with null parent context 📎 Drouvot, Bertrand 06:52
Re: [POC] Allow flattening of subquery with a link to upper query Richard Guo 07:22
Re: [BUG] Storage declaration in ECPG Kyotaro Horiguchi 08:12
Re: Fix typo function circle_same (src/backend/utils/adt/geo_ops.c) Daniel Gustafsson 08:24
Re: Patch to address creation of PgStat* contexts with null parent context Kyotaro Horiguchi 08:32
Re: pg15b3: recovery fails with wal prefetch enabled 📎 Thomas Munro 09:08
Re: Missing CFI in iterate_word_similarity() Daniel Gustafsson 09:23
Re: Handle infinite recursion in logical replication setup Amit Kapila 09:40
Re: freeing LDAPMessage in CheckLDAPAuth 📎 Zhihong Yu 09:50
Re: more descriptive message for process termination due to max_slot_wal_keep_size Drouvot, Bertrand 09:56
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Amit Kapila 10:12
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) 📎 David Rowley 10:15
Re: Column Filtering in Logical Replication 📎 Peter Smith 10:16
Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records 📎 Dmitriy Kuzmin 10:19
Re: Column Filtering in Logical Replication Amit Kapila 10:46
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Tomas Vondra 10:49
Re: [POC] Allow flattening of subquery with a link to upper query Andrey Lepikhov 10:54
Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE)) 📎 Justin Pryzby 11:20
Re: Mingw task for Cirrus CI 📎 Justin Pryzby 11:50
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Tomas Vondra 11:54
Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records David Rowley 12:13
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) Ranier Vilela 12:17
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 12:40
Re: Different compression methods for FPI Matthias van de Meent 12:45
Re: Patch to address creation of PgStat* contexts with null parent context Drouvot, Bertrand 12:46
Re: Convert *GetDatum() and DatumGet*() macros to inline functions Peter Eisentraut 12:57
Re: Different compression methods for FPI Justin Pryzby 13:02
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 13:04
Re: Asynchronous execution support for Custom Scan Kazutaka Onishi 13:32
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) 📎 David Rowley 13:40
Re: Reducing the chunk header sizes on all memory context types David Rowley 13:41
Re: Support logical replication of DDLs 📎 Ajin Cherian 14:18
Re: Convert *GetDatum() and DatumGet*() macros to inline functions Aleksander Alekseev 14:20
Re: Table AM modifications to accept column projection lists 📎 Nikita Malakhov 14:38
Re: ICU for global collation 📎 Marina Polyakova 15:14
Re: Table AM modifications to accept column projection lists Justin Pryzby 16:36
Remove dead macro exec_subplan_get_plan 📎 Zhang Mingli 16:39
Re: Table AM modifications to accept column projection lists Nikita Malakhov 16:51
Re: pg_upgrade allows itself to be run twice 📎 Justin Pryzby 17:03
Re: Remove dead macro exec_subplan_get_plan Tom Lane 17:18
Re: doc: mentioned CREATE+ATTACH PARTITION as an alternative to CREATE TABLE..PARTITION OF Justin Pryzby 18:04
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) 📎 Ranier Vilela 18:07
Re: Backpatching nbtree VACUUM (page deletion) hardening Peter Geoghegan 18:22
Re: predefined role(s) for VACUUM and ANALYZE 📎 Nathan Bossart 18:56
Re: Table AM modifications to accept column projection lists Zhihong Yu 19:40
Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE) 📎 Peter Geoghegan 19:43
Re: failing to build preproc.c on solaris with sun studio Peter Eisentraut 20:52
Re: failing to build preproc.c on solaris with sun studio Andres Freund 21:30
Re: failing to build preproc.c on solaris with sun studio Tom Lane 21:34
Modernizing our GUC infrastructure 📎 Tom Lane 22:27
Re: Patch to address creation of PgStat* contexts with null parent context Andres Freund 22:47
Re: Reducing the chunk header sizes on all memory context types Andres Freund 23:09
Re: pg15b3: recovery fails with wal prefetch enabled Thomas Munro 23:18
Re: Modernizing our GUC infrastructure Andres Freund 23:32
Re: Column Filtering in Logical Replication 📎 Peter Smith 23:37
Re: Modernizing our GUC infrastructure Tom Lane 23:50
Re: Mingw task for Cirrus CI Andres Freund 23:52

Sept. 6, 2022

Thread Author Time
Re: Reducing the chunk header sizes on all memory context types David Rowley 00:10
Re: Reducing the chunk header sizes on all memory context types Tom Lane 00:27
Re: pg15b3: recovery fails with wal prefetch enabled Kyotaro Horiguchi 00:48
Re: [PATCH] Tab completion for SET COMPRESSION Shinya Kato 00:54
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) David Rowley 01:29
Re: pg15b3: recovery fails with wal prefetch enabled Jonathan S. Katz 01:45
Re: pg15b3: recovery fails with wal prefetch enabled Tom Lane 01:51
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) Ranier Vilela 01:52
Re: Fix possible bogus array out of bonds (src/backend/access/brin/brin_minmax_multi.c) David Rowley 02:02
Re: pg15b3: recovery fails with wal prefetch enabled Thomas Munro 02:03
Re: Remove dead macro exec_subplan_get_plan Richard Guo 02:21
Re: Reducing the chunk header sizes on all memory context types 📎 David Rowley 02:32
Re: Reducing the chunk header sizes on all memory context types David Rowley 02:35
Re: Reducing the chunk header sizes on all memory context types Tom Lane 02:43
Re: Modernizing our GUC infrastructure Junwang Zhao 02:45
Re: Modernizing our GUC infrastructure Tom Lane 02:48
pg_publication_tables show dropped columns 📎 Jaime Casanova 02:49
Re: Modernizing our GUC infrastructure Junwang Zhao 03:02
Re: pg_publication_tables show dropped columns Tom Lane 03:13
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 03:13
Re: Handle infinite recursion in logical replication setup vignesh C 03:15
Re: Reducing the chunk header sizes on all memory context types 📎 David Rowley 03:17
Re: FOR EACH ROW triggers, on partitioend tables, with indexes? David Rowley 03:53
RE: Handle infinite recursion in logical replication setup [email protected] 04:00
RE: Handle infinite recursion in logical replication setup [email protected] 04:01
Re: Compilation issue on Solaris. John Naylor 04:24
Re: Modernizing our GUC infrastructure Pavel Stehule 04:32
Re: Modernizing our GUC infrastructure Pavel Stehule 04:35
Re: Modernizing our GUC infrastructure Julien Rouhaud 04:58
Re: Handle infinite recursion in logical replication setup Peter Smith 05:11
Re: Modernizing our GUC infrastructure Tom Lane 05:25
Re: Modernizing our GUC infrastructure Tom Lane 05:42
Re: [PATCH] Renumber confusing value for GUC_UNIT_BYTE Peter Eisentraut 05:44
Re: Patch to address creation of PgStat* contexts with null parent context Kyotaro Horiguchi 05:53
Re: more descriptive message for process termination due to max_slot_wal_keep_size 📎 Kyotaro Horiguchi 05:53
Re: [PATCH] Renumber confusing value for GUC_UNIT_BYTE Tom Lane 05:57
Re: pg_waldump: add test for coverage Peter Eisentraut 05:57
Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639) Amit Kapila 05:59
Re: Modernizing our GUC infrastructure Pavel Stehule 06:09
Re: Compilation issue on Solaris. Ibrar Ahmed 06:18
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row Ibrar Ahmed 06:25
Re: [PATCH] Renumber confusing value for GUC_UNIT_BYTE Michael Paquier 06:27
Re: Proposal to provide the facility to set binary format output for specific OID's per session Ibrar Ahmed 06:30

Browse Archives

Prev | Next