pgsql-hackers since 2021-02-21 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

Feb. 21, 2021

Thread Author Time
Re: Some regular-expression performance hacking Tom Lane 01:13
Re: [PATCH] Present all committed transaction to the output plugin Andres Freund 02:04
Re: TRIM_ARRAY 📎 Vik Fearing 02:09
Mysterious ::text::char cast: ascii(chr(32)::char) = 0 Joel Jacobson 05:46
Use pgstat_progress_update_multi_param instead of single param update 📎 Bharath Rupireddy 06:00
Re: repeated decoding of prepared transactions Amit Kapila 06:02
Re: Mysterious ::text::char cast: ascii(chr(32)::char) = 0 Tom Lane 06:10
Re: Bizarre behavior of \w in a regular expression bracket construct 📎 Joel Jacobson 07:13
Re: Freeze the inserted tuples during CTAS? 📎 Paul Guo 07:45
Re: [PATCH] Present all committed transaction to the output plugin 📎 Markus Wanner 10:05
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 Andy Fan 10:11
Re: Use pgstat_progress_update_multi_param instead of single param update Michael Paquier 10:47
Re: Use pgstat_progress_update_multi_param instead of single param update Bharath Rupireddy 11:13
Re: [HACKERS] Custom compression methods Dilip Kumar 12:03
GROUP BY DISTINCT 📎 Vik Fearing 12:52
Re: Extend more usecase for planning time partition pruning and init partition pruning. 📎 Andy Fan 13:33
Re: GROUP BY DISTINCT er 14:06
Re: GROUP BY DISTINCT 📎 Vik Fearing 14:14
Re: Fallback table AM for relkinds without storage Justin Pryzby 15:43
Re: Bizarre behavior of \w in a regular expression bracket construct Alvaro Herrera 16:06
Re: Bizarre behavior of \w in a regular expression bracket construct Tom Lane 17:39
Is a connection max lifetime useful in a connection pool? Daniele Varrazzo 18:05
Re: Is a connection max lifetime useful in a connection pool? Pavel Stehule 18:11
Re: Is a connection max lifetime useful in a connection pool? Stephen Frost 18:26
Re: Bizarre behavior of \w in a regular expression bracket construct Joel Jacobson 18:27
Re: How to customize postgres for sharing read-only tables in multiple data-dirs between servers Justin Pryzby 18:39
Re: Is a connection max lifetime useful in a connection pool? Daniele Varrazzo 18:39
Re: Improvements and additions to COPY progress reporting 📎 Matthias van de Meent 19:10
Re: [PATCH] Present all committed transaction to the output plugin Tomas Vondra 21:56
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Justin Pryzby 22:23
Re: repeated decoding of prepared transactions Andres Freund 22:26
Re: Extensions not dumped when --schema is used David Fetter 23:15
Catalog version access 📎 Vik Fearing 23:15
Re: Finding cause of test fails on the cfbot site Thomas Munro 23:19
Re: Catalog version access Andres Freund 23:48
Re: Is a connection max lifetime useful in a connection pool? Andres Freund 23:52
Re: Catalog version access Vik Fearing 23:55
Re: Is a connection max lifetime useful in a connection pool? Julien Rouhaud 23:57

Feb. 22, 2021

Thread Author Time
Re: Catalog version access Euler Taveira 00:27
Re: Catalog version access Tom Lane 00:54
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Justin Pryzby 01:21
Re: Catalog version access Andres Freund 01:34
Re: Catalog version access Tom Lane 01:53
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 01:59
Re: Catalog version access Andres Freund 02:24
Re: Finding cause of test fails on the cfbot site Thomas Munro 02:28
Re: repeated decoding of prepared transactions Amit Kapila 02:52
Re: should INSERT SELECT use a BulkInsertState? 📎 Justin Pryzby 03:01
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 03:11
Re: Parallel INSERT (INTO ... SELECT ...) Amit Langote 03:16
RE: Determine parallel-safety of partition relations for Inserts 📎 [email protected] 03:27
Re: Finding cause of test fails on the cfbot site Andres Freund 03:34
Re: repeated decoding of prepared transactions Andres Freund 04:09
Re: repeated decoding of prepared transactions Andres Freund 04:22
RE: libpq debug log [email protected] 04:30
Re: Improvements and additions to COPY progress reporting Bharath Rupireddy 04:49
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself.. 📎 Justin Pryzby 05:05
Re: Use pgstat_progress_update_multi_param instead of single param update Michael Paquier 05:22
Re: pg_collation_actual_version() ERROR: cache lookup failed for collation 123 📎 Thomas Munro 05:34
Re: libpq compression Craig Ringer 05:38
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 05:55
Re: a misbehavior of partition row movement (?) Amit Langote 06:04
Re: New IndexAM API controlling index vacuum strategies 📎 Masahiko Sawada 06:27
Re: Catalog version access Vik Fearing 07:00
[PATCH] Feature improvement for TRUNCATE tab completion. 📎 miyake_kouta 07:04
Re: Improve new hash partition bound check error messages Peter Eisentraut 07:09
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 07:25
Re: pg_collation_actual_version() ERROR: cache lookup failed for collation 123 Michael Paquier 07:27
Table AM and DDLs 📎 Mats Kindahl 07:33
Re: Fallback table AM for relkinds without storage Michael Paquier 07:37
Re: doc review for v14 📎 Justin Pryzby 08:03
RE: libpq debug log 📎 [email protected] 08:22
Re: repeated decoding of prepared transactions Markus Wanner 08:25
Re: repeated decoding of prepared transactions Markus Wanner 08:25
RE: libpq debug log [email protected] 08:36
do coverage test without install lcov 📎 [email protected] 08:41
Re: SEARCH and CYCLE clauses 📎 Peter Eisentraut 08:44
Re: repeated decoding of prepared transactions Amit Kapila 08:59
Re: repeated decoding of prepared transactions Andres Freund 09:25
Re: repeated decoding of prepared transactions Andres Freund 09:27
Re: adding wait_start column to pg_locks Fujii Masao 09:27
Re: computing dT from an interval Michael J. Baars 09:30
Re: repeated decoding of prepared transactions Amit Kapila 09:41
Re: SEARCH and CYCLE clauses 📎 Vik Fearing 10:05
Re: row filtering for logical replication Önder Kalacı 10:45
Re: Disallow SSL compression? Magnus Hagander 10:52
Re: Disallow SSL compression? Daniel Gustafsson 11:27
pgsql: pg_collation_actual_version() -> pg_collation_current_version(). Thomas Munro 11:28
Re: pg_collation_actual_version() ERROR: cache lookup failed for collation 123 Thomas Munro 11:30
Re: 64-bit XIDs in deleted nbtree pages Masahiko Sawada 12:20
Re: row filtering for logical replication Euler Taveira 12:28
Re: SEARCH and CYCLE clauses Peter Eisentraut 12:28
Re: Extensibility of the PostgreSQL wire protocol Dave Cramer 12:34
Re: [PATCH] pg_hba.conf error messages for logical replication connections Euler Taveira 12:38
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 12:40
Re: Support for NSS as a libpq TLS backend 📎 Daniel Gustafsson 13:31
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 13:31
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 13:33
Re: SEARCH and CYCLE clauses Vik Fearing 13:45
Re: Finding cause of test fails on the cfbot site Andrew Dunstan 14:17
Re: Finding cause of test fails on the cfbot site Andrew Dunstan 14:46
Re: Extensibility of the PostgreSQL wire protocol Jan Wieck 14:55
Re: Extensibility of the PostgreSQL wire protocol 📎 Jan Wieck 15:01
Re: do coverage test without install lcov Tom Lane 15:45
Re: computing dT from an interval Tom Lane 15:52
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Álvaro Herrera 15:56
Re: computing dT from an interval David Fetter 16:11
Re: Extensibility of the PostgreSQL wire protocol David Fetter 16:19
Parser Hook 📎 Jim Mlodgenski 16:20
Re: computing dT from an interval Tom Lane 16:29
Re: [PATCH] Feature improvement for TRUNCATE tab completion. Muhammad Usama 16:44
Re: Extensibility of the PostgreSQL wire protocol Jan Wieck 16:44
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself.. 📎 Justin Pryzby 17:15
pg_attribute.attname inconsistency when renaming primary key columns Joel Jacobson 17:21
Re: [HACKERS] logical decoding of two-phase transactions Markus Wanner 17:34
Re: Allow matching whole DN from a client certificate Jacob Champion 18:00
Re: Extensibility of the PostgreSQL wire protocol Tom Lane 18:01
Re: Extensibility of the PostgreSQL wire protocol Jonah H. Harris 18:13
Re: Extensibility of the PostgreSQL wire protocol Jan Wieck 19:00
Re: libpq compression Robert Haas 19:48
Re: some pointless HeapTupleHeaderIndicatesMovedPartitions calls Álvaro Herrera 20:15
Re: WIP: BRIN multi-range indexes John Naylor 20:16
Re: libpq compression Andres Freund 20:40
Re: pg_attribute.attname inconsistency when renaming primary key columns Joel Jacobson 20:42
Re: libpq compression Tom Lane 20:44
Re: Parser Hook Andres Freund 20:52
Re: libpq compression Andres Freund 21:21
Re: libpq compression Daniel Gustafsson 21:29
locking [user] catalog tables vs 2pc vs logical rep Andres Freund 22:28
Re: Autovacuum worker doesn't immediately exit on postmaster death Thomas Munro 22:32
Re: 64-bit XIDs in deleted nbtree pages Peter Geoghegan 22:54

Feb. 23, 2021

Thread Author Time
Re: POC: Better infrastructure for automated testing of concurrency issues Peter Geoghegan 00:08
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Álvaro Herrera 00:15
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 01:07
Re: Table AM and DDLs Andres Freund 01:11
Re: Fallback table AM for relkinds without storage Andres Freund 01:19
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andy Fan 01:21
Re: 64-bit XIDs in deleted nbtree pages Masahiko Sawada 01:23
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andres Freund 01:39
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Tom Lane 01:51
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andres Freund 02:01
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 02:13
Re: locking [user] catalog tables vs 2pc vs logical rep Amit Kapila 03:26
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 03:30
Re: locking [user] catalog tables vs 2pc vs logical rep Andres Freund 03:39
Tuples unbalance distribution among workers in underlying parallel select with serial insert 📎 [email protected] 03:43
Re: locking [user] catalog tables vs 2pc vs logical rep Amit Kapila 03:54
Re: locking [user] catalog tables vs 2pc vs logical rep Andres Freund 04:03
pg_temp_%d namespace creation can invalidate all the cached plan in other backends Andy Fan 04:07
Re: pg_temp_%d namespace creation can invalidate all the cached plan in other backends Andy Fan 04:14
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Tom Lane 05:43
Re: pg_temp_%d namespace creation can invalidate all the cached plan in other backends Tom Lane 05:50
Re: pgsql: pg_collation_actual_version() -> pg_collation_current_version(). Peter Eisentraut 06:03
RE: A reloption for partitioned tables - parallel_workers [email protected] 06:12
Re: [Doc Patch] Clarify that CREATEROLE roles can GRANT default roles Robert Treat 06:18
Re: locking [user] catalog tables vs 2pc vs logical rep 📎 Amit Kapila 06:30
Re: Is Recovery actually paused? 📎 Dilip Kumar 06:33
Re: pgsql: pg_collation_actual_version() -> pg_collation_current_version(). Thomas Munro 07:23
Re: pg_temp_%d namespace creation can invalidate all the cached plan in other backends Andy Fan 08:04
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 08:05
Re: [PATCH] pg_hba.conf error messages for logical replication connections Amit Kapila 08:06
Re: computing dT from an interval Michael J. Baars 08:23
Re: Improvements and additions to COPY progress reporting 📎 Matthias van de Meent 09:27
Re: A reloption for partitioned tables - parallel_workers Amit Langote 09:32
Re: repeated decoding of prepared transactions Ajin Cherian 09:36
Re: repeated decoding of prepared transactions Amit Kapila 09:53
Asynchronous and "direct" IO support for PostgreSQL. Andres Freund 10:03
RE: A reloption for partitioned tables - parallel_workers [email protected] 10:24
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements Masahiko Sawada 11:03
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 11:17
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 11:53
INSERT ... ON CONFLICT ... : expose INSERT vs UPDATE status George MacKerron 11:56
Re: libpq compression Konstantin Knizhnik 12:17
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements Álvaro Herrera 15:26
Re: [PATCH]: Allow errors in parameter values to be reported during the BIND phase itself.. 📎 Justin Pryzby 16:03
Re: pg_upgrade version checking questions 📎 Daniel Gustafsson 16:14
Re: libpq compression Konstantin Knizhnik 16:29
Re: Bizarre behavior of \w in a regular expression bracket construct 📎 Tom Lane 17:15
Re: Some regular-expression performance hacking Andres Freund 17:34
Re: new heapcheck contrib module Mark Dilger 17:38
Re: Some regular-expression performance hacking Tom Lane 17:39
Re: Some regular-expression performance hacking Tom Lane 17:52
Re: Some regular-expression performance hacking Andres Freund 18:05
Re: Some regular-expression performance hacking Tom Lane 18:09
Re: Some regular-expression performance hacking Andres Freund 18:18
Re: Some regular-expression performance hacking Tom Lane 18:22
Re: Some regular-expression performance hacking Tom Lane 18:36
Re: Asynchronous and "direct" IO support for PostgreSQL. Greg Stark 19:58
Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination Alvaro Herrera 20:47
[BUG] segfault during delete 📎 Drouvot, Bertrand 20:56
Re: Asynchronous and "direct" IO support for PostgreSQL. Andres Freund 21:05
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 21:52
Re: partial heap only tuples Bossart, Nathan 22:22
Re: Fix typo about generate_gather_paths Alvaro Herrera 23:12

Feb. 24, 2021

Thread Author Time
Re: Support for NSS as a libpq TLS backend Jacob Champion 00:11
Re: libpq debug log 📎 [email protected] 01:40
Refactor ECPGconnect and allow IPv6 connection 📎 [email protected] 01:42
Re: [PoC] Non-volatile WAL buffer 📎 Takashi Menjo 02:03
RE: libpq debug log [email protected] 02:25
Re: some pointless HeapTupleHeaderIndicatesMovedPartitions calls Michael Paquier 02:27

Browse Archives

Prev | Next