pgsql-hackers since 2021-01-16 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. 16, 2021

Thread Author Time
Re: Key management with tests 📎 Bruce Momjian 00:21
Re: Key management with tests Andres Freund 00:56
Re: Key management with tests Bruce Momjian 01:49
Re: Is Recovery actually paused? Masahiko Sawada 03:28
Re: Key management with tests Andres Freund 04:20
Re: Add table access method as an option to pgbench Michael Paquier 04:34
Re: Wrong usage of RelationNeedsWAL Noah Misch 04:38
Re: Key management with tests Michael Paquier 04:39
Re: Occasional tablespace.sql failures in check-world -jnn Michael Paquier 04:46
Re: Determine parallel-safety of partition relations for Inserts Amit Kapila 05:04
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 05:06
Re: remove unneeded pstrdup in fetch_table_list Amit Kapila 05:09
new release pspg Pavel Stehule 05:22
Re: Determine parallel-safety of partition relations for Inserts Amit Kapila 05:49
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION 📎 Bharath Rupireddy 06:21
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Amit Kapila 06:34
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION japin 06:39
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 06:51
Re: Pg14, pg_dumpall and "password_encryption=true" Noah Misch 07:26
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 08:00
Re: Alter timestamp without timezone to with timezone rewrites rows Noah Misch 11:53
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION 📎 Bharath Rupireddy 12:38
Re: trailing junk in numeric literals Vik Fearing 13:02
Re: Dump public schema ownership & seclabels Vik Fearing 13:05
Re: LET clause Vik Fearing 13:21
Re: WIP: System Versioned Temporal Table Vik Fearing 14:03
Re: WIP: System Versioned Temporal Table Vik Fearing 14:08
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Anastasia Lubennikova 15:11
Re: trailing junk in numeric literals Andreas Karlsson 15:32
Re: recovering from "found xmin ... from before relfrozenxid ..." Andrey Borodin 15:41
Re: PoC/WIP: Extended statistics on expressions 📎 Tomas Vondra 16:48
Re: trailing junk in numeric literals Vik Fearing 16:54
Re: Alter timestamp without timezone to with timezone rewrites rows Tom Lane 17:03
Re: trailing junk in numeric literals Tom Lane 17:10
Re: trailing junk in numeric literals Vik Fearing 17:19
Re: Printing backtrace of postgres processes vignesh C 17:34
Re: Printing backtrace of postgres processes Andres Freund 17:39
Re: WIP: System Versioned Temporal Table Surafel Temesgen 18:39
Re: WIP: System Versioned Temporal Table Vik Fearing 19:12
Re: LET clause Joel Jacobson 19:28
Re: trailing junk in numeric literals Tom Lane 20:18
Re: Printing backtrace of postgres processes Tom Lane 20:21
Re: Outdated replication protocol error? Jeff Davis 21:11
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tomas Vondra 22:18
Re: Is Recovery actually paused? Masahiko Sawada 22:21
Re: New Table Access Methods for Multi and Single Inserts Jeff Davis 23:04
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 23:22
Re: list of extended statistics on psql Tomas Vondra 23:32

Jan. 17, 2021

Thread Author Time
Re: Key management with tests Tom Kincaid 00:08
Re: Alter timestamp without timezone to with timezone rewrites rows Noah Misch 00:20
Re: PoC/WIP: Extended statistics on expressions 📎 Tomas Vondra 00:23
RE: list of extended statistics on psql Shinoda, Noriyoshi (PN Japan FSIP) 01:41
Re: Why does create_gather_merge_plan need make_sort? Tomas Vondra 01:43
Re: list of extended statistics on psql Tomas Vondra 02:01
Calculation of relids (pull_varnos result) for PlaceHolderVars 📎 Tom Lane 02:12
Re: PoC/WIP: Extended statistics on expressions Zhihong Yu 02:55
RE: Disable WAL logging to speed up data loading [email protected] 05:16
RE: libpq debug log [email protected] 05:23
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 05:29
Re: Is Recovery actually paused? Dilip Kumar 05:41
Re: Deleting older versions in unique indexes to avoid page splits Amit Kapila 05:57
Re: Is Recovery actually paused? Dilip Kumar 06:03
Re: Key management with tests Amit Kapila 06:24
Re: Key management with tests Andres Freund 06:58
Re: Test harness for regex code (to allow importing Tcl's test suite) Alexander Lakhin 07:00
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 07:39
Re: Is Recovery actually paused? Dilip Kumar 08:18
Re: Dump public schema ownership & seclabels Noah Misch 09:41
Re: Dump public schema ownership & seclabels Vik Fearing 11:00
Re: Determine parallel-safety of partition relations for Inserts Amit Langote 11:15
Re: Pg14, pg_dumpall and "password_encryption=true" Magnus Hagander 12:51
Re: Add session statistics to pg_stat_database Magnus Hagander 13:07
Re: Prevent printing "next step instructions" in initdb and pg_upgrade Magnus Hagander 13:38
cgit view availabel Magnus Hagander 13:48
Re: WIP: document the hook system Magnus Hagander 13:53
Re: list of extended statistics on psql Tomas Vondra 14:31
Re: Online checksums patch - once again Magnus Hagander 14:35
Re: POC: Cleaning up orphaned files using undo logs Dmitry Dolgov 15:44
Re: cgit view availabel Victor Yegorov 16:00
Re: cgit view availabel Magnus Hagander 16:19
evtfoid and evtowner missing in findoidjoins/README Joel Jacobson 16:38
Re: cgit view availabel Victor Yegorov 16:46
Re: WIP: System Versioned Temporal Table Surafel Temesgen 16:46
Re: list of extended statistics on psql Justin Pryzby 16:52
Re: Printing backtrace of postgres processes vignesh C 16:56
Re: evtfoid and evtowner missing in findoidjoins/README Tom Lane 17:16
Re: Test harness for regex code (to allow importing Tcl's test suite) Tom Lane 17:54
Re: cgit view availabel Magnus Hagander 17:58
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Zhihong Yu 18:02
Re: cgit view availabel Chapman Flack 18:11
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 19:12
Re: evtfoid and evtowner missing in findoidjoins/README Joel Jacobson 20:15
Re: evtfoid and evtowner missing in findoidjoins/README Tom Lane 20:32
Re: Yet another fast GiST build Tom Lane 20:50
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tomas Vondra 21:32
Re: pgbench: option delaying queries till connections establishment? 📎 Thomas Munro 21:54
pg_collation_actual_version() ERROR: cache lookup failed for collation 123 Justin Pryzby 21:59
Re: Add primary keys to system catalogs Tom Lane 22:07
Re: Pg14, pg_dumpall and "password_encryption=true" Noah Misch 22:20
Re: pg_collation_actual_version() ERROR: cache lookup failed for collation 123 Thomas Munro 22:22
Re: Yet another fast GiST build Peter Geoghegan 22:35
Re: WIP: System Versioned Temporal Table Vik Fearing 22:42
Re: Yet another fast GiST build Heikki Linnakangas 22:52
Re: Yet another fast GiST build Peter Geoghegan 23:04
Re: Yet another fast GiST build Peter Geoghegan 23:10
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 23:14
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 23:26
Re: Add primary keys to system catalogs Robert Haas 23:35

Jan. 18, 2021

Thread Author Time
Re: NOT VALID for Unique Indexes David Fetter 00:34
RE: Determine parallel-safety of partition relations for Inserts [email protected] 00:38
Re: Key management with tests Robert Haas 00:50
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 00:57
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tatsuo Ishii 01:41
RE: libpq debug log [email protected] 01:45
Re: adding wait_start column to pg_locks 📎 torikoshia 03:00
Re: Determine parallel-safety of partition relations for Inserts Amit Kapila 03:04
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 03:12
Re: Determine parallel-safety of partition relations for Inserts Amit Kapila 03:17
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 03:33
Re: fdatasync(2) on macOS Thomas Munro 03:39
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 04:06
Re: Add docs stub for recovery.conf Craig Ringer 04:07
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Fujii Masao 04:08
Re: fdatasync(2) on macOS Tom Lane 04:08
Re: Printing backtrace of postgres processes Craig Ringer 04:10
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 04:46
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 04:53
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Pavan Deolasee 04:53
RE: Determine parallel-safety of partition relations for Inserts [email protected] 04:57
Re: some pointless HeapTupleHeaderIndicatesMovedPartitions calls Pavan Deolasee 04:57
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 05:00
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 05:12
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 05:15
Re: New IndexAM API controlling index vacuum strategies 📎 Masahiko Sawada 05:18
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 05:18
RE: libpq debug log [email protected] 05:52
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 05:54
Re: Is Recovery actually paused? 📎 Dilip Kumar 05:56
RE: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Hou, Zhijie 06:02
Re: Wrong usage of RelationNeedsWAL 📎 Kyotaro Horiguchi 06:08
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 06:14
Re: Pg14, pg_dumpall and "password_encryption=true" Michael Paquier 06:18
Re: New IndexAM API controlling index vacuum strategies 📎 Masahiko Sawada 06:20
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 06:28
Re: Wrong usage of RelationNeedsWAL Noah Misch 06:36
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 06:37
Re: Deleting older versions in unique indexes to avoid page splits Amit Kapila 06:46
RE: POC: postgres_fdw insert batching 📎 [email protected] 06:51
Re: Wrong usage of RelationNeedsWAL Noah Misch 07:02
Re: Support for NSS as a libpq TLS backend Michael Paquier 07:08
Re: list of extended statistics on psql Tatsuro Yamada 07:18
Re: list of extended statistics on psql Tatsuro Yamada 07:24
Re: list of extended statistics on psql Tatsuro Yamada 07:31
RE: Parallel INSERT (INTO ... SELECT ...) Tang, Haiying 07:32
RE: Stronger safeguard for archive recovery not to miss data 📎 [email protected] 07:34
Re: list of extended statistics on psql Tatsuro Yamada 07:43
Narrow the scope of the variable outputstr in logicalrep_write_tuple 📎 japin 07:46
Re: Lazy JIT IR code generation to increase JIT speed with partitions Luc Vlaming 07:47
RE: ResourceOwner refactoring [email protected] 07:49
[PATCH] Cross-reference comments on signal handling logic 📎 Craig Ringer 07:51
[PATCH] More docs on what to do and not do in extension code 📎 Craig Ringer 07:56
Re: New Table Access Methods for Multi and Single Inserts Luc Vlaming 07:58
[PATCH] ProcessInterrupts_hook 📎 Craig Ringer 07:59
Re: Narrow the scope of the variable outputstr in logicalrep_write_tuple Bharath Rupireddy 07:59
Re: Narrow the scope of the variable outputstr in logicalrep_write_tuple 📎 japin 08:09
Re: Code of Conduct plan,Re: Code of Conduct plan 📎 Tatsuo Ishii 08:17
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 08:23
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 08:28
Re: Wrong usage of RelationNeedsWAL Kyotaro Horiguchi 08:30
Re: Improve handling of parameter differences in physical replication Peter Eisentraut 08:33
Re: Determine parallel-safety of partition relations for Inserts Amit Kapila 08:33
RE: Determine parallel-safety of partition relations for Inserts [email protected] 08:37
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 08:37
Re: evtfoid and evtowner missing in findoidjoins/README 📎 Joel Jacobson 08:41
RE: Parallel INSERT (INTO ... SELECT ...) Tang, Haiying 09:10
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 09:12
RE: Parallel INSERT (INTO ... SELECT ...) Tang, Haiying 09:12
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 09:23
Re: popcount Peter Eisentraut 09:24
Re: proposal: schema variables Pavel Stehule 09:50
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 09:54
Re: proposal: schema variables Pavel Stehule 09:57
Re: proposal: schema variables 📎 Pavel Stehule 09:59
Re: Proposal: Global Index 曾文旌 10:00
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 10:19
Re: Allow matching whole DN from a client certificate Daniel Gustafsson 10:23
search_plan_tree(): handling of non-leaf CustomScanState nodes causes segfault 📎 David Geier 10:43
Re: Single transaction in the tablesync worker? 📎 Peter Smith 10:43
Re: Deleting older versions in unique indexes to avoid page splits Victor Yegorov 11:41
Re: search_plan_tree(): handling of non-leaf CustomScanState nodes causes segfault Ashutosh Bapat 11:43
Re: [PATCH] Add extra statistics to explain for Nested Loop Michael Christofides 11:45
Re: Narrow the scope of the variable outputstr in logicalrep_write_tuple Bharath Rupireddy 11:48
Re: [UNVERIFIED SENDER] Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 11:48
Re: ResourceOwner refactoring 📎 Heikki Linnakangas 12:22
simplifying foreign key/RI checks 📎 Amit Langote 12:39
Re: Yet another fast GiST build Heikki Linnakangas 12:40
Re: Deleting older versions in unique indexes to avoid page splits Amit Kapila 12:45
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 12:47
回复:BEFORE ROW triggers for partitioned tables 李杰 (慎追) 12:59
回复:BEFORE ROW triggers for partitioned tables 李杰 (慎追) 13:03

Browse Archives

Prev | Next