pgsql-hackers since 2022-07-29 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)
Advanced Search

Browse Archives

Prev | Next

July 29, 2022

Thread Author Time
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Masahiko Sawada 00:06
Re: Cirrus CI (Windows help wanted) Justin Pryzby 00:49
RE: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. [email protected] 01:55
Re: Patch to address creation of PgStat* contexts with null parent context Kyotaro Horiguchi 02:53
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. Peter Smith 02:56
Re: Handle infinite recursion in logical replication setup Peter Smith 03:01
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO Richard Guo 03:23
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. Amit Kapila 03:29
Re: Windows default locale vs initdb Thomas Munro 03:33
Re: generic plans and "initial" pruning Amit Langote 04:20
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. 📎 Peter Smith 04:38
Re: generic plans and "initial" pruning Tom Lane 04:55
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎 Kyotaro Horiguchi 05:20
Re: Handle infinite recursion in logical replication setup 📎 vignesh C 05:21
Re: Pluggable toaster Nikita Malakhov 06:16
Re: [Commitfest 2022-07] Patch Triage: Needs Review, Part 1 Julien Rouhaud 06:38
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Amit Kapila 06:45
Re: Inconvenience of pg_read_binary_file() 📎 Kyotaro Horiguchi 07:21
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎 Pavel Borisov 08:11
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() Alexander Korotkov 08:35
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. Alvaro Herrera 09:35
Re: making relfilenodes 56 bits Alvaro Herrera 09:36
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. Peter Smith 09:51
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. Alvaro Herrera 09:59
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 10:17
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. Amit Kapila 10:25
Re: Table AM and DROP TABLE [ Was: Table AM and DDLs] Mats Kindahl 10:36
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Alvaro Herrera 10:59
Re: generic plans and "initial" pruning Robert Haas 12:22
Re: pg_auth_members.grantor is bunk Robert Haas 12:46
Re: Hash index build performance tweak from sorting Simon Riggs 12:49
Re: Maximize page freezing Simon Riggs 12:55
Re: making relfilenodes 56 bits Ashutosh Sharma 12:56
Should fix a comment referring to stats collector? 📎 torikoshia 13:05
Re: doc phrase: "inheritance child" Justin Pryzby 13:29
Re: Expose Parallelism counters planned/execute in pg_stat_statements 📎 Daymel Bonne Solís 13:36
Re: making relfilenodes 56 bits Ashutosh Sharma 14:32
Re: Maximize page freezing 📎 Simon Riggs 14:37
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher 📎 Önder Kalacı 14:59
Re: generic plans and "initial" pruning Tom Lane 15:04
Re: [BUG] Panic due to incorrect missingContrecPtr after promotion Imseih (AWS), Sami 15:07
Re: Slow standby snapshot 📎 Simon Riggs 15:08
Re: Temporary file access API 📎 Antonin Houska 15:37
Re: making relfilenodes 56 bits vignesh C 15:44
Re: generic plans and "initial" pruning Robert Haas 15:56
Re: Documentation about PL transforms chap 16:35
Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated Reid Thompson 16:43
Re: generic plans and "initial" pruning Tom Lane 16:47
Re: Temporary file access API Robert Haas 16:52
Re: generic plans and "initial" pruning Robert Haas 16:55
Re: [Commitfest 2022-07] Patch Triage: Needs Review, Part 1 Jacob Champion 16:57
Re: [Commitfest 2022-07] Patch Triage: Needs Review, Part 1 Jacob Champion 17:08
Re: [Commitfest 2022-07] Patch Triage: Needs Review, Part 1 Julien Rouhaud 17:21
Re: Slow standby snapshot Michail Nikolaev 17:24
Re: making relfilenodes 56 bits Robert Haas 17:24
Re: Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated Nathan Bossart 17:48
Re: pg15b2: large objects lost on upgrade Tom Lane 17:49
Re: Should fix a comment referring to stats collector? Alvaro Herrera 17:53
Re: Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated Tom Lane 17:55
Re: making relfilenodes 56 bits Alvaro Herrera 18:12
Re: Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated Nathan Bossart 18:23
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andrew Dunstan 18:27
Re: pg15b2: large objects lost on upgrade Robert Haas 18:35
Re: making relfilenodes 56 bits Robert Haas 18:41
Re: enable/disable broken for statement triggers on partitioned tables 📎 Alvaro Herrera 18:44
Re: Documentation about PL transforms Pavel Stehule 18:47
Re: Maximize page freezing Peter Geoghegan 18:48
Re: pg15b2: large objects lost on upgrade Robert Haas 19:10
Re: Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated Tomas Vondra 19:16
Re: making relfilenodes 56 bits Alvaro Herrera 19:18
Re: Inconvenience of pg_read_binary_file() Tom Lane 19:44
Re: pg15b2: large objects lost on upgrade 📎 Robert Haas 19:51
Re: making relfilenodes 56 bits Robert Haas 19:57
Re: pg15b2: large objects lost on upgrade Tom Lane 20:00
Re: making relfilenodes 56 bits Tom Lane 20:05
Re: making relfilenodes 56 bits Tom Lane 20:08
Re: enable/disable broken for statement triggers on partitioned tables Tom Lane 20:25
Re: making relfilenodes 56 bits Robert Haas 20:29
Re: Maximize page freezing Matthias van de Meent 20:49
Re: [Commitfest 2022-07] Begins Now Jacob Champion 21:02
Re: making relfilenodes 56 bits Thomas Munro 21:11
Re: pg15b2: large objects lost on upgrade Robert Haas 21:13
Re: Improve TAP tests of pg_upgrade for cross-version tests 📎 Justin Pryzby 21:15
Re: making relfilenodes 56 bits Thomas Munro 21:17
Re: pg15b2: large objects lost on upgrade Andrew Dunstan 21:26
Re: pg15b2: large objects lost on upgrade Robert Haas 22:28
Re: Trying to add more tests to gistbuild.c Tom Lane 22:53
Re: pg15b2: large objects lost on upgrade Tom Lane 23:16
Re: pg15b2: large objects lost on upgrade Robert Haas 23:36

July 30, 2022

Thread Author Time
Re: pg15b2: large objects lost on upgrade Tom Lane 00:02
Re: Is it correct to say, "invalid data in file \"%s\"", BACKUP_LABEL_FILE in do_pg_backup_stop? 📎 Bharath Rupireddy 00:07
Re: pg15b2: large objects lost on upgrade 📎 Robert Haas 00:08
Re: pg15b2: large objects lost on upgrade Tom Lane 00:22
Re: Inconvenience of pg_read_binary_file() Michael Paquier 02:37
Re: Inconvenience of pg_read_binary_file() Tom Lane 03:35
Re: making relfilenodes 56 bits Dilip Kumar 03:45
Re: optimize lookups in snapshot [sub]xip arrays John Naylor 05:02
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) 📎 Justin Pryzby 05:35
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart 05:38
Re: pg15b2: large objects lost on upgrade Noah Misch 05:44
Re: Inconvenience of pg_read_binary_file() Michael Paquier 05:51
Re: A proposal for shared memory based backup infrastructure mahendrakar s 06:53
Re: Introduce wait_for_subscription_sync for TAP tests Amit Kapila 06:55
Re: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger 📎 Michael Paquier 07:14
Re: Support for grabbing multiple consecutive values with nextval() Michael Paquier 07:21
Re: Improve TAP tests of pg_upgrade for cross-version tests Michael Paquier 07:29
Re: Allow file inclusion in pg_hba and pg_ident files 📎 Julien Rouhaud 08:09
Re: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. 📎 Amit Kapila 11:24
Re: making relfilenodes 56 bits Alvaro Herrera 11:39
Re: Inconvenience of pg_read_binary_file() Alvaro Herrera 11:47
Re: [PATCH] Add extra statistics to explain for Nested Loop Julien Rouhaud 12:54
RE: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger [email protected] 13:13
RE: Functions 'is_publishable_class' and 'is_publishable_relation' should stay together. [email protected] 13:29
Re: Inconvenience of pg_read_binary_file() Tom Lane 14:24
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Tom Lane 14:37
Re: pg15b2: large objects lost on upgrade Tom Lane 14:40
Re: Using each rel as both outer and inner for JOIN_ANTI Tom Lane 16:07
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Tom Lane 16:51
Re: Problem about postponing gathering partial paths for topmost scan/join rel Tom Lane 17:15
Re: Add test of pg_prewarm extenion Tom Lane 18:25
Re: Trying to add more tests to gistbuild.c 📎 Matheus Alcantara 18:55
Re: pg_buffercache: add sql test Tom Lane 19:39
Re: Trying to add more tests to gistbuild.c Tom Lane 20:33
Re: Add TAP test for auth_delay extension Tom Lane 21:13
Re: add test: pg_rowlocks extension Tom Lane 21:32
Reducing the maintenance overhead of test_oat_hooks 📎 Tom Lane 22:08
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Thomas Munro 23:08
Regression coverage for contrib/tcn 📎 Tom Lane 23:09
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Tom Lane 23:17

July 31, 2022

Thread Author Time
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Thomas Munro 03:46
Re: [PATCH] Add extra statistics to explain for Nested Loop Julien Rouhaud 03:49
Re: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger Michael Paquier 04:11
Re: Race between KeepFileRestoredFromArchive() and restartpoint Noah Misch 06:17
Re: remove more archiving overhead Noah Misch 06:51
Re: Reducing the maintenance overhead of test_oat_hooks Alvaro Herrera 11:17
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row 📎 Hamid Akhtar 13:00
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row 📎 Hamid Akhtar 13:18
pg_upgrade errno Justin Pryzby 13:41
Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory mahendrakar s 15:05
Re: Improve TAP tests of pg_upgrade for cross-version tests Anton A. Melnikov 15:22
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Tom Lane 15:49
TAP tests vs log_error verbosity=verbose Andrew Dunstan 16:10
Re: TAP tests vs log_error verbosity=verbose Tom Lane 16:14
Triggers should work in isolation, with a final conflict detection step Gianluca Calcagni 16:39
Re: TAP tests vs log_error verbosity=verbose Andrew Dunstan 16:57
Re: [Patch] Fix bounds check in trim_array() Tom Lane 17:25
Re: pg_auth_members.grantor is bunk Stephen Frost 18:18
Re: pg_auth_members.grantor is bunk Tom Lane 18:33
Re: pg_auth_members.grantor is bunk David G. Johnston 18:43
Re: How to retain lesser paths at add_path()? Tom Lane 19:10
Re: ci: update to freebsd 13.1 / remove minor versions from image names Andres Freund 19:43
Re: How to retain lesser paths at add_path()? Tom Lane 20:05
Re: Cirrus CI (Windows help wanted) Andres Freund 20:31
Re: [Proposal] vacuumdb --schema only Andrew Dunstan 20:50
Re: pg_auth_members.grantor is bunk Stephen Frost 21:19
[PATCH] Backport perl tests for pg_upgrade from 322becb60 📎 Anton A. Melnikov 22:02
Re: [PATCH] Fix pg_upgrade test from v10 Anton A. Melnikov 22:04
Re: ci: update to freebsd 13.1 / remove minor versions from image names Thomas Munro 22:07
Re: The "char" type versus non-ASCII characters 📎 Tom Lane 22:25
Re: ci: update to freebsd 13.1 / remove minor versions from image names Andres Freund 23:27
Typo in "43.9.1. Reporting Errors and Messages"? PG Doc comments form 23:37
Re: pg_upgrade errno Michael Paquier 23:39
Re: pg_upgrade errno Tom Lane 23:43

Aug. 1, 2022

Thread Author Time
Re: pg_upgrade errno Michael Paquier 00:19
Re: Backup command and functions can cause assertion failure and segmentation fault Michael Paquier 00:33
Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud 01:12
Re: pg_buffercache: add sql test Julien Rouhaud 01:47
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO 📎 Zhang Mingli 01:59
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Andres Freund 02:01
Re: ci: update to freebsd 13.1 / remove minor versions from image names Andres Freund 02:02
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 📎 Masahiko Sawada 02:16
RE: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger [email protected] 03:33
Re: enable/disable broken for statement triggers on partitioned tables Amit Langote 03:51
Re: Fast COPY FROM based on batch insert Etsuro Fujita 04:00
Re: Support logical replication of DDLs Peter Smith 04:18
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud 04:53
Re: Checking pgwin32_is_junction() errors 📎 Thomas Munro 05:09
Re: making relfilenodes 56 bits Dilip Kumar 05:20
RE: Handle infinite recursion in logical replication setup [email protected] 05:27
Re: making relfilenodes 56 bits Dilip Kumar 05:34
RE: Partial aggregates pushdown [email protected] 05:55
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 06:24
Re: Add test of pg_prewarm extenion 📎 Dong Wook Lee 06:27
Re: Oversight in slab.c SlabContextCreate(), initial memory allocation size is not populated to context->mem_allocated Kyotaro Horiguchi 07:57
Re: Handle infinite recursion in logical replication setup Peter Smith 08:02
Re: Inconvenience of pg_read_binary_file() Kyotaro Horiguchi 08:41
Re: Handle infinite recursion in logical replication setup Amit Kapila 08:51
Typo in pg_db_role_setting.h Japin Li 09:18
Re: Typo in pg_db_role_setting.h Richard Guo 09:28
Re: Add test of pg_prewarm extenion Julien Rouhaud 09:55
Question about user/database-level parameters Japin Li 10:24
Re: Trying to add more tests to gistbuild.c Pavel Borisov 10:30
Re: [PATCH] Compression dictionaries for JSONB 📎 Aleksander Alekseev 11:25
Re: making relfilenodes 56 bits 📎 Dilip Kumar 11:57
Re: Should fix a comment referring to stats collector? torikoshia 12:05
Re: logical replication restrictions 📎 Euler Taveira 12:07
Re: NAMEDATALEN increase because of non-latin languages 📎 John Naylor 12:38
Re: Typo in pg_db_role_setting.h John Naylor 12:46
Re: logical replication restrictions Euler Taveira 13:15
Re: Reducing planning time on tables with many indexes David Geier 13:33

Browse Archives

Prev | Next