pgsql-hackers since 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 3, 2018

Thread Author Time
Re: How to find the base version cf-bot is using? Kyotaro HORIGUCHI 00:24
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro HORIGUCHI 00:29
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier 00:55
Re: pgsql: Clarify use of temporary tables within partition trees 📎 David Rowley 00:59
RE: automatic restore point Yotsunaga, Naoki 01:06
RE: automatic restore point Yotsunaga, Naoki 01:07
Re: pgsql: Clarify use of temporary tables within partition trees Robert Haas 01:07
Re: automatic restore point Michael Paquier 01:16
Re: automatic restore point Michael Paquier 01:21
Re: Old small commitfest items Michael Paquier 01:30
Re: Protect syscache from bloating with negative cache entries Alvaro Herrera 01:50
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data Michael Paquier 01:50
Re: Protect syscache from bloating with negative cache entries Andres Freund 01:54
Re: automatic restore point Jaime Casanova 02:05
Re: Speedup of relation deletes during recovery Michael Paquier 02:28
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Robert Haas 02:33
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Robert Haas 02:33
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Robert Haas 02:49
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Amit Langote 02:55
Re: Copy function for logical replication slots Michael Paquier 04:01
Re: Possible bug in logical replication. 📎 Michael Paquier 04:32
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Ashutosh Bapat 04:41
Re: Should contrib modules install .h files? Craig Ringer 04:43
Re: pgsql: Clarify use of temporary tables within partition trees 📎 Michael Paquier 04:55
Re: Possible bug in logical replication. Alvaro Herrera 05:17
Re: pgsql: Clarify use of temporary tables within partition trees David Rowley 06:00
Re: Should contrib modules install .h files? Pavel Stehule 06:04
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 06:11
Re: pgsql: Clarify use of temporary tables within partition trees David Rowley 06:16
Re: Possible bug in logical replication. Arseny Sher 06:16
Re: pgsql: Clarify use of temporary tables within partition trees Amit Langote 06:29
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 06:44
Re: pgsql: Clarify use of temporary tables within partition trees Amit Langote 06:49
Unusable index Konstantin Knizhnik 07:03
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 07:05
Pluggable Storage - Andres's take Andres Freund 07:06
Re: Should contrib modules install .h files? Peter Eisentraut 07:29
Re: Copy function for logical replication slots Masahiko Sawada 08:27
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data Carter Thaxton 08:46
Re: pgsql: Clarify use of temporary tables within partition trees Amit Langote 08:49
Re: Copy function for logical replication slots Craig Ringer 08:58
Re: pgsql: Clarify use of temporary tables within partition trees David Rowley 09:05
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 09:15
Re: pgsql: Clarify use of temporary tables within partition trees David Rowley 09:30
Re: pgsql: Clarify use of temporary tables within partition trees Amit Langote 09:50
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 09:53
Re: shared-memory based stats collector 📎 Kyotaro HORIGUCHI 10:01
How to use public key file to encrypt data ROS Didier 10:17
Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused Masahiko Sawada 10:24
Re: Psql patch to show access methods info 📎 s.cherkashin 10:25
Re: Threat models for DB cryptography (Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key) Management Service (KMS) Masahiko Sawada 10:28
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data Surafel Temesgen 10:31
Re: Explain buffers wrong counter with parallel plans Amit Kapila 10:48
Re: Failed assertion due to procedure created with SECURITY DEFINER option amul sul 10:58
Re: pgsql: Clarify use of temporary tables within partition trees 📎 David Rowley 11:16
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 11:17
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 11:18
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 11:21
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 11:26
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 11:31
Re: Explain buffers wrong counter with parallel plans Robert Haas 11:37
Re: Threat models for DB cryptography (Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key) Management Service (KMS) Nico Williams 11:44
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 11:45
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 11:48
Re: Add --include-table-data-where option to pg_dump, to export only a subset of table data Robert Haas 12:02
Re: pgsql: Clarify use of temporary tables within partition trees Ashutosh Bapat 12:15
Re: [WIP] [B-Tree] Retail IndexTuple deletion 📎 Andrey V. Lepikhov 12:17
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 12:20
Re: SQL/JSON: functions 📎 Nikita Glukhov 12:30
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Moon, Insung 12:36
Re: Desirability of client-side expressions in psql? Ashutosh Bapat 12:43
Re: SQL/JSON: functions Pavel Stehule 12:56
Re: [HACKERS] plpgsql - additional extra checks Tomas Vondra 13:45
Re: SQL/JSON: JSON_TABLE 📎 Nikita Glukhov 14:48
Re: pgsql: Clarify use of temporary tables within partition trees Tom Lane 16:21
Re: Server crashed with dense_rank on partition table. Andres Freund 16:23
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Andres Freund 16:35
Re: Non-reserved replication slots and slot advancing Andres Freund 16:55
Re: [HACKERS] logical decoding of two-phase transactions 📎 Nikhil Sontakke 17:20
Re: Failed assertion due to procedure created with SECURITY DEFINER option Andres Freund 17:20
Re: Non-reserved replication slots and slot advancing Alvaro Herrera 17:23
Re: Non-reserved replication slots and slot advancing Andres Freund 17:37
Re: Non-reserved replication slots and slot advancing Alvaro Herrera 17:51
Re: [HACKERS] logical decoding of two-phase transactions 📎 Nikhil Sontakke 18:09
Re: AtEOXact_ApplyLauncher() and subtransactions 📎 Robert Haas 18:57
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera 19:13
Re: pgsql: Add wait event for fsync of WAL segments Andres Freund 19:18
Re: pgsql: Add wait event for fsync of WAL segments Alvaro Herrera 20:12
Cache invalidation after authentication (on-the-fly role creation) Thomas Munro 21:58
Re: pgsql: Add wait event for fsync of WAL segments Michael Paquier 22:32
Re: Non-reserved replication slots and slot advancing Michael Paquier 22:52
Re: [HACKERS] [PATCH] kNN for SP-GiST 📎 Nikita Glukhov 23:21
Re: Bulk Insert into PostgreSQL Srinivas Karthik V 23:34
Re: Cache invalidation after authentication (on-the-fly role creation) Alvaro Herrera 23:44
Re: PATCH: pgbench - option to build using ppoll() for larger connection counts Andrew Dunstan 23:52

July 4, 2018

Thread Author Time
Re: Cache invalidation after authentication (on-the-fly role creation) Andres Freund 00:10
How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 00:27
Re: pgsql: Clarify use of temporary tables within partition trees Amit Langote 01:13
Re: pgsql: Clarify use of temporary tables within partition trees Amit Langote 01:24
Re: Bulk Insert into PostgreSQL Ashwin Agrawal 01:30
Re: How can we submit code patches that implement our (pending) patents? Craig Ringer 01:48
Re: pgsql: Clarify use of temporary tables within partition trees Michael Paquier 01:48
Re: Possible bug in logical replication. Michael Paquier 01:50
Re: pgsql: Clarify use of temporary tables within partition trees David Rowley 01:55
Re: Non-reserved replication slots and slot advancing Michael Paquier 01:57
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 02:00
RE: libpq example doesn't work Ideriha, Takeshi 02:28
move PartitionDispatchData definition to execPartition.c 📎 Amit Langote 02:47
Re: Cache invalidation after authentication (on-the-fly role creation) 📎 Thomas Munro 04:25
Re: Cache invalidation after authentication (on-the-fly role creation) Michael Paquier 04:35
Re: Cache invalidation after authentication (on-the-fly role creation) Andres Freund 04:35
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Michael Paquier 04:59
Legacy GiST invalid tuples Andrey Borodin 05:49
When use prepared protocol, transaction will hold backend_xmin until the end of the transaction. chenhj 06:21
Re: why partition pruning doesn't work? 📎 Amit Langote 06:38
documentation about explicit locking Amit Langote 07:09
RE: Global shared meta cache Ideriha, Takeshi 07:23
Re: Failed assertion due to procedure created with SECURITY DEFINER option 📎 Peter Eisentraut 07:43
Re: Test-cases for deferred constraints in plpgsql_transaction.sql Peter Eisentraut 07:46
RE: Recovery performance of DROP DATABASE with many tablespaces Jamison, Kirk 07:47
Re: [HACKERS] Restricting maximum keep segments by repslots 📎 Kyotaro HORIGUCHI 08:28
Re: shared-memory based stats collector 📎 Kyotaro HORIGUCHI 08:29
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Peter Eisentraut 08:46
Re: Cache invalidation after authentication (on-the-fly role creation) 📎 Thomas Munro 09:37
[PATCH] btree_gist: fix union implementation for variable length columns 📎 Pavel Raiskup 09:54
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 10:04
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 10:06
Re: Pluggable Storage - Andres's take Haribabu Kommi 10:11
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 10:11
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query 📎 Haribabu Kommi 10:12
Re: [HACKERS] WAL logging problem in 9.4.3? Andrew Dunstan 11:55
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 12:06
Locking considerations of REINDEX Pavan Deolasee 12:08
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 12:37
Re: Libpq support to connect to standby server as priority Laurenz Albe 13:14
Re: How to use public key file to encrypt data 📎 Jeff Janes 13:17
Re: Allow auto_explain to log to NOTICE 📎 Andrew Dunstan 13:34
Re: Non-reserved replication slots and slot advancing Alvaro Herrera 13:57
Failure assertion in GROUPS mode of window function in current HEAD 📎 Masahiko Sawada 14:24
Re: Locking considerations of REINDEX Peter Geoghegan 15:01
Re: Legacy GiST invalid tuples Tom Lane 15:22
Re: Legacy GiST invalid tuples Andrey Borodin 15:57
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Sergei Kornilov 15:59
Re: Recovery performance of DROP DATABASE with many tablespaces Fujii Masao 16:42
Why B-Tree suffix truncation matters Peter Geoghegan 16:43
Re: Bulk Insert into PostgreSQL Peter Geoghegan 16:57
Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions Alvaro Herrera 17:15
Re: "Access privileges" is missing after pg_dumpall Tom Lane 17:42
Re: Speedup of relation deletes during recovery Fujii Masao 18:10
Re: Legacy GiST invalid tuples Alvaro Herrera 20:04
Re: Legacy GiST invalid tuples Tom Lane 20:10
Re: hot_standby_feedback vs excludeVacuum and snapshots Noah Misch 20:27
Re: Legacy GiST invalid tuples Alvaro Herrera 20:43
Re: Allow COPY's 'text' format to output a header 📎 Simon Muller 20:44
Re: Legacy GiST invalid tuples Andres Freund 20:48
Re: Should contrib modules install .h files? Tom Lane 21:00
Re: Legacy GiST invalid tuples Alvaro Herrera 21:02
Re: Legacy GiST invalid tuples Andres Freund 21:08
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Tom Lane 21:17
Re: Legacy GiST invalid tuples Alvaro Herrera 21:19
Re: shared-memory based stats collector Tom Lane 21:23
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS David G. Johnston 21:33
Re: Cache invalidation after authentication (on-the-fly role creation) Tom Lane 21:35
setproctitle_fast() 📎 Thomas Munro 22:09
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Andres Freund 23:07
peripatus build failures.... Larry Rosenman 23:43

July 5, 2018

Thread Author Time
Re: Looks like we can enable AF_UNIX on Windows now Noah Misch 00:16
Re: peripatus build failures.... Thomas Munro 00:30
Re: peripatus build failures.... Larry Rosenman 00:35
Re: Server crashed with dense_rank on partition table. Andres Freund 00:40
Re: peripatus build failures.... Larry Rosenman 00:46
Re: Server crashed with dense_rank on partition table. Amit Langote 00:49
Re: peripatus build failures.... Thomas Munro 00:56
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Robert Haas 01:14
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 01:15
Re: peripatus build failures.... Larry Rosenman 01:19
Re: Invisible Indexes David Rowley 01:26
Re: Invisible Indexes Peter Geoghegan 01:31
Re: peripatus build failures.... Larry Rosenman 01:37
Re: PANIC during crash recovery of a recently promoted standby Michael Paquier 01:50
Re: Old small commitfest items Peter Geoghegan 01:54
Re: Invisible Indexes David Rowley 02:09
Re: Invisible Indexes Peter Geoghegan 02:38
Re: Old small commitfest items Michael Paquier 02:53
Re: shared-memory based stats collector Kyotaro HORIGUCHI 03:04
Re: Old small commitfest items Peter Geoghegan 03:08
Re: Non-reserved replication slots and slot advancing Michael Paquier 03:19
Re: Speedup of relation deletes during recovery Michael Paquier 03:27
Re: pgsql: Fix crash when ALTER TABLE recreates indexes on partitions Andres Freund 03:33
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Ashutosh Bapat 03:34
RE: Speeding up INSERTs and UPDATEs to partitioned tables Kato, Sho 06:39
Re: [HACKERS] Restricting maximum keep segments by repslots Masahiko Sawada 06:43
Re: [HACKERS] WAL logging problem in 9.4.3? Michael Paquier 07:11
Re: PANIC during crash recovery of a recently promoted standby Pavan Deolasee 07:33
Re: Copy function for logical replication slots Michael Paquier 07:47
Re: [HACKERS] Replication status in logical replication Michael Paquier 08:13
Re: Recovery performance of DROP DATABASE with many tablespaces Simon Riggs 08:15
Re: PANIC during crash recovery of a recently promoted standby Michael Paquier 08:16
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Pavel Stehule 08:18
Re: Copy function for logical replication slots Masahiko Sawada 08:24

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31