pgsql-hackers since 2019-06-15 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

June 15, 2019

Thread Author Time
Re: Custom table AMs need to include heapam.h because of BulkInsertState 📎 David Rowley 00:25
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Joe Conway 01:37
Extracting only the columns needed for a query Melanie Plageman 01:45
Re: Speed up transaction completion faster after many relations are accessed in a transaction 📎 David Rowley 03:28
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock 📎 Alvaro Herrera 03:43
Re: Extracting only the columns needed for a query David Rowley 04:58
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Amit Kapila 05:45
Re: Improve handling of pg_stat_statements handling of bind "IN" variables Pavel Trukhanov 13:06
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Bruce Momjian 14:33
Fix typos and inconsistencies for v11+ 📎 Alexander Lakhin 15:00
assertion at postmaster start Alvaro Herrera 16:09
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Tom Lane 16:25
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 17:01
Re: Extracting only the columns needed for a query Tom Lane 17:01
Re: Dead encoding conversion functions Noah Misch 18:07
Re: pg_upgrade can result in early wraparound on databases with high transaction load Noah Misch 18:37
Re: Do we expect tests to work with default_transaction_isolation=serializable Noah Misch 18:47
Re: Draft back-branch release notes are up for review Noah Misch 20:39
Re: Draft back-branch release notes are up for review Peter Geoghegan 21:11
Re: Draft back-branch release notes are up for review Peter Geoghegan 21:35
Re: Draft back-branch release notes are up for review Noah Misch 21:42
Re: Draft back-branch release notes are up for review Tom Lane 22:05
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Oleksii Kliukin 22:12
Re: Draft back-branch release notes are up for review Peter Geoghegan 22:12
Re: Draft back-branch release notes are up for review Noah Misch 22:14
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 22:47
Re: CREATE STATISTICS documentation bug Tomas Vondra 23:22
Re: Multivariate MCV stats can leak data to unprivileged users Tomas Vondra 23:24

June 16, 2019

Thread Author Time
Re: Improve handling of pg_stat_statements handling of bind "IN" variables Greg Stark 00:30
Re: Improve handling of pg_stat_statements handling of bind "IN" variables Greg Stark 00:34
The flinfo->fn_extra question, from me this time. Chapman Flack 01:04
Re: The flinfo->fn_extra question, from me this time. Tom Lane 01:21
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Bruce Momjian 01:28
Re: The flinfo->fn_extra question, from me this time. Chapman Flack 01:46
PG 12 beta 1 segfault during analyze Steve Singer 02:05
Re: PG 12 beta 1 segfault during analyze Tom Lane 02:18
Re: Performance issue in foreign-key-aware join estimation 📎 David Rowley 07:42
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Joe Conway 11:07
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Bruce Momjian 13:45
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Bruce Momjian 13:46
Re: Index Skip Scan Dmitry Dolgov 15:03
Re: Extracting only the columns needed for a query Corey Huinker 15:47
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Joe Conway 16:42
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Joe Conway 16:45
$host_cpu -> $target_cpu in configure? Tom Lane 16:56
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 17:16
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Tom Lane 17:21
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 17:43
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Magnus Hagander 17:58
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Stephen Frost 18:10
Re: Extracting only the columns needed for a query Ashwin Agrawal 18:26
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Bruce Momjian 18:48
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 19:04
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Stephen Frost 19:57
Re: $host_cpu -> $target_cpu in configure? Noah Misch 20:33
Re: $host_cpu -> $target_cpu in configure? Tom Lane 20:36
Re: Quitting the thes Peter Eisentraut 20:51
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Tomas Vondra 21:54
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Gavin Flower 22:56
Re: range_agg 📎 Paul A Jungwirth 22:59

June 17, 2019

Thread Author Time
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Tom Lane 00:02
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 00:40
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Tom Lane 01:10
nbtdesc.c and nbtpage.c are inconsistent with XLOG_BTREE_META_CLEANUP (11~) 📎 Michael Paquier 01:30
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Michael Paquier 01:32
Re: nbtdesc.c and nbtpage.c are inconsistent with XLOG_BTREE_META_CLEANUP (11~) Peter Geoghegan 01:54
Re: nbtdesc.c and nbtpage.c are inconsistent with XLOG_BTREE_META_CLEANUP (11~) Michael Paquier 02:05
Re: nbtdesc.c and nbtpage.c are inconsistent with XLOG_BTREE_META_CLEANUP (11~) Peter Geoghegan 02:14
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 02:25
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Tom Lane 02:27
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Michael Paquier 02:44
RE: Speed up transaction completion faster after many relations are accessed in a transaction Tsunakawa, Takayuki 03:04
Re: Problem with default partition pruning Shawn Wang 03:28
Re: proposal: new polymorphic types - commontype and commontypearray 📎 Pavel Stehule 03:31
Re: SQL:2011 PERIODS vs Postgres Ranges? 📎 Paul A Jungwirth 04:54
Race conditions with TAP test for syncrep 📎 Michael Paquier 05:51
Re: Fix typos and inconsistencies for v11+ Michael Paquier 07:16
Re: Do we expect tests to work with default_transaction_isolation=serializable Michael Paquier 07:19
Re: Fix typos and inconsistencies for v11+ Alexander Lakhin 07:32
Still some references to configure-time WAL segment size option in msvc scripts 📎 Michael Paquier 07:32
RE: [PATCH] Speedup truncates of relation forks 📎 Jamison, Kirk 08:01
Strange error message in xlog.c 📎 Kyotaro Horiguchi 08:31
Re: SQL/JSON path issues/questions 📎 Alexander Korotkov 08:36
Re: "WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3 Antonin Houska 09:23
Fix up grouping sets reorder 📎 Richard Guo 09:23
Re: Generating partitioning tuple conversion maps faster didier 10:03
Re: POC: Cleaning up orphaned files using undo logs Amit Kapila 10:03
Re: SQL/JSON path issues/questions 📎 Liudmila Mantrova 10:07
Re: Obsolete comments about semaphores in proc.c Daniel Gustafsson 11:28
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Christoph Berg 11:46
Re: CREATE STATISTICS documentation bug Robert Haas 12:01
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Stephen Frost 12:12
pg_log_fatal vs pg_log_error Antonin Houska 12:19
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Joe Conway 12:29
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Masahiko Sawada 12:29
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Joe Conway 12:39
Re: pg_log_fatal vs pg_log_error Michael Paquier 12:43
Re: Batch insert in CTAS/MatView code 📎 Paul Guo 12:53
Re: Obsolete comments about semaphores in proc.c Michael Paquier 13:20
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Antonin Houska 13:25
Re: pg_log_fatal vs pg_log_error Antonin Houska 13:39
Re: pg_log_fatal vs pg_log_error Michael Paquier 13:44
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Antonin Houska 13:56
Re: POC: Cleaning up orphaned files using undo logs Robert Haas 13:59
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Tomas Vondra 14:02
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Tomas Vondra 14:26
Re: Binary support for pgoutput plugin 📎 Dave Cramer 14:29
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Stephen Frost 14:33
Re: pg_log_fatal vs pg_log_error Peter Eisentraut 14:34
Allow an alias to be attached directly to a JOIN ... USING 📎 Peter Eisentraut 14:40
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Juan José Santamaría Flecha 14:42
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Ian Barwick 14:50
Re: Race conditions with TAP test for syncrep Alvaro Herrera 14:50
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Ian Barwick 14:51
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Tomas Vondra 14:52
how to run encoding-dependent tests by default Peter Eisentraut 14:56
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 15:05
Re: how to run encoding-dependent tests by default Tom Lane 15:32
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 15:41
Re: how to run encoding-dependent tests by default Andrew Dunstan 16:36
Re: how to run encoding-dependent tests by default Andres Freund 16:39
Re: initial random incompatibility Darafei Komяpa Praliaskouski 16:55
Re: initial random incompatibility Alvaro Herrera 17:09
Re: assertion at postmaster start Andres Freund 17:28
Re: Fix up grouping sets reorder Andres Freund 17:33
Re: initial random incompatibility Tom Lane 17:35
Re: assertion at postmaster start Tom Lane 17:38
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Andres Freund 17:39
Re: SQL/JSON path issues/questions Thom Brown 17:39
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Stephen Frost 18:34
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Andres Freund 18:38
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Stephen Frost 18:40
Re: Fix up grouping sets reorder Andrew Gierth 18:47
Re: SQL/JSON path issues/questions Alexander Korotkov 20:13
Re: idea: log_statement_sample_rate - bottom limit for sampling 📎 Pavel Stehule 20:40
Re: SQL/JSON path issues/questions Chapman Flack 20:57
psql UPDATE field [tab] expands to DEFAULT? Ken Tanzer 22:03
Re: psql UPDATE field [tab] expands to DEFAULT? Adrian Klaver 23:24
Re: psql UPDATE field [tab] expands to DEFAULT? Ken Tanzer 23:33

June 18, 2019

Thread Author Time
Re: psql UPDATE field [tab] expands to DEFAULT? Tim Cross 00:09
Re: psql UPDATE field [tab] expands to DEFAULT? Adrian Klaver 00:22
Re: psql UPDATE field [tab] expands to DEFAULT? Jeff Janes 00:23
Re: psql UPDATE field [tab] expands to DEFAULT? Jeff Janes 00:34
Re: psql UPDATE field [tab] expands to DEFAULT? Tom Lane 00:39
Re: psql UPDATE field [tab] expands to DEFAULT? Tim Cross 00:52
Re: Fix typos and inconsistencies for v11+ Michael Paquier 00:52
Re: Race conditions with TAP test for syncrep Michael Paquier 00:59
Re: PG 12 beta 1 segfault during analyze 📎 Steve Singer 01:46
Re: idea: log_statement_sample_rate - bottom limit for sampling 📎 Pavel Stehule 03:30
Re: PG 12 beta 1 segfault during analyze Tom Lane 04:32
Re: Hash join explain is broken 📎 Andres Freund 07:00
Re: PG 12 beta 1 segfault during analyze Andres Freund 07:23
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) shawn wang 08:07
Re: Generating partitioning tuple conversion maps faster Michael Paquier 08:11
Re: pg_upgrade: Improve invalid option handling Michael Paquier 08:15
Re: pg_upgrade: Improve invalid option handling Daniel Gustafsson 08:25
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Magnus Hagander 09:07
BUG #15858: could not stat file - over 4GB PG Bug reporting form 10:02
Re: Batch insert in CTAS/MatView code 📎 Paul Guo 10:06
Re: POC: Cleaning up orphaned files using undo logs 📎 Amit Kapila 11:30
Re: PG 12 beta 1 segfault during analyze Steve Singer 11:57
Re: idea: log_statement_sample_rate - bottom limit for sampling 📎 Adrien Nayrat 12:03
Replacing the EDH SKIP primes 📎 Daniel Gustafsson 12:05
fix "Success" error messages 📎 Peter Eisentraut 12:35
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Stephen Frost 13:37
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Magnus Hagander 14:32
Re: PG 12 beta 1 segfault during analyze Tom Lane 14:35
Re: Avoiding possible future conformance headaches in JSON work Alvaro Herrera 15:49
Re: fix "Success" error messages Shawn Debnath 16:13
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 16:26
Re: Avoiding possible future conformance headaches in JSON work Oleg Bartunov 16:51
Re: Avoiding possible future conformance headaches in JSON work Chapman Flack 17:26
Re: POC: Cleaning up orphaned files using undo logs Robert Haas 18:07
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Oleksii Kliukin 18:13
Re: idea: log_statement_sample_rate - bottom limit for sampling Pavel Stehule 18:29
Re: Valgrind failures in Apply Launcher's bgworker_quickdie() exit Andres Freund 19:18
Re: NOT IN subquery optimization 📎 Li, Zheng 20:22
Re: initdb recommendations 📎 Peter Eisentraut 20:33
Choosing values for multivariate MCV lists 📎 Tomas Vondra 20:59
Re: New EXPLAIN option: ALL Peter Eisentraut 21:08
Re: POC: Cleaning up orphaned files using undo logs Robert Haas 21:10
Re: New EXPLAIN option: ALL David Fetter 21:15
Multivariate MCV list vs. statistics target Tomas Vondra 21:33
O(N^2) when building multi-column MCV lists Tomas Vondra 21:43
PL/Python fails on new NetBSD/PPC 8.0 install Tom Lane 22:16
Re: psql UPDATE field [tab] expands to DEFAULT? Ken Tanzer 22:23
Re: Avoiding hash join batch explosions with extreme skew and weird stats 📎 Melanie Plageman 22:24
Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Alvaro Herrera 22:25
Re: PG 12 beta 1 segfault during analyze Andres Freund 23:02
Re: openssl valgrind failures on skink are due to openssl issue Andres Freund 23:08
ANALYZE: ERROR: tuple already updated by self Justin Pryzby 23:12
Re: openssl valgrind failures on skink are due to openssl issue Tom Lane 23:25
Re: ANALYZE: ERROR: tuple already updated by self Andres Freund 23:30
Re: openssl valgrind failures on skink are due to openssl issue Andres Freund 23:34
Re: ANALYZE: ERROR: tuple already updated by self Justin Pryzby 23:48
Re: ANALYZE: ERROR: tuple already updated by self Justin Pryzby 23:57

June 19, 2019

Thread Author Time
Re: ANALYZE: ERROR: tuple already updated by self Peter Geoghegan 00:00
Re: ANALYZE: ERROR: tuple already updated by self Andres Freund 00:08
Re: ANALYZE: ERROR: tuple already updated by self Andres Freund 00:09
Re: ANALYZE: ERROR: tuple already updated by self Tom Lane 00:16

Browse Archives

Prev | Next