pgsql-hackers since 2020-10-15 17:21

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

Oct. 15, 2020

Thread Author Time
psql \df choose functions by their arguments 📎 Greg Sabino Mullane 17:21
Re: AppendStringInfoChar instead of appendStringInfoString Alvaro Herrera 17:36
plan cache doesn't clean plans with references to dropped procedures Pavel Stehule 17:54
Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers Justin Pryzby 17:57
Re: speed up unicode decomposition and recomposition 📎 John Naylor 17:59
Re: plan cache doesn't clean plans with references to dropped procedures Tom Lane 18:17
Re: plan cache doesn't clean plans with references to dropped procedures Pavel Stehule 18:51
Re: improve the algorithm cached_plan_cost with real planning time? Andy Fan 19:18
Re: Partition prune with stable Expr Andy Fan 19:36
Re: [Patch] Using Windows groups for SSPI authentication Russell Foster 19:56
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Andres Freund 20:30
Re: kevent latch paths don't handle postmaster death well Thomas Munro 21:32
Re: kevent latch paths don't handle postmaster death well Tom Lane 21:40
Re: stress test for parallel workers Thomas Munro 22:11
Re: Use list_delete_xxxcell O(1) instead of list_delete_ptr O(N) in some places 📎 David Rowley 22:24
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 22:29
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 22:37
Re: jit and explain nontext Andres Freund 23:00
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Bruce Momjian 23:35
Re: Wrong example in the bloom documentation Bruce Momjian 23:50
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Thomas Munro 23:54

Oct. 16, 2020

Thread Author Time
Re: Some remaining htonl() and ntohl() calls in the code Michael Paquier 00:01
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 00:12
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Andres Freund 00:19
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Bruce Momjian 00:37
Re: Online checksums verification in the backend 📎 Julien Rouhaud 00:59
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Michael Paquier 01:00
Re: Is the doc for SHOW somewhat stale? 📎 Kyotaro Horiguchi 01:00
upcoming API changes for LLVM 12 Andres Freund 01:12
Re: Online checksums verification in the backend 📎 Julien Rouhaud 01:22
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Craig Ringer 02:19
Re: upcoming API changes for LLVM 12 Thomas Munro 02:37
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 02:49
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 03:27
Re: speed up unicode decomposition and recomposition Michael Paquier 03:32
RE: Use list_delete_xxxcell O(1) instead of list_delete_ptr O(N) in some places 📎 Hou, Zhijie 03:42
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Amit Kapila 04:44
Re: upcoming API changes for LLVM 12 Alvaro Herrera 05:45
Re: Parallel Inserts in CREATE TABLE AS Luc Vlaming 06:03
Re: [HACKERS] logical decoding of two-phase transactions 📎 Peter Smith 06:20
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 06:23
Sending logical replication data only after synchronous replication happened Andrey Borodin 07:21
Enumize logical replication message actions 📎 Ashutosh Bapat 07:25
Re: Parallel Inserts in CREATE TABLE AS Luc Vlaming 07:33
Re: upcoming API changes for LLVM 12 Andres Freund 07:38
[PATCH] Add extra statistics to explain for Nested Loop 📎 e.sokolova 07:42
Re: Enumize logical replication message actions Li Japin 08:08
Re: shared-memory based stats collector Kyotaro Horiguchi 08:08
Re: [PATCH] Add extra statistics to explain for Nested Loop Pavel Stehule 08:11
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 [email protected] 08:21
Re: Enumize logical replication message actions Kyotaro Horiguchi 08:36
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 08:45
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Kyotaro Horiguchi 09:00
Possible typo in nodeAgg.c 📎 Hou, Zhijie 09:03
Re: [PATCH] Add extra statistics to explain for Nested Loop Julien Rouhaud 09:07
Re: gs_group_1 crashing on 13beta2/s390x Christoph Berg 09:19
Re: Enumize logical replication message actions Ashutosh Bapat 09:33
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 [email protected] 09:39
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 10:26
Re: Implementing Incremental View Maintenance Yugo NAGATA 10:30
Re: Feature improvement for pg_stat_statements Yuki Seino 10:47
Re: New statistics for tuning WAL buffer size 📎 Masahiro Ikeda 10:58
Re: Enumize logical replication message actions Amit Kapila 11:13
Re: Add session statistics to pg_stat_database Ahsan Hadi 11:24
Re: Feature improvement for pg_stat_statements Kyotaro Horiguchi 12:33
Potential use of uninitialized context in pgcrypto 📎 Daniel Gustafsson 12:43
Re: partition routing layering in nodeModifyTable.c 📎 Amit Langote 13:12
Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers 📎 Alvaro Herrera 13:52
Re: Improper use about DatumGetInt32 Alvaro Herrera 13:56
Re: upcoming API changes for LLVM 12 Tom Lane 14:22
Re: partition routing layering in nodeModifyTable.c Alvaro Herrera 14:45
Re: [patch] Fix checksum verification in base backups for zero page headers 📎 Anastasia Lubennikova 15:02
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Bruce Momjian 15:04
Re: Potential use of uninitialized context in pgcrypto Tom Lane 15:47
Re: Sometimes the output to the stdout in Windows disappears 📎 Alexander Lakhin 16:00
Re: [Patch] Using Windows groups for SSPI authentication Stephen Frost 16:00
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Alvaro Herrera 16:03
Re: Sometimes the output to the stdout in Windows disappears Tom Lane 16:18
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Tom Lane 16:23
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Bruce Momjian 16:47
Re: allow online change primary_conninfo 📎 Maxim Orlov 16:50
Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers 📎 Alvaro Herrera 16:59
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 17:00
Re: Commitfest manager 2020-11 Anastasia Lubennikova 18:04
Re: speed up unicode decomposition and recomposition Daniel Verite 18:08
Re: Commitfest manager 2020-11 Tom Lane 18:57
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 19:12
Re: More aggressive vacuuming of temporary tables Peter Geoghegan 19:32
Re: Deleting older versions in unique indexes to avoid page splits Victor Yegorov 19:59
Re: allow online change primary_conninfo Sergei Kornilov 20:01
Re: Commitfest manager 2020-11 Anastasia Lubennikova 20:21
Re: Internal key management system 📎 Bruce Momjian 20:24
Re: upcoming API changes for LLVM 12 Andres Freund 20:53
Re: Internal key management system Tom Lane 20:56
Re: Deleting older versions in unique indexes to avoid page splits 📎 Peter Geoghegan 20:58
Re: upcoming API changes for LLVM 12 Tom Lane 21:04
Re: should INSERT SELECT use a BulkInsertState? 📎 Justin Pryzby 21:05
Re: [PATCH] Add extra statistics to explain for Nested Loop Anastasia Lubennikova 22:11
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎 Alvaro Herrera 22:13
Re: upcoming API changes for LLVM 12 Alvaro Herrera 22:28
Stats collector's idx_blks_hit value is highly misleading in practice Peter Geoghegan 22:35
Re: Internal key management system Bruce Momjian 22:51
Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers 📎 Alvaro Herrera 23:59

Oct. 17, 2020

Thread Author Time
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 03:28
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 03:31
Re: [PATCH] Add extra statistics to explain for Nested Loop Pavel Stehule 04:14
Re: [PATCH] Add extra statistics to explain for Nested Loop Julien Rouhaud 04:26
Re: [PATCH] Add extra statistics to explain for Nested Loop Pavel Stehule 04:28
Re: [HACKERS] Custom compression methods 📎 Dilip Kumar 06:04
warn_unused_results 📎 Peter Eisentraut 06:57
Re: partition routing layering in nodeModifyTable.c Amit Langote 07:44
Re: Sometimes the output to the stdout in Windows disappears 📎 Alexander Lakhin 08:00
Re: [PATCH] Add extra statistics to explain for Nested Loop hubert depesz lubaczewski 08:23
Timing of relcache inval at parallel worker init 📎 Noah Misch 11:53
[doc] improve tableoid description 📎 Ian Lawrence Barwick 13:04
Re: Wrong example in the bloom documentation Daniel Westermann (DWE) 13:50
Re: Sometimes the output to the stdout in Windows disappears Andrew Dunstan 13:54
Re: [PATCH] Add extra statistics to explain for Nested Loop David G. Johnston 15:11
Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity) Peter Geoghegan 15:39
Re: Sometimes the output to the stdout in Windows disappears Tom Lane 15:50
Re: partition routing layering in nodeModifyTable.c Alvaro Herrera 15:54
Re: warn_unused_results Tom Lane 15:58
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Alvaro Herrera 15:59
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Tom Lane 16:28
Re: Sometimes the output to the stdout in Windows disappears 📎 Tom Lane 18:44
Re: jit and explain nontext 📎 Justin Pryzby 19:21

Oct. 18, 2020

Thread Author Time
pg_restore error message during ENOSPC with largeobj 📎 Justin Pryzby 01:02
RE: Parallel copy Hou, Zhijie 02:17
Re: pg_restore error message during ENOSPC with largeobj Tom Lane 02:41
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Alvaro Herrera 03:01
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Tom Lane 04:20
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 08:12
Re: [PATCH] Add extra statistics to explain for Nested Loop Julien Rouhaud 11:37
Re: public schema default ACL Noah Misch 12:51
Re: pg_restore error message during ENOSPC with largeobj Tom Lane 16:27
Non-configure build of thread_test has been broken for awhile Tom Lane 17:20
Re: Sometimes the output to the stdout in Windows disappears Alexander Lakhin 18:00
Re: Sometimes the output to the stdout in Windows disappears Tom Lane 18:04
Re: Sometimes the output to the stdout in Windows disappears Tom Lane 18:24
Re: Sometimes the output to the stdout in Windows disappears Alexander Lakhin 18:30
Re: Sometimes the output to the stdout in Windows disappears Tom Lane 18:33
Re: Sometimes the output to the stdout in Windows disappears Tom Lane 18:38
Re: Assertion failure with LEFT JOINs among >500 relations David Rowley 21:01
Re: jit and explain nontext David Rowley 22:20
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 23:10
Re: Assertion failure with LEFT JOINs among >500 relations 📎 David Rowley 23:18
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 23:25
Re: Assertion failure with LEFT JOINs among >500 relations David Rowley 23:37

Oct. 19, 2020

Thread Author Time
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 00:06
Re: Assertion failure with LEFT JOINs among >500 relations David Rowley 00:18
RE: Resetting spilled txn statistics in pg_stat_replication 📎 Shinoda, Noriyoshi (PN Japan A&PS Delivery) 00:29
Re: Possible memory leak in pgcrypto with EVP_MD_CTX Michael Paquier 01:08
Re: Online checksums verification in the backend Michael Paquier 02:39
Re: Internal key management system Masahiko Sawada 03:15
Re: Online checksums verification in the backend Julien Rouhaud 03:16
Re: Implementing Incremental View Maintenance Tatsuo Ishii 03:24
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 03:34
RE: Use of "long" in incremental sort code 📎 Tang, Haiying 03:57
RE: [POC] Fast COPY FROM command for the table with foreign partitions [email protected] 04:12
[patch] ENUM errdetail should mention bytes, not chars 📎 Ian Lawrence Barwick 04:18
Re: [patch] ENUM errdetail should mention bytes, not chars Julien Rouhaud 04:34
Re: partition routing layering in nodeModifyTable.c 📎 Amit Langote 04:54
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 05:17
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 05:25
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers Amit Kapila 05:28
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 05:38
Re: speed up unicode normalization quick check Peter Eisentraut 06:15
Use PointerGetDatum(cstring_to_text_with_len()) instead of CStringGetTextDatum() to avoid duplicate strlen 📎 Hou, Zhijie 06:32
Re: speed up unicode normalization quick check Michael Paquier 06:57
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 07:22
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 07:50
Re: Online checksums verification in the backend Michael Paquier 07:52
Re: Reduce the time required for a database recovery from archive. Dmitry Shulga 07:58
Hash support for row types 📎 Peter Eisentraut 08:01
Re: Track statistics for streaming of in-progress transactions Ajin Cherian 08:20
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 09:07
Re: Parallel copy Amit Kapila 09:11
Make procedure OUT parameters work with JDBC 📎 Peter Eisentraut 09:19
Re: Assertion failure with LEFT JOINs among >500 relations David Rowley 11:09
Re: Make procedure OUT parameters work with JDBC Andrew Dunstan 11:15
Re: [doc] improve tableoid description Ashutosh Bapat 11:22
Assertion failure when ATTACH partition followed by CREATE PARTITION. Amul Sul 11:28
Re: Transactions involving multiple postgres foreign servers, take 2 Ashutosh Bapat 11:37
Re: partition routing layering in nodeModifyTable.c Heikki Linnakangas 11:48
Re: partition routing layering in nodeModifyTable.c Heikki Linnakangas 11:55
Re: Use PointerGetDatum(cstring_to_text_with_len()) instead of CStringGetTextDatum() to avoid duplicate strlen Heikki Linnakangas 12:07
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 12:20
Re: [doc] improve tableoid description 📎 Ian Lawrence Barwick 12:28
Re: Parallel copy 📎 vignesh C 12:35
Is Recovery actually paused? Dilip Kumar 14:10
Re: speed up unicode normalization quick check John Naylor 14:15
Re: [PATCH] Add extra statistics to explain for Nested Loop Pierre Giraud 14:17
Re: speed up unicode decomposition and recomposition John Naylor 14:34
Re: speed up unicode decomposition and recomposition John Naylor 14:36
Re: speed up unicode normalization quick check Tom Lane 14:38
parallel distinct union and aggregate support patch 📎 [email protected] 14:42
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey Lepikhov 14:58
Re: speed up unicode normalization quick check 📎 John Naylor 16:12
Re: Reduce the time required for a database recovery from archive. Stephen Frost 16:25
Re: Probable documentation errors or improvements Heikki Linnakangas 16:36

Browse Archives

Prev | Next