pgsql-hackers before 2018-07-03 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)
Advanced Search

Browse Archives

Prev | Next

June 29, 2018

Thread Author Time
Re: Monitoring time of fsyncing WALs Robert Haas 12:48
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 12:51
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Tomas Vondra 13:05
Re: POC: GROUP BY optimization Tomas Vondra 13:11
Re: Code of Conduct committee: call for volunteers Magnus Hagander 13:20
Re: Monitoring time of fsyncing WALs Konstantin Knizhnik 13:26
Re: assert in nested SQL procedure call in current HEAD Peter Eisentraut 13:35
Re: Monitoring time of fsyncing WALs Michael Paquier 13:39
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Peter Eisentraut 13:42
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Daniel Gustafsson 13:49
ERROR: cannot start subtransactions during a parallel operation Mai Peng 14:00
Re: Fix to not check included columns in ANALYZE on indexes Teodor Sigaev 14:31
Re: [HACKERS] [PATCH] kNN for SP-GiST 📎 Nikita Glukhov 14:36
Re: cost_sort() improvements Teodor Sigaev 14:36
Re: ERROR: cannot start subtransactions during a parallel operation Tomas Vondra 14:50
Re: POC: GROUP BY optimization Teodor Sigaev 14:51
Re: POC: GROUP BY optimization Tomas Vondra 15:03
pgsql: Fix crash when ALTER TABLE recreates indexes on partitions Alvaro Herrera 15:50
Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)" Alvaro Herrera 15:52
Re: Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) Alvaro Herrera 16:06
Re: Utilisation of get_page_from_raw() in pageinspect Jesper Pedersen 16:15
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Tom Lane 16:44
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Daniel Gustafsson 16:54
Re: pgsql: Fix "base" snapshot handling in logical decoding Alvaro Herrera 16:57
minor fix in CancelVirtualTransaction 📎 Alvaro Herrera 17:05
Re: Failed assertion due to procedure created with SECURITY DEFINER option Andres Freund 17:19
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Vik Fearing 17:19
Re: ERROR: cannot start subtransactions during a parallel operation Andres Freund 17:22
RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist Regina Obe 17:30
Re: Generating partitioning tuple conversion maps faster David Rowley 17:40
Re: Concurrency bug in UPDATE of partition-key Alvaro Herrera 17:52
Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist Tom Lane 18:02
Re: Explain buffers wrong counter with parallel plans Alvaro Herrera 18:22
Re: ERROR: cannot start subtransactions during a parallel operation Tomas Vondra 18:37
Re: ERROR: cannot start subtransactions during a parallel operation Andres Freund 18:47
RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist Regina Obe 18:49
Comment refers to non existent function IncreaseRestartDecodingForSlot Dave Cramer 18:55
Re: Comment refers to non existent function IncreaseRestartDecodingForSlot 📎 Euler Taveira 20:34
Re: SCRAM with channel binding downgrade attack Peter Eisentraut 20:42
TLS 1.3 and OpenSSL Peter Eisentraut 20:47
Re: POC: GROUP BY optimization Gavin Flower 21:19
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Alvaro Herrera 21:27
Re: Tips on committing Bruce Momjian 22:02
Re: Explain buffers wrong counter with parallel plans Tom Lane 22:12
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Tom Lane 22:17
Re: pgsql: Fix "base" snapshot handling in logical decoding Alvaro Herrera 22:29
Re: Explain buffers wrong counter with parallel plans Alvaro Herrera 22:38
Re: Bulk Insert into PostgreSQL Srinivas Karthik V 22:47
Re: pgsql: Fix "base" snapshot handling in logical decoding Alvaro Herrera 22:50
Re: pgsql: Fix "base" snapshot handling in logical decoding Tom Lane 23:02

June 30, 2018

Thread Author Time
Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions Tom Lane 05:19
Re: Bulk Insert into PostgreSQL Craig Ringer 13:26
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 13:50
Re: pgsql: Fix "base" snapshot handling in logical decoding 📎 Arseny Sher 15:00
Re: PostgreSQL vs SQL Standard Brad DeJong 16:42
Re: Fix to not check included columns in ANALYZE on indexes Peter Geoghegan 17:56
Re: Postgres 11 release notes Brad DeJong 18:11
Re: Fix to not check included columns in ANALYZE on indexes Tom Lane 18:13
Re: Postgres 11 release notes Daniel Gustafsson 18:48
Re: Postgres 11 release notes Jonathan S. Katz 18:56
Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist Tom Lane 21:38
Re: Postgres 11 release notes Yaroslav 21:48
Re: Postgres 11 release notes Tom Lane 21:52

July 1, 2018

Thread Author Time
Re: Monitoring time of fsyncing WALs Michael Paquier 03:29
Re: Explain buffers wrong counter with parallel plans Amit Kapila 04:28
Re: Microoptimization of Bitmapset usage in postgres_fdw Michael Paquier 06:17
Re: ERROR: cannot start subtransactions during a parallel operation Mai Peng 09:02
Commitfest 2018-07 is underway Andrew Dunstan 11:02
Re: Subplan result caching Peter Eisentraut 11:15
Re: location reporting in TAP test failures Peter Eisentraut 11:17
Re: Adding tests for inheritance trees with temporary tables Michael Paquier 11:30
Re: location reporting in TAP test failures Michael Paquier 11:39
Re: Push down Aggregates below joins Peter Eisentraut 11:40
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Peter Eisentraut 11:43
Re: Continue work on changes to recovery.conf API 📎 Sergei Kornilov 11:45
Re: libpq example doesn't work Peter Eisentraut 12:16
Re: patch to allow disable of WAL recycling Peter Eisentraut 12:54
Re: Small fixes about backup history file in doc and pg_standby Peter Eisentraut 13:12
branches_of_interest.txt Andrew Dunstan 13:30
Re: Cache lookup errors with functions manipulation object addresses 📎 Michael Paquier 14:27
Re: branches_of_interest.txt Tom Lane 15:41
Re: Cache lookup errors with functions manipulation object addresses Andrew Dunstan 16:31
Should contrib modules install .h files? Andrew Gierth 18:23
Re: Should contrib modules install .h files? Andres Freund 18:30
Large Commitfest items Andrew Dunstan 18:46
Re: Large Commitfest items Andres Freund 18:50
Re: Postgres 11 release notes 📎 Jonathan S. Katz 19:57
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath David Rowley 21:37
Re: Commitfest 2018-07 is underway Tatsuo Ishii 23:02
Re: Commitfest 2018-07 is underway Andrew Dunstan 23:24

July 2, 2018

Thread Author Time
Re: Commitfest 2018-07 is underway Thomas Munro 00:14
RE: Bulk Insert into PostgreSQL Tsunakawa, Takayuki 00:19
Re: Synchronous replay take III 📎 Thomas Munro 00:39
Re: Large Commitfest items Craig Ringer 01:36
Re: Bulk Insert into PostgreSQL Peter Geoghegan 01:39
RE: Bulk Insert into PostgreSQL Tsunakawa, Takayuki 02:07
Re: Commitfest 2018-07 is underway Tatsuo Ishii 02:07
Re: Large Commitfest items Andrew Dunstan 02:26
mxid_age() and age(xid) appear undocumented David Rowley 03:18
Re: Monitoring time of fsyncing WALs 📎 Craig Ringer 03:36
Re: Comment refers to non existent function IncreaseRestartDecodingForSlot Michael Paquier 04:32
pg_stat_statements_reset() function execute permissions doc update 📎 Haribabu Kommi 05:15
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query 📎 Haribabu Kommi 05:20
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Ashutosh Bapat 05:46
Add a tab-completion for "SELECT <sth> INTO" or "SELECT <sth> FROM" in psql 📎 C,C H 05:57
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Amit Langote 05:57
Re: [HACKERS] SERIALIZABLE with parallel query Masahiko Sawada 06:12
Re: inconsistency and inefficiency in setup_conversion() 📎 John Naylor 06:59
Re: [PATCH] Include application_name in "connection authorized" log message Peter Eisentraut 07:13
Re: PANIC during crash recovery of a recently promoted standby 📎 Kyotaro HORIGUCHI 07:25
Re: Copy function for logical replication slots 📎 Masahiko Sawada 07:31
Re: buildfarm vs code Peter Eisentraut 07:57
Re: Server crashed with dense_rank on partition table. 📎 Amit Langote 08:14
Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused 📎 Daniel Gustafsson 08:25
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Daniel Gustafsson 08:38
Re: branches_of_interest.txt Peter Eisentraut 08:39
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Sergei Kornilov 08:42
Re: Should contrib modules install .h files? Peter Eisentraut 08:42
Re: branches_of_interest.txt Magnus Hagander 08:45
Re: Add a tab-completion for "SELECT <sth> INTO" or "SELECT <sth> FROM" in psql Edmund Horner 09:19
Re: Threat models for DB cryptography (Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key) Management Service (KMS) Masahiko Sawada 09:22
Re: Tips on committing Michael Paquier 09:24
Re: Large Commitfest items Peter Eisentraut 09:25
How to find the base version cf-bot is using? Kyotaro HORIGUCHI 09:39
Test-cases for deferred constraints in plpgsql_transaction.sql Ashutosh Sharma 09:46
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 09:46
Re: Global shared meta cache Konstantin Knizhnik 09:59
Re: Test-cases for deferred constraints in plpgsql_transaction.sql Peter Eisentraut 10:00
Re: Should contrib modules install .h files? 📎 Andrew Gierth 10:04
psql \df option for procedures Peter Eisentraut 10:07
Re: psql \df option for procedures Andrew Gierth 10:14
Re: How to find the base version cf-bot is using? Thomas Munro 10:14
Re: Test-cases for deferred constraints in plpgsql_transaction.sql Ashutosh Sharma 10:16
Re: Concurrency bug in UPDATE of partition-key Amit Khandekar 11:36
Re: effect of JIT tuple deform? 📎 Pierre Ducroquet 11:48
Re: Cache lookup errors with functions manipulation object addresses Michael Paquier 11:54
Re: jsonpath 📎 Nikita Glukhov 11:56
Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused Masahiko Sawada 12:01
Re: branches_of_interest.txt Robert Haas 12:05
Re: ERROR: cannot start subtransactions during a parallel operation Robert Haas 12:14
Re: branches_of_interest.txt Andrew Dunstan 12:18
Re: Explain buffers wrong counter with parallel plans Robert Haas 12:19
Re: Explain buffers wrong counter with parallel plans Robert Haas 12:32
Re: branches_of_interest.txt Robert Haas 12:33
Re: [HACKERS] Custom compression methods 📎 Ildus Kurbangaliev 12:56
Re: branches_of_interest.txt Andrew Dunstan 12:58
Re: branches_of_interest.txt Tom Lane 13:00
Re: [PATCH] Include application_name in "connection authorized" log message Don Seiler 13:12
Re: psql \df option for procedures Fabrízio de Royes Mello 13:22
pgsql: Add wait event for fsync of WAL segments Michael Paquier 13:23
Re: Monitoring time of fsyncing WALs Michael Paquier 13:25
Re: Should contrib modules install .h files? Tom Lane 13:26
Re: Test-cases for deferred constraints in plpgsql_transaction.sql Tom Lane 13:37
Re: PANIC during crash recovery of a recently promoted standby Michael Paquier 13:41
Re: [HACKERS] Fix performance degradation of contended LWLock on NUMA Jesper Pedersen 13:54
Re: Should contrib modules install .h files? Andrew Gierth 14:10
Re: Should contrib modules install .h files? Tom Lane 14:16
Re: [WIP] [B-Tree] Retail IndexTuple deletion 📎 Andrey V. Lepikhov 14:29
Old small commitfest items Andrew Dunstan 14:30
Re: Should contrib modules install .h files? Andrew Gierth 15:11
Re: Test-cases for deferred constraints in plpgsql_transaction.sql Ashutosh Sharma 15:11
Re: Should contrib modules install .h files? Andrew Gierth 15:15
Re: branches_of_interest.txt Andres Freund 15:16
Re: Should contrib modules install .h files? Andres Freund 15:19
Re: ERROR: cannot start subtransactions during a parallel operation Andres Freund 15:20
Re: Should contrib modules install .h files? Tom Lane 15:22
Re: branches_of_interest.txt Tom Lane 15:37
Re: pgsql: Fix "base" snapshot handling in logical decoding 📎 Arseny Sher 15:52
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Alvaro Hernandez 15:56
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Alvaro Hernandez 16:03
Re: Tips on committing Stephen Frost 16:05
Re: [HACKERS] [PATCH] kNN for SP-GiST Alexander Korotkov 16:06
Re: Tips on committing Alvaro Herrera 16:21
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera 16:23
Re: [WIP] [B-Tree] Retail IndexTuple deletion Peter Geoghegan 16:28
Re: psql \df option for procedures Isaac Morland 17:06
Proposed fix for Bug #15259 (invalid empty array returned by intarray "&" operator) 📎 Alexey Kryuchkov 17:09
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 17:43
Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist Robert Haas 17:52
Re: pgsql: Clarify use of temporary tables within partition trees Robert Haas 18:07
Re: alter index WITH ( storage_parameter = value [, ... ] ) for partition index. Robert Haas 18:18
Re: Fix error message when trying to alter statistics on included column Robert Haas 18:23
Re: Should contrib modules install .h files? Andrew Gierth 18:23
Re: shared-memory based stats collector Robert Haas 18:25
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data Robert Haas 18:27
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Robert Haas 18:43
Re: Speedup of relation deletes during recovery 📎 Fujii Masao 19:13
Re: [WIP] [B-Tree] Retail IndexTuple deletion Peter Geoghegan 19:40
Re: Should contrib modules install .h files? 📎 Andrew Gierth 20:27
Re: Should contrib modules install .h files? Tom Lane 20:46
Re: Should contrib modules install .h files? Andrew Gierth 21:05
Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused 📎 Daniel Gustafsson 21:19
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Tom Lane 21:25
Re: [HACKERS] Small improvement to compactify_tuples Andrew Dunstan 21:49
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data Carter Thaxton 22:11
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Nico Williams 22:12
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Nico Williams 22:14
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 22:16
Re: Threat models for DB cryptography (Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key) Management Service (KMS) Nico Williams 22:16
Re: Protect syscache from bloating with negative cache entries Andrew Dunstan 23:14

Browse Archives

Prev | Next