pgsql-hackers since 2021-01-27 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

Jan. 27, 2021

Thread Author Time
Re: Single transaction in the tablesync worker? Peter Smith 00:39
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 01:06
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro Horiguchi 01:07
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro Horiguchi 01:13
Re: logical replication worker accesses catalogs in error context callback 📎 Bharath Rupireddy 01:17
Re: Transactions involving multiple postgres foreign servers, take 2 Fujii Masao 01:29
Re: wiki:PostgreSQL_14_Open_Items Michael Paquier 01:40
Re: Add SQL function for SHA1 📎 Michael Paquier 01:53
Re: logical replication worker accesses catalogs in error context callback Zhihong Yu 02:19
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi 02:35
Re: Add SQL function for SHA1 Sehrope Sarkuni 02:53
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 03:11
RE: Parallel INSERT (INTO ... SELECT ...) Hou, Zhijie 03:12
Re: [PATCH] remove pg_standby 📎 Thomas Munro 03:13
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 03:14
Re: Single transaction in the tablesync worker? Amit Kapila 03:53
Re: logical replication worker accesses catalogs in error context callback 📎 Bharath Rupireddy 04:07
Re: WIP: WAL prefetch (another approach) Thomas Munro 04:34
Re: [PATCH] remove pg_standby Michael Paquier 05:06
Re: Transactions involving multiple postgres foreign servers, take 2 📎 Masahiko Sawada 05:08
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently [email protected] 05:30
Re: [PATCH] remove pg_standby 📎 Thomas Munro 05:32
Re: Columns correlation and adaptive query optimization Yugo NAGATA 05:45
Re: doc review for v14 📎 Michael Paquier 05:52
RE: fix typo in reorderbuffer.c Hou, Zhijie 05:57
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Kyotaro Horiguchi 06:00
Re: fix typo in reorderbuffer.c Michael Paquier 06:08
Re: simplifying foreign key/RI checks Amit Langote 06:10
FailedAssertion in heap_index_delete_tuples at heapam.c:7220 📎 Jaime Casanova 06:52
Re: New IndexAM API controlling index vacuum strategies Masahiko Sawada 06:58
Re: simplifying foreign key/RI checks Tatsuro Yamada 07:07
Re: FailedAssertion in heap_index_delete_tuples at heapam.c:7220 Peter Geoghegan 07:09
RE: fix typo in reorderbuffer.c Hou, Zhijie 07:15
Re: Is Recovery actually paused? Masahiko Sawada 07:20
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 07:22
Re: Support for NSS as a libpq TLS backend 📎 Michael Paquier 07:39
RE: Parallel Inserts in CREATE TABLE AS 📎 Tang, Haiying 07:55
Re: simplifying foreign key/RI checks Keisuke Kuroda 07:58
Re: Is Recovery actually paused? Dilip Kumar 07:59
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Dilip Kumar 08:02
Re: [PATCH] remove pg_standby Fujii Masao 08:08
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 08:17
Re: [PoC] Non-volatile WAL buffer Takashi Menjo 08:28
Re: simplifying foreign key/RI checks Kyotaro Horiguchi 08:32
Re: Is Recovery actually paused? Yugo NAGATA 08:34
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Paul Guo 08:36
Re: Is Recovery actually paused? Dilip Kumar 08:58
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Amit Kapila 08:59
RE: ECPG: proposal for new DECLARE STATEMENT [email protected] 09:18
Two patches to speed up pg_rewind. 📎 Paul Guo 09:18
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Bharath Rupireddy 09:27
Freeze the inserted tuples during CTAS? Paul Guo 09:28
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Amit Kapila 09:30
Re: Freeze the inserted tuples during CTAS? Darafei Komяpa Praliaskouski 09:33
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Bharath Rupireddy 09:46
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax japin 09:51
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax japin 09:56
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 09:58
Re: poc - possibility to write window function in PL languages Pavel Stehule 09:58
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade 📎 Denis Laxalde 10:25
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Dilip Kumar 10:47
Re: Wrong usage of RelationNeedsWAL 📎 Noah Misch 10:48
Re: PoC/WIP: Extended statistics on expressions 📎 Dean Rasheed 11:02
Re: Protect syscache from bloating with negative cache entries 📎 Heikki Linnakangas 11:11
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Amit Kapila 11:12
Re: Online checksums patch - once again 📎 Daniel Gustafsson 11:19
Re: pg_upgrade fails with non-standard ACL Noah Misch 11:21
Re: Fix ALTER SUBSCRIPTION ... SET PUBLICATION documentation Amit Kapila 11:26
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 11:37
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Bharath Rupireddy 11:41
Re: Fix ALTER SUBSCRIPTION ... SET PUBLICATION documentation Bharath Rupireddy 11:47
Re: simplifying foreign key/RI checks 📎 Amit Langote 13:02
Re: Fix ALTER SUBSCRIPTION ... SET PUBLICATION documentation japin 13:21
Re: Printing backtrace of postgres processes 📎 vignesh C 13:35
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade Jehan-Guillaume de Rorthais 13:41
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Li Japin 14:05
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Li Japin 14:05
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade Jehan-Guillaume de Rorthais 14:06
Re: FailedAssertion in heap_index_delete_tuples at heapam.c:7220 Jaime Casanova 14:10
Re: Key management with tests Bruce Momjian 14:11
Re: Speeding up GIST index creation for tsvectors 📎 Amit Khandekar 15:06
Re: Online checksums patch - once again 📎 Heikki Linnakangas 15:37
Inconsistent function definitions in ECPG's informix.c Tom Lane 16:22
Re: pg_upgrade fails with non-standard ACL 📎 Anastasia Lubennikova 16:32
Re: Columns correlation and adaptive query optimization 📎 Konstantin Knizhnik 16:39
Re: [PoC] Non-volatile WAL buffer Tomas Vondra 16:41
Improve join selectivity estimation using extended statistics 📎 Konstantin Knizhnik 16:51
Re: Printing backtrace of postgres processes Andres Freund 17:09
Re: cleaning up a few CLOG-related things 📎 Robert Haas 17:35
Re: Support for NSS as a libpq TLS backend Jacob Champion 18:47
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Justin Pryzby 19:06
Re: [PATCH] Full support for index LP_DEAD hint bits on standby 📎 Michail Nikolaev 19:27
Re: Thoughts on "killed tuples" index hint bits support on standby Michail Nikolaev 19:30
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 19:30
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 19:34
protect pg_stat_statements_info() for being used without the library loaded 📎 Jaime Casanova 19:53
Re: Allow matching whole DN from a client certificate Jacob Champion 20:14
Re: archive status ".ready" files may be created too early Bossart, Nathan 20:16
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 20:37
Re: Allow matching whole DN from a client certificate Andrew Dunstan 20:42
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 21:19
Re: archive status ".ready" files may be created too early 📎 Bossart, Nathan 21:29
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Justin Pryzby 21:35
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 21:36
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alvaro Herrera 21:36
Index predicate locking and serializability contention Marcelo Zabani 22:01
Re: Is it useful to record whether plans are generic or custom? Tatsuro Yamada 22:53
Re: Is it useful to record whether plans are generic or custom? Tatsuro Yamada 22:56
Re: Is it useful to record whether plans are generic or custom? Tatsuro Yamada 23:02
Re: Is it useful to record whether plans are generic or custom? Tatsuro Yamada 23:11
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM 📎 Bossart, Nathan 23:16
Re: vacuum_cost_page_miss default value and modern hardware Peter Geoghegan 23:19
Re: Perform COPY FROM encoding conversions in larger chunks 📎 John Naylor 23:23

Jan. 28, 2021

Thread Author Time
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu 00:32
RE: Enhance traceability of wal_level changes for backup management 📎 [email protected] 00:44
Re: protect pg_stat_statements_info() for being used without the library loaded Julien Rouhaud 00:49
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Justin Pryzby 01:08
Re: Thoughts on "killed tuples" index hint bits support on standby Peter Geoghegan 01:24
Re: Thoughts on "killed tuples" index hint bits support on standby Peter Geoghegan 01:42
Re: row filtering for logical replication Andres Freund 02:20
RE: [POC] Fast COPY FROM command for the table with foreign partitions Tang, Haiying 02:40
RE: [PoC] Non-volatile WAL buffer [email protected] 02:45
Re: On login trigger: take three Amit Kapila 02:47
[PATCH] pg_hba.conf error messages for logical replication connections 📎 Paul Martinez 02:58
Re: Wrong usage of RelationNeedsWAL Kyotaro Horiguchi 03:06
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax Bharath Rupireddy 04:22
Re: Is Recovery actually paused? 📎 Dilip Kumar 04:25
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax 📎 japin 04:37
Re: On login trigger: take three Amit Kapila 04:54
Re: new heapcheck contrib module 📎 Mark Dilger 05:05
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 Justin Pryzby 05:43
Re: logical replication worker accesses catalogs in error context callback Amit Kapila 05:44
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 05:52
Re: Support for NSS as a libpq TLS backend Michael Paquier 06:06
Re: Single transaction in the tablesync worker? 📎 Peter Smith 06:18
RE: libpq debug log 📎 [email protected] 06:33
Re: protect pg_stat_statements_info() for being used without the library loaded Michael Paquier 06:42
Re: protect pg_stat_statements_info() for being used without the library loaded Fujii Masao 06:53
Re: pg_upgrade fails with non-standard ACL Noah Misch 06:55
Re: Single transaction in the tablesync worker? Peter Smith 07:01
Re: Wrong usage of RelationNeedsWAL Noah Misch 07:10
Re: protect pg_stat_statements_info() for being used without the library loaded Michael Paquier 07:26
Re: Add SQL function for SHA1 Michael Paquier 07:29
Re: Two patches to speed up pg_rewind. Michael Paquier 07:31
Re: [PATCH] remove pg_standby Michael Paquier 07:36
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro Horiguchi 07:50
Re: Protect syscache from bloating with negative cache entries Kyotaro Horiguchi 08:16
Re: "has_column_privilege()" issue with attnums and non-existent columns Peter Eisentraut 08:18
Re: Wrong usage of RelationNeedsWAL Kyotaro Horiguchi 08:35
Re: On login trigger: take three Konstantin Knizhnik 09:04
RE: libpq debug log [email protected] 09:50
Re: Single transaction in the tablesync worker? Amit Kapila 10:37
Re: pglz compression performance, take two Andrey Borodin 10:56
RE: Determine parallel-safety of partition relations for Inserts Hou, Zhijie 11:30
Re: Perform COPY FROM encoding conversions in larger chunks 📎 Heikki Linnakangas 11:36
Commitfest 2021-01 ends in 3 days Masahiko Sawada 11:37
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alexey Kondratov 11:42
Re: Printing backtrace of postgres processes 📎 vignesh C 11:52
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Amul Sul 12:16
Re: Determine parallel-safety of partition relations for Inserts Amit Kapila 12:28
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Peter Eisentraut 12:31
Re: [PATCH] Add extra statistics to explain for Nested Loop Yugo NAGATA 12:37
Re: Index Skip Scan (new UniqueKeys) Masahiko Sawada 12:49
Re: [PATCH] remove deprecated v8.2 containment operators Masahiko Sawada 12:50
Re: bitmaps and correlation Masahiko Sawada 12:51
Re: CREATE INDEX CONCURRENTLY on partitioned index Masahiko Sawada 12:51
Re: VACUUM (DISABLE_PAGE_SKIPPING on) Masahiko Sawada 12:52
Re: Perform COPY FROM encoding conversions in larger chunks Heikki Linnakangas 13:05
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Greg Nancarrow 13:11
Re: VACUUM (DISABLE_PAGE_SKIPPING on) Simon Riggs 13:33
Re: multi-install PostgresNode 📎 Andrew Dunstan 14:05
Re: Printing backtrace of postgres processes Bharath Rupireddy 14:10
Re: libpq debug log 'Alvaro Herrera' 14:13
Re: multi-install PostgresNode Alvaro Herrera 14:24
Re: CREATE INDEX CONCURRENTLY on partitioned index 📎 Justin Pryzby 14:30
Re: multi-install PostgresNode 📎 Andrew Dunstan 15:19
Re: strange error reporting Alvaro Herrera 15:55
Re: Index Skip Scan (new UniqueKeys) Dmitry Dolgov 16:07
Re: Allow matching whole DN from a client certificate Jacob Champion 16:39
Re: Perform COPY FROM encoding conversions in larger chunks 📎 Heikki Linnakangas 16:43
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 16:44
Re: new heapcheck contrib module Robert Haas 17:13
Re: vacuum_cost_page_miss default value and modern hardware Robert Haas 17:29
Re: new heapcheck contrib module Mark Dilger 17:40
Re: new heapcheck contrib module Mark Dilger 17:41
Re: new heapcheck contrib module Robert Haas 17:49
Re: new heapcheck contrib module Mark Dilger 17:50
Re: vacuum_cost_page_miss default value and modern hardware Peter Geoghegan 17:57
Re: new heapcheck contrib module 📎 Mark Dilger 18:07
Re: Thoughts on "killed tuples" index hint bits support on standby Michail Nikolaev 18:15
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Bossart, Nathan 18:16
Proposal: Save user's original authenticated identity for logging 📎 Jacob Champion 18:22
Re: Key management with tests Tom Kincaid 19:41
Re: Key management with tests Bruce Momjian 20:22
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Tom Lane 20:22
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 21:41
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 21:41
Re: Jsonpath ** vs lax mode 📎 Alexander Korotkov 21:44
Re: Allow matching whole DN from a client certificate Andrew Dunstan 22:10
Re: [PATCH] remove pg_standby Thomas Munro 22:13

Browse Archives

Prev | Next