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

Browse Archives

Prev | Next

June 25, 2018

Thread Author Time
Re: WIP: BRIN multi-range indexes 📎 Tomas Vondra 00:14
Re: PATCH: backtraces for error messages Craig Ringer 01:32
Re: Incorrect errno used with %m for backend code Michael Paquier 02:26
Re: postgresql_fdw doesn't handle defaults correctly Amit Langote 02:30
Re: Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1 Michael Paquier 02:33
Is PG built on any C compilers where int division floors? Chapman Flack 02:42
Incorrect fsync handling in pg_basebackup's tar_finish 📎 Michael Paquier 02:43
Re: bug with expression index on partition Amit Langote 02:57
Re: effect of JIT tuple deform? Pavel Stehule 03:32
Re: Is PG built on any C compilers where int division floors? Tom Lane 03:38
Re: effect of JIT tuple deform? Andres Freund 03:41
Re: effect of JIT tuple deform? Pavel Stehule 03:52
Generating partitioning tuple conversion maps faster 📎 David Rowley 05:00
Re: Generating partitioning tuple conversion maps faster amul sul 05:12
Re: Generating partitioning tuple conversion maps faster Amit Langote 05:26
Re: Generating partitioning tuple conversion maps faster amul sul 05:36
Re: PATCH: backtraces for error messages Kyotaro HORIGUCHI 06:21
Re: Fix some error handling for read() and errno 📎 Michael Paquier 07:18
Re: [bug fix] ECPG: freeing memory for pgtypes crashes on Windows Kyotaro HORIGUCHI 08:02
RE: [bug fix] ECPG: freeing memory for pgtypes crashes on Windows Tsunakawa, Takayuki 08:16
Re: [bug fix] ECPG: freeing memory for pgtypes crashes on Windows Kyotaro HORIGUCHI 08:31
Re: Incorrect fsync handling in pg_basebackup's tar_finish Magnus Hagander 08:57
Re: PATCH: backtraces for error messages Craig Ringer 09:08
Re: libpq compression 📎 Konstantin Knizhnik 09:32
Re: Concurrency bug in UPDATE of partition-key Amit Khandekar 09:36
Auto-partitioning in PostgreSQL 10 zafiirah jumeen 10:00
Re: bug with expression index on partition Amit Langote 10:32
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 11:50
Re: Loaded footgun open_datasync on Windows Kuntal Ghosh 11:58
Re: Incorrect fsync handling in pg_basebackup's tar_finish Kuntal Ghosh 12:18
Re: PATCH: backtraces for error messages Korry Douglas 12:25
Re: Auto-partitioning in PostgreSQL 10 Mark Dilger 13:14
Re: Incorrect fsync handling in pg_basebackup's tar_finish 📎 Michael Paquier 13:17
Regarding the correct and best way to fetching a tablename in contrib module Gaurav Mishra 13:36
Re: comma to delimit fractional seconds Chris Howard 13:38
Re: Incorrect fsync handling in pg_basebackup's tar_finish Kuntal Ghosh 13:51
Regarding the correct and best way to fetching a tablename in contrib module Gaurav Mishra 13:54
Re: Constraint documentation Lætitia Avrot 14:02
Re: Removing obsolete comment block at the top of nbtsort.c. Alvaro Herrera 14:15
Re: Using JSONB directly from application Andrew Dunstan 14:41
Re: Removing unneeded self joins 📎 Alexander Kuzmenkov 15:26
Some pgq table rewrite incompatibility with logical decoding? Jeremy Finzel 15:37
Re: Constraint documentation 📎 Lætitia Avrot 15:45
Re: [PATCH] Include application_name in "connection authorized" log message Gilles Darold 15:50
Re: Loaded footgun open_datasync on Windows Laurenz Albe 16:10
Re: MERGE SQL Statement for PG11 André Brière 16:54
Re: Some pgq table rewrite incompatibility with logical decoding? Andres Freund 17:41
Re: MERGE SQL statement for PG12 Alvaro Herrera 17:43
Re: Some pgq table rewrite incompatibility with logical decoding? Jeremy Finzel 17:48
Re: [WIP] [B-Tree] Retail IndexTuple deletion Andrey V. Lepikhov 18:20
Re: Constraint documentation Vik Fearing 19:25
Re: [PATCH] Include application_name in "connection authorized" log message Don Seiler 19:57
Re: [PATCH] Include application_name in "connection authorized" log message Stephen Frost 20:32
Re: [PATCH] Include application_name in "connection authorized" log message Gilles Darold 20:56
Re: [PATCH] Include application_name in "connection authorized" log message Gilles Darold 21:01
Re: Fix slot's xmin advancement and subxact's lost snapshots in decoding. 📎 Alvaro Herrera 21:25
Re: Psql patch to show access methods info Nikita Glukhov 22:26
Re: Performance regression with PostgreSQL 11 and partitioning Alvaro Herrera 22:48
Re: Scariest patch tournament, PostgreSQL 11 edition Alvaro Herrera 22:52
Re: Constraint documentation Brad DeJong 23:42
Re: Scariest patch tournament, PostgreSQL 11 edition Jeff Janes 23:50

June 26, 2018

Thread Author Time
Re: Performance regression with PostgreSQL 11 and partitioning Tom Lane 00:53
Re: Incorrect fsync handling in pg_basebackup's tar_finish Michael Paquier 00:58
automatic restore point Yotsunaga, Naoki 01:17
Re: automatic restore point David G. Johnston 01:33
Re: using expression syntax for partition bounds 📎 Amit Langote 01:41
Re: PATCH: backtraces for error messages Kyotaro HORIGUCHI 02:41
Re: automatic restore point Isaac Morland 03:01
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) Amit Kapila 04:02
Re: automatic restore point Rui DeSousa 04:04
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server Kyotaro HORIGUCHI 04:29
Re: automatic restore point Justin Pryzby 04:37
Re: automatic restore point Rui DeSousa 04:44
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server Ashutosh Bapat 04:49
partition tree inspection functions 📎 Amit Langote 05:08
Re: automatic restore point Michael Paquier 05:16
Re: automatic restore point Michael Paquier 05:30
Re: Concurrency bug in UPDATE of partition-key Amit Khandekar 06:10
Re: Loaded footgun open_datasync on Windows Michael Paquier 06:12
Re: Regarding the correct and best way to fetching a tablename in contrib module Michael Paquier 06:22
"Access privileges" is missing after pg_dumpall Prabhat Sahu 06:42
Global shared meta cache 📎 Ideriha, Takeshi 06:48
Let's remove DSM_IMPL_NONE. 📎 Kyotaro HORIGUCHI 07:10
Non-reserved replication slots and slot advancing 📎 Michael Paquier 07:13
Re: Excessive CPU usage in StandbyReleaseLocks() Thomas Munro 07:14
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager Masahiko Sawada 07:16
Re: "Access privileges" is missing after pg_dumpall Jeevan Ladhe 07:22
Re: [HACKERS] Restricting maximum keep segments by repslots 📎 Kyotaro HORIGUCHI 07:26
Re: partition tree inspection functions Amit Langote 07:37
Re: Constraint documentation 📎 Lætitia Avrot 07:49
Re: partition tree inspection functions Jeevan Ladhe 07:54
Re: partition tree inspection functions Amit Langote 07:57
Re:Re: some question about _bt_getbuf Imai, Yoshikazu 08:09
RE: "wal receiver" process hang in syslog() while exiting after receiving SIGTERM while the postgres has been promoted. Chen, Yan-Jack (NSB - CN/Hangzhou) 08:12
Small fixes about backup history file in doc and pg_standby 📎 Yugo Nagata 08:47
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Amit Langote 08:57
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro HORIGUCHI 09:00
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Ashutosh Bapat 09:02
ssl_library parameter 📎 Peter Eisentraut 09:06
Re: Constraint documentation Vik Fearing 09:24
Thinko/typo in ExecSimpleRelationInsert 📎 Ashutosh Bapat 09:42
Re: We still claim "cannot begin/end transactions in PL/pgSQL" Peter Eisentraut 09:46
Re: [HACKERS] Possibly too stringent Assert() in b-tree code 📎 Kyotaro HORIGUCHI 09:47
Re: ssl_library parameter Daniel Gustafsson 09:49
Re: some question about _bt_getbuf Kyotaro HORIGUCHI 10:00
RE: ON CONFLICT DO NOTHING on pg_dump Ideriha, Takeshi 10:14
Re: AtEOXact_ApplyLauncher() and subtransactions Amit Khandekar 10:25
Re: [WIP] [B-Tree] Retail IndexTuple deletion Masahiko Sawada 10:31
Re: [HACKERS] GUC for cleanup indexes threshold. Masahiko Sawada 10:45
Re: Thinko/typo in ExecSimpleRelationInsert 📎 Ashutosh Bapat 11:03
Re: Small fixes about backup history file in doc and pg_standby Kyotaro HORIGUCHI 11:19
Re: Online enabling of checksums 📎 Magnus Hagander 11:45
Re: [bug fix] ECPG: freeing memory for pgtypes crashes on Windows Thomas Munro 12:02
unexpected relkind: 73 ERROR with partition table index Rajkumar Raghuwanshi 12:18
PATCH: Update snowball stemmers 📎 Arthur Zakirov 12:20
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian 📎 David Rowley 12:22
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 12:23
Re: [HACKERS] GUC for cleanup indexes threshold. Alexander Korotkov 12:42
Re: Thinko/typo in ExecSimpleRelationInsert Amit Kapila 12:48
Re: [PROPOSAL] Nepali Snowball dictionary 📎 Arthur Zakirov 13:04
Re: unexpected relkind: 73 ERROR with partition table index 📎 David Rowley 13:10
Re: [HACKERS] GUC for cleanup indexes threshold. Darafei Komяpa Praliaskouski 13:10
Re: [HACKERS] GUC for cleanup indexes threshold. Alexander Korotkov 13:16
Re: Online enabling of checksums Sergei Kornilov 13:21
Re: Thinko/typo in ExecSimpleRelationInsert 📎 Ashutosh Bapat 13:32
patch to allow disable of WAL recycling 📎 Jerry Jelinek 13:35
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) Alvaro Herrera 13:41
Re: Fix slot's xmin advancement and subxact's lost snapshots in decoding. Arseny Sher 14:04
Re: Performance regression with PostgreSQL 11 and partitioning Alvaro Herrera 14:43
Re: [GSoC] working status Aleksander Alekseeev 14:44
Re: Performance regression with PostgreSQL 11 and partitioning Thomas Reiss 14:46
Re: unexpected relkind: 73 ERROR with partition table index 📎 Alvaro Herrera 15:09
Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused Alexander Kuzmenkov 15:11
Re: Thinko/typo in ExecSimpleRelationInsert Amit Kapila 15:13
Unexpected behavior of DROP VIEW/TABLE IF EXISTS Peter Moser 15:23
Re: [GSoC] working status Charles Cui 15:25
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Pavel Stehule 15:34
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Peter Moser 15:46
Re: ssl_library parameter Tom Lane 15:48
Unexpected behavior of DROP VIEW/TABLE IF EXISTS David G. Johnston 15:48
Re: "wal receiver" process hang in syslog() while exiting after receiving SIGTERM while the postgres has been promoted. Robert Haas 15:53
Re: Small fixes about backup history file in doc and pg_standby Fujii Masao 15:58
Re: ALTER TABLE does not check for column existence before starting operations Arthur Zakirov 15:59
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Pavel Stehule 16:07
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS David G. Johnston 16:22
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Pavel Stehule 16:47
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS David G. Johnston 17:03
RE: Global shared meta cache serge 17:03
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS Tom Lane 17:06
Re: Global shared meta cache Andres Freund 17:15
Re: postgresql_fdw doesn't handle defaults correctly Pavel Stehule 17:47
wrong query result with jit_above_cost= 0 Rushabh Lathia 18:20
Re: Global shared meta cache AJG 18:20
Re: wrong query result with jit_above_cost= 0 Andres Freund 18:23
Re: Fix slot's xmin advancement and subxact's lost snapshots in decoding. Alvaro Herrera 18:42
Re: effect of JIT tuple deform? Pavel Stehule 19:25
Re: effect of JIT tuple deform? Andres Freund 19:29
Re: Unexpected behavior of DROP VIEW/TABLE IF EXISTS David G. Johnston 19:32
Re: Constraint documentation Brad DeJong 19:35
Re: Fix slot's xmin advancement and subxact's lost snapshots in decoding. Arseny Sher 19:37
Re: wrong query result with jit_above_cost= 0 Dmitry Dolgov 20:09
Re: wrong query result with jit_above_cost= 0 Andres Freund 20:11
Re: wrong query result with jit_above_cost= 0 Dmitry Dolgov 20:21
Re: [bug fix] ECPG: freeing memory for pgtypes crashes on Windows MauMau 20:28
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jerry Sievers 20:48
pgsql: Fix "base" snapshot handling in logical decoding Alvaro Herrera 20:50
Re: Fix slot's xmin advancement and subxact's lost snapshots in decoding. Alvaro Herrera 20:52
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Robbie Harwood 20:54
Re: wrong query result with jit_above_cost= 0 Andrew Gierth 20:55
Re: wrong query result with jit_above_cost= 0 Andres Freund 20:56
Name of main process differs between servers (postmaster vs postgres) Jonathan Lemig 21:51
Re: Query Rewrite for Materialized Views (Postgres Extension) Dent John 21:53
Re: Name of main process differs between servers (postmaster vs postgres) Justin Pryzby 22:02
Re: Name of main process differs between servers (postmaster vs postgres) David G. Johnston 22:04

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

Browse Archives

Prev | Next