pgsql-hackers since 2018-06-27 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

June 27, 2018

Thread Author Time
Re: Speedup of relation deletes during recovery 📎 Thomas Munro 00:16
Re: Speedup of relation deletes during recovery 📎 Thomas Munro 01:13
Re: Speedup of relation deletes during recovery Thomas Munro 01:44
Re: Speedup of relation deletes during recovery Andres Freund 01:46
Re: Is PG built on any C compilers where int division floors? Chapman Flack 03:28
Re: Is PG built on any C compilers where int division floors? Tom Lane 03:33
Re: Speedup of relation deletes during recovery Thomas Munro 03:56
Re: [WIP] [B-Tree] Retail IndexTuple deletion Andrey V. Lepikhov 04:05
Re: Speedup of relation deletes during recovery Andres Freund 04:17
Re: Speedup of relation deletes during recovery Thomas Munro 04:33
Re: Thinko/typo in ExecSimpleRelationInsert Ashutosh Bapat 04:39
RE: "wal receiver" process hang in syslog() while exiting after receiving SIGTERM while the postgres has been promoted. Chen, Yan-Jack (NSB - CN/Hangzhou) 04:46
partitioning - changing a slot's descriptor is expensive Andres Freund 05:09
Typo in llvm_function_reference 📎 Rushabh Lathia 05:16
Re: Excessive PostmasterIsAlive calls slow down WAL redo Thomas Munro 05:26
Re: partitioning - changing a slot's descriptor is expensive Amit Langote 05:46
Re: Thinko/typo in ExecSimpleRelationInsert Amit Kapila 05:54
Re: partitioning - changing a slot's descriptor is expensive Andres Freund 05:55
Re: unexpected relkind: 73 ERROR with partition table index Rajkumar Raghuwanshi 05:59
Re: Thinko/typo in ExecSimpleRelationInsert Ashutosh Bapat 06:00
Re: partitioning - changing a slot's descriptor is expensive Amit Langote 06:03
Re: ssl_library parameter Peter Eisentraut 06:12
Re: Server crashed with TRAP: FailedAssertion("!(parallel_workers > 0)" when partitionwise_aggregate true. Jeevan Chalke 06:13
Re: [HACKERS] GnuTLS support Peter Eisentraut 06:17
commitfest app moving patch error Peter Eisentraut 06:20
Re: Typo in llvm_function_reference Andres Freund 06:20
Re: postgresql_fdw doesn't handle defaults correctly Amit Langote 06:28
libpq example doesn't work 📎 Ideriha, Takeshi 06:29
Re: postgresql_fdw doesn't handle defaults correctly Pavel Stehule 06:33
Re: [WIP] [B-Tree] Retail IndexTuple deletion 📎 Andrey V. Lepikhov 06:40
Re: Constraint documentation Peter Eisentraut 06:44
Re: postgresql_fdw doesn't handle defaults correctly Amit Langote 06:45
Re: Portability concerns over pq_sendbyte? Andres Freund 06:51
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Amit Langote 06:58
Re: postgresql_fdw doesn't handle defaults correctly Pavel Stehule 06:59
Re: postgresql_fdw doesn't handle defaults correctly Amit Langote 07:30
Re: Performance regression with PostgreSQL 11 and partitioning 📎 Amit Langote 07:56
Re: [HACKERS] WIP: Data at rest encryption 📎 Antonin Houska 08:02
Re: PANIC during crash recovery of a recently promoted standby 📎 Michael Paquier 08:29
Re: Small fixes about backup history file in doc and pg_standby Yugo Nagata 08:42
Re: Small fixes about backup history file in doc and pg_standby 📎 Yugo Nagata 08:52
Utilisation of get_page_from_raw() in pageinspect Ashutosh Sharma 09:01
Re: postgresql_fdw doesn't handle defaults correctly Pavel Stehule 09:12
Re: postgresql_fdw doesn't handle defaults correctly Pavel Stehule 09:19
Re: postgresql_fdw doesn't handle defaults correctly Pavel Stehule 09:33
Re: Small fixes about backup history file in doc and pg_standby Michael Paquier 09:36
Re: Portability concerns over pq_sendbyte? Michael Paquier 09:40
alter index WITH ( storage_parameter = value [, ... ] ) for partition index. Rajkumar Raghuwanshi 09:42
Re: Code of Conduct committee: call for volunteers ERR ORR 09:44
Re: WAL prefetch 📎 Konstantin Knizhnik 09:44
Re: Concurrency bug in UPDATE of partition-key Amit Khandekar 10:05
Re: Loaded footgun open_datasync on Windows Laurenz Albe 10:09
Re: [HACKERS] proposal: schema variables Gilles Darold 10:21
Re: commitfest app moving patch error Magnus Hagander 10:35
Re: Code of Conduct committee: call for volunteers Raymond O'Donnell 11:11
Bulk Insert into PostgreSQL Srinivas Karthik V 11:18
Re: [HACKERS] proposal: schema variables Pavel Stehule 11:22
Re: Bulk Insert into PostgreSQL Pavel Stehule 11:25
RE: Bulk Insert into PostgreSQL ROS Didier 11:46
Re: Code of Conduct committee: call for volunteers Geoff Winkless 12:02
Re: partition tree inspection functions Michael Paquier 12:16
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative 📎 Daniel Gustafsson 12:32
Re: partitioning - changing a slot's descriptor is expensive Ashutosh Bapat 13:03
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) Amit Kapila 13:06
Re: Thinko/typo in ExecSimpleRelationInsert Amit Kapila 13:15
Re: Does logical replication supports cross platform servers? Haribabu Kommi 13:16
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Ashutosh Bapat 13:21
Forbid referencing columns by names in ALTER INDEX ... SET STATISTICS 📎 Yugo Nagata 13:22
Re: Name of main process differs between servers (postmaster vs postgres) Jonathan Lemig 14:09
Re: effect of JIT tuple deform? Tomas Vondra 15:19
Re: WAL prefetch Tomas Vondra 15:25
Re: effect of JIT tuple deform? Pavel Stehule 15:38
Re: assert in nested SQL procedure call in current HEAD Andres Freund 15:44
Re: wrong query result with jit_above_cost= 0 Dmitry Dolgov 15:49
CREATE TABLE .. LIKE .. EXCLUDING documentation 📎 Yugo Nagata 16:02
Re: Small fixes about backup history file in doc and pg_standby Yugo Nagata 16:22
Re: "wal receiver" process hang in syslog() while exiting after receiving SIGTERM while the postgres has been promoted. Fujii Masao 16:28
Monitoring time of fsyncing WALs 📎 Konstantin Knizhnik 16:32
Re: Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1 Peter Eisentraut 16:49
Re: assert in nested SQL procedure call in current HEAD Peter Eisentraut 16:51
Re: SCRAM with channel binding downgrade attack Peter Eisentraut 16:55
Re: Jsonb transform for pl/python Peter Eisentraut 16:58
Re: [HACKERS] proposal: schema variables Gilles Darold 17:15
Re: [HACKERS] proposal: schema variables Pavel Stehule 17:17
Re: SCRAM with channel binding downgrade attack Alvaro Herrera 17:24
Re: Speedup of relation deletes during recovery 📎 Fujii Masao 18:21
Re: Speedup of relation deletes during recovery Andres Freund 18:23
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative 📎 Daniel Gustafsson 18:57
Allow cancelling VACUUM of nbtrees with corrupted right links 📎 Andres Freund 19:16
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Alvaro Herrera 19:18
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Andres Freund 19:18
Re: Performance regression with PostgreSQL 11 and partitioning Alvaro Herrera 19:43
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Peter Geoghegan 19:49
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Andres Freund 19:52
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Peter Geoghegan 20:02
Re: adding tab completions 📎 Justin Pryzby 20:10
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Andres Freund 20:11
Re: Allow cancelling VACUUM of nbtrees with corrupted right links Peter Geoghegan 20:12
ALTER TABLE on system catalogs 📎 Peter Eisentraut 20:31
Re: Bulk Insert into PostgreSQL Don Seiler 20:36
Re: ALTER TABLE on system catalogs Andres Freund 20:37
Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) Alvaro Herrera 21:01
Re: New GUC to sample log queries Adrien Nayrat 21:13
Re: Monitoring time of fsyncing WALs David Steele 21:29
Capitalization of the name OpenSSL 📎 Daniel Gustafsson 22:16
Re: Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) David Rowley 22:18
Re: Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) Alvaro Herrera 22:21
Re: Remove mention in docs that foreign keys on partitioned tables are not supported 📎 Alvaro Herrera 22:58
Re: ALTER TABLE on system catalogs Michael Paquier 23:10
Re: [WIP] [B-Tree] Retail IndexTuple deletion Peter Geoghegan 23:35
SQL/JSON: documentation 📎 Nikita Glukhov 23:36
Re: jsonpath 📎 Nikita Glukhov 23:38
ENOSPC FailedAssertion("!(RefCountErrors == 0)" Justin Pryzby 23:39

June 28, 2018

Thread Author Time
Re: [WIP] [B-Tree] Retail IndexTuple deletion Peter Geoghegan 00:00
Re: SQL/JSON: functions 📎 Nikita Glukhov 00:18
Re: SQL/JSON: JSON_TABLE 📎 Nikita Glukhov 00:34
Re: PANIC during crash recovery of a recently promoted standby 📎 Michael Paquier 01:37
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" Michael Paquier 02:04
Re: SQL/JSON: documentation Chapman Flack 02:23
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Amit Langote 02:26
Re: Monitoring time of fsyncing WALs 📎 Michael Paquier 02:27
Re: jsonpath Thomas Munro 02:39
Re: partition tree inspection functions 📎 Amit Langote 02:50
Copy function for logical replication slots 📎 Masahiko Sawada 02:51
Re: Capitalization of the name OpenSSL Michael Paquier 02:54
Re: Copy function for logical replication slots Michael Paquier 03:29
Re: partition tree inspection functions Michael Paquier 03:43
Re: SQL/JSON: functions Pavel Stehule 04:25
[GSoC] thrift compact protocol byte interface get implemented Charles Cui 05:05
RE: Global shared meta cache Tsunakawa, Takayuki 05:09
Re: [WIP] [B-Tree] Retail IndexTuple deletion Andrey V. Lepikhov 05:36
Re: [HACKERS] Crash on promotion when recovery.conf is renamed 📎 Michael Paquier 05:39
Re: partition tree inspection functions 📎 Amit Langote 05:49
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Amit Langote 05:53
Re: alter index WITH ( storage_parameter = value [, ... ] ) for partition index. Rajkumar Raghuwanshi 06:21
Re: Copy function for logical replication slots 📎 Masahiko Sawada 06:34
Re: alter index WITH ( storage_parameter = value [, ... ] ) for partition index. Michael Paquier 06:37
Re: alter index WITH ( storage_parameter = value [, ... ] ) for partition index. Rajkumar Raghuwanshi 06:38
Re: Copy function for logical replication slots Michael Paquier 06:47
Re: Changing the autovacuum launcher scheduling; oldest table first algorithm Masahiko Sawada 07:20
Re: SCRAM with channel binding downgrade attack Magnus Hagander 07:33
Re: SCRAM with channel binding downgrade attack Magnus Hagander 07:35
Re: Capitalization of the name OpenSSL Magnus Hagander 07:44
Re: Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) Peter Eisentraut 07:50
Re: Capitalization of the name OpenSSL 📎 Daniel Gustafsson 07:54
Re: [HACKERS] SERIALIZABLE with parallel query Masahiko Sawada 07:55
Re: SCRAM with channel binding downgrade attack Peter Eisentraut 08:04
Re: SCRAM with channel binding downgrade attack Peter Eisentraut 08:05
SCRAM with channel binding downgrade attack Peter Eisentraut 08:05
Re: SCRAM with channel binding downgrade attack Magnus Hagander 08:07
Re: ALTER TABLE on system catalogs Peter Eisentraut 08:14
Re: Copy function for logical replication slots Peter Eisentraut 08:37
Re: partition tree inspection functions Peter Eisentraut 08:40
Re: partition tree inspection functions Amit Langote 08:59
Fix error message when trying to alter statistics on included column 📎 Yugo Nagata 09:28
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Peter Moser 09:37
Re: Copy function for logical replication slots Masahiko Sawada 10:10
Re: partition tree inspection functions Peter Eisentraut 10:37
Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)" Rajkumar Raghuwanshi 10:38
Re: adding tab completions 📎 Arthur Zakirov 11:20
Re: Capitalization of the name OpenSSL Michael Paquier 11:21
Re: partition tree inspection functions Michael Paquier 11:30
Fix to not check included columns in ANALYZE on indexes 📎 Yugo Nagata 11:53
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Isaac Morland 12:27
Re: SCRAM with channel binding downgrade attack Bruce Momjian 12:48
Re: SCRAM with channel binding downgrade attack Bruce Momjian 12:51
Re: partition tree inspection functions Ashutosh Bapat 13:01
Re: Does logical replication supports cross platform servers? Bruce Momjian 13:12
Tips on committing Bruce Momjian 13:26
Re: Generating partitioning tuple conversion maps faster 📎 Alexander Kuzmenkov 14:23
Re: Forbid referencing columns by names in ALTER INDEX ... SET STATISTICS Robert Haas 14:26
Re: Tips on committing Alvaro Herrera 15:14
Re: Tips on committing Andres Freund 15:20
Re: Tips on committing Bruce Momjian 15:21
Re: Tips on committing Robert Haas 15:23
Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)" Andres Freund 16:15
Re: Tips on committing Peter Geoghegan 16:46
cost_sort() improvements 📎 Teodor Sigaev 16:47
Re: POC: GROUP BY optimization Teodor Sigaev 16:52
Re: Tips on committing Alvaro Herrera 16:52
Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)" Rajkumar Raghuwanshi 17:05
Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)" Andres Freund 17:06
Re: Tips on committing Peter Geoghegan 17:52
Re: cost_sort() improvements Peter Geoghegan 19:30
Re: Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) 📎 Alvaro Herrera 20:52
Re: partition tree inspection functions Peter Eisentraut 21:19
Re: Listing triggers in partitions (was Re: Remove mention in docs that foreign keys on partitioned tables) Peter Eisentraut 21:23
Re: SQL/JSON: documentation Nikita Glukhov 22:45
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation Daniel Gustafsson 22:57
Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)" 📎 Alvaro Herrera 23:00
Re: Generating partitioning tuple conversion maps faster David Rowley 23:10
Re: SQL/JSON: documentation Chapman Flack 23:16
Re: Fix to not check included columns in ANALYZE on indexes Tom Lane 23:18
Re: CREATE TABLE .. LIKE .. EXCLUDING documentation David G. Johnston 23:22
Re: Fix to not check included columns in ANALYZE on indexes Andres Freund 23:22
Re: Fix to not check included columns in ANALYZE on indexes Tom Lane 23:28
Re: Fix to not check included columns in ANALYZE on indexes Andres Freund 23:39
Re: Fix to not check included columns in ANALYZE on indexes Tom Lane 23:50

June 29, 2018

Thread Author Time
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query 📎 Haribabu Kommi 00:14
Re: Generating partitioning tuple conversion maps faster 📎 David Rowley 00:25

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