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

Thread Author Time
Re: list of extended statistics on psql 📎 Tomas Vondra 00:01
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 00:04
Re: Add table access method as an option to pgbench David Zhang 00:59
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 01:12
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW 📎 Bharath Rupireddy 01:38
Re: Improper use about DatumGetInt32 Michael Paquier 01:46
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW japin 02:02
Re: [PATCH] Simple progress reporting for COPY command Bharath Rupireddy 02:04
Re: logical replication worker accesses catalogs in error context callback Bharath Rupireddy 05:57
Re: Single transaction in the tablesync worker? Amit Kapila 06:46
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 07:27
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 10:17
pg_dump vs. GRANT OPTION among initial privileges 📎 Noah Misch 10:24
Re: WIP: System Versioned Temporal Table Simon Riggs 10:39
Re: Implement <null treatment> for window functions 📎 Krasiyan Andreev 11:30
Re: Added schema level support for publication. vignesh C 11:51
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 12:40
Re: Improper use about DatumGetInt32 Peter Eisentraut 12:41
Re: Add table access method as an option to pgbench youichi aramaki 13:44
Re: Added schema level support for publication. Bharath Rupireddy 14:38
Re: Added schema level support for publication. Bharath Rupireddy 14:43
Re: Implement <null treatment> for window functions Krasiyan Andreev 15:01
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Andrey Borodin 15:25
Re: Implement <null treatment> for window functions Zhihong Yu 15:29
Fix \watch if expanded output is on and there are no results 📎 Michael Banck 15:40
Re: Key management with tests 📎 Bruce Momjian 18:17
Re: [HACKERS] [PATCH] Generic type subscripting Dian M Fay 19:02
Use pg_pwrite() in pg_test_fsync 📎 Thomas Munro 20:21
Re: libpq compression 📎 Justin Pryzby 20:31
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 20:34
Re: [HACKERS] [PATCH] Generic type subscripting Dian M Fay 21:29
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 22:15

Jan. 10, 2021

Thread Author Time
Re: Key management with tests 📎 Bruce Momjian 01:08
Re: support for MERGE 📎 Tomas Vondra 01:44
Re: Key management with tests Bruce Momjian 02:45
Re: Key management with tests Thomas Munro 05:04
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Andrey Borodin 06:44
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding 📎 Noah Misch 09:43
Re: Added schema level support for publication. Dilip Kumar 09:58
Inconsistent "<acronym>" use 📎 Tatsuo Ishii 11:22
invalid data in file backup_label problem on windows 📎 Wang, Shenhao 12:57
Re: Key management with tests 📎 Bruce Momjian 14:51
Re: support for MERGE Vik Fearing 15:36
Re: proposal: schema variables 📎 Pavel Stehule 16:54
Re: [HACKERS] Custom compression methods Justin Pryzby 17:29
Re: Added schema level support for publication. vignesh C 17:51
Re: Added schema level support for publication. vignesh C 17:52
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 18:52
Re: new heapcheck contrib module Thomas Munro 20:41
Re: Terminate the idle sessions Tom Lane 20:58
Re: zstd compression for pg_dump Andreas Karlsson 21:06
Re: Inconsistent "<acronym>" use Noah Misch 21:11
Re: [PATCH] Automatic HASH and LIST partition creation Thomas Munro 21:22
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎 Justin Pryzby 22:15
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Tomas Vondra 22:35
Re: Multiple hosts in connection string failed to failover in non-hot standby mode 📎 Tom Lane 22:38
Re: Inconsistent "<acronym>" use Bruce Momjian 23:23

Jan. 11, 2021

Thread Author Time
Re: Inconsistent "<acronym>" use Tom Lane 00:02
Re: Deleting older versions in unique indexes to avoid page splits 📎 Peter Geoghegan 00:06
RE: Disable WAL logging to speed up data loading [email protected] 00:14
RE: Parallel Inserts in CREATE TABLE AS Hou, Zhijie 01:07
Re: pg_preadv() and pg_pwritev() Thomas Munro 02:34
Re: Inconsistent "<acronym>" use Tatsuo Ishii 02:39
Re: Multiple hosts in connection string failed to failover in non-hot standby mode 📎 Tom Lane 02:56
Re: pg_preadv() and pg_pwritev() Thomas Munro 02:59
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 03:21
O(n^2) system calls in RemoveOldXlogFiles() Thomas Munro 03:35
Re: Removing unneeded self joins 📎 Andrey V. Lepikhov 04:07
Re: Single transaction in the tablesync worker? Amit Kapila 04:34
Re: logical replication worker accesses catalogs in error context callback 📎 Masahiko Sawada 05:25
Re: [HACKERS] Custom compression methods Dilip Kumar 05:30
Re: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion Masahiko Sawada 05:39
Re: Added schema level support for publication. Bharath Rupireddy 06:15
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Andrey Borodin 06:22
Re: [HACKERS] Custom compression methods Dilip Kumar 06:41
Re: [HACKERS] Custom compression methods Justin Pryzby 06:51
Re: Moving other hex functions to /common Michael Paquier 07:45
Re: psql \df choose functions by their arguments 📎 Ian Lawrence Barwick 07:45
Re: logical replication worker accesses catalogs in error context callback 📎 Bharath Rupireddy 07:46
Re: Reduce the time required for a database recovery from archive. Dmitry Shulga 07:51
Re: Added schema level support for publication. japin 07:59
Re: Improper use about DatumGetInt32 Michael Paquier 08:09
Re: Added schema level support for publication. Bharath Rupireddy 09:06
Re: [HACKERS] Custom compression methods Dilip Kumar 10:10
Re: Single transaction in the tablesync worker? Ajin Cherian 10:23
Re: Added schema level support for publication. Li Japin 10:59
Re: Single transaction in the tablesync worker? Amit Kapila 11:00
Re: Key management with tests 📎 Masahiko Sawada 11:12
Re: Proposal: Global Index 曾文旌 11:40
Re: adding partitioned tables to publications 📎 Amit Kapila 11:42
Re: Added schema level support for publication. Amit Kapila 11:57
Re: Added schema level support for publication. Bharath Rupireddy 11:58
RE: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Tang, Haiying 11:59
Re: adding partitioned tables to publications Mark Zhao 12:03
Re: Proposal: Global Index 曾文旌 13:00
Re: [Bug Fix] Logical replication on partition table is very slow and CPU is 99% Ashutosh Bapat 13:00
Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 13:21
Re: Added schema level support for publication. Bharath Rupireddy 13:22
Re: libpq compression 📎 Konstantin Knizhnik 13:53
Re: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion Peter Eisentraut 14:00
Re: WIP: System Versioned Temporal Table 📎 Simon Riggs 14:02
Re: pg_upgrade test for binary compatibility of core data types Peter Eisentraut 14:28
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Hubert Zhang 14:31
Re: multi-install PostgresNode Peter Eisentraut 14:34
Re: popcount Peter Eisentraut 14:50
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Tom Lane 15:15
Re: pg_upgrade test for binary compatibility of core data types Bruce Momjian 15:21
Re: popcount 📎 David Fetter 16:13
Re: Add Nullif case for eval_const_expressions_mutator Tom Lane 16:20
Re: Moving other hex functions to /common Bruce Momjian 16:27
Re: Key management with tests Bruce Momjian 17:22
Re: libpq compression 📎 Tomas Vondra 17:38
Re: Proposal: Global Index Bruce Momjian 17:46
Re: Key management with tests Stephen Frost 17:54
Re: Key management with tests Bruce Momjian 18:04
Re: new heapcheck contrib module 📎 Mark Dilger 18:16
Re: [POC] Fast COPY FROM command for the table with foreign partitions Tomas Vondra 18:16
Re: Key management with tests Stephen Frost 18:23
Re: Proposal: Global Index Tom Lane 18:34
Re: Proposal: Global Index Robert Haas 18:37
Re: Proposal: Global Index Peter Geoghegan 19:01
Re: Key management with tests Bruce Momjian 19:06
Re: Key management with tests Stephen Frost 19:19
Re: Proposal: Global Index Bruce Momjian 19:23
Re: Proposal: Global Index Bruce Momjian 19:25
Re: Proposal: Global Index Peter Geoghegan 20:05
Re: Deleting older versions in unique indexes to avoid page splits 📎 Victor Yegorov 20:19
Re: Key management with tests Bruce Momjian 20:22
Re: Proposal: Global Index Bruce Momjian 20:24
Re: Key management with tests Stephen Frost 20:52
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Anastasia Lubennikova 21:00
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 21:09
Re: Deleting older versions in unique indexes to avoid page splits Victor Yegorov 21:26
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tomas Vondra 21:51
Re: Implement <null treatment> for window functions Tom Lane 22:00
Re: Online checksums patch - once again 📎 Daniel Gustafsson 23:07

Jan. 12, 2021

Thread Author Time
Outdated replication protocol error? Jeff Davis 00:06
Re: Key management with tests Masahiko Sawada 00:32
Re: Huge memory consumption on partitioned table with FKs Keisuke Kuroda 00:48
Re: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion Masahiko Sawada 00:59
Re: libpq compression Justin Pryzby 01:20
Re: A failure of standby to follow timeline switch 📎 Fujii Masao 01:47
Re: list of extended statistics on psql 📎 Tatsuro Yamada 01:57
Re: POC: postgres_fdw insert batching 📎 Tomas Vondra 02:06
Re: [PATCH] Feature improvement for CLOSE, FETCH, MOVE tab completion Fujii Masao 02:09
Re: Key management with tests Bruce Momjian 02:09
Re: Moving other hex functions to /common 📎 Michael Paquier 02:26
Re: pg_dump, ATTACH, and independently restorable child partitions Tom Lane 02:28
RE: POC: postgres_fdw insert batching [email protected] 03:04
RE: Disable WAL logging to speed up data loading 📎 [email protected] 03:13
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 03:19
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Amit Kapila 03:37
Re: Key management with tests Neil Chen 03:40
Re: Movement of restart_lsn position movement of logical replication slots is very slow Jammie 03:45
Re: [POC] Fast COPY FROM command for the table with foreign partitions Andrey V. Lepikhov 03:45
RE: Disable WAL logging to speed up data loading [email protected] 03:51
Re: logical replication worker accesses catalogs in error context callback 📎 Masahiko Sawada 04:09
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey V. Lepikhov 04:13
Re: pg_upgrade test for binary compatibility of core data types 📎 Justin Pryzby 04:13
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION japin 04:27
RE: Add Nullif case for eval_const_expressions_mutator 📎 Hou, Zhijie 04:58
Re: Deleting older versions in unique indexes to avoid page splits 📎 Peter Geoghegan 05:26
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Amit Kapila 05:39
Re: libpq compression Konstantin Knizhnik 05:44
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION japin 05:47
"has_column_privilege()" issue with attnums and non-existent columns 📎 Ian Lawrence Barwick 05:53
Re: O(n^2) system calls in RemoveOldXlogFiles() Andres Freund 05:55
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 06:09
Re: O(n^2) system calls in RemoveOldXlogFiles() Thomas Munro 06:15
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Amit Kapila 06:38
RE: Add Nullif case for eval_const_expressions_mutator 📎 Hou, Zhijie 06:43
Fix a typo in SearchCatCache function comment 📎 Bharath Rupireddy 06:47
RE: Disable WAL logging to speed up data loading 📎 [email protected] 07:09
Re: Reduce the number of special cases to build contrib modules on windows Michael Paquier 07:18
Re: Fix a typo in SearchCatCache function comment Michael Paquier 07:21
RE: Disable WAL logging to speed up data loading [email protected] 07:22
Re: O(n^2) system calls in RemoveOldXlogFiles() Michael Paquier 07:27
Re: New Table Access Methods for Multi and Single Inserts Luc Vlaming 08:03
Re: adding partitioned tables to publications Amit Kapila 08:11
Re: [Bug Fix] Logical replication on partition table is very slow and CPU is 99% Amit Kapila 08:13
Re: Parallel Inserts in CREATE TABLE AS Luc Vlaming 08:30
Re: Spurious "apparent wraparound" via SimpleLruTruncate() rounding Noah Misch 08:49
Re: logical replication worker accesses catalogs in error context callback 📎 Bharath Rupireddy 09:33
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION japin 09:47
Re: Track replica origin progress for Rollback Prepared Ajin Cherian 09:48
Re: In-placre persistance change of a relation 📎 Kyotaro Horiguchi 09:58
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 10:03
Re: O(n^2) system calls in RemoveOldXlogFiles() Thomas Munro 10:30
Fix a typo in xlogreader.c 📎 Masahiko Sawada 10:43
Re: list of extended statistics on psql Tomas Vondra 11:08
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION 📎 Li Japin 11:17
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 11:29
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 11:32
Re: Is it useful to record whether plans are generic or custom? 📎 torikoshia 11:36
Re: Added schema level support for publication. Rahila Syed 11:46
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION japin 11:53
Re: Single transaction in the tablesync worker? 📎 Peter Smith 11:53
Re: Single transaction in the tablesync worker? Peter Smith 12:13
Re: Get memory contexts of an arbitrary backend process 📎 torikoshia 12:21
Executing inet_server_addr/port() in parallel workers 📎 Masahiko Sawada 12:33

Browse Archives

Prev | Next