pgsql-hackers since 2018-06-22 20:14

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 22, 2018

Thread Author Time
Re: [WIP] [B-Tree] Retail IndexTuple deletion Peter Geoghegan 20:14
Re: bug with expression index on partition Alvaro Herrera 20:54
Re: bug with expression index on partition Alvaro Herrera 21:51
Re: Using JSONB directly from application Christian Ohler 21:52
Re: Speeding up INSERTs and UPDATEs to partitioned tables David Rowley 22:18
Re: Using JSONB directly from application Nico Williams 22:32
Re: Jsonb transform for pl/python 📎 Nikita Glukhov 23:44
Re: Fix some error handling for read() and errno Michael Paquier 23:48

June 23, 2018

Thread Author Time
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Haribabu Kommi 02:06
Re: I'd like to discuss scaleout at PGCon Bruce Momjian 02:17
Re: I'd like to discuss scaleout at PGCon Haribabu Kommi 02:41
Re: SCRAM with channel binding downgrade attack Bruce Momjian 03:01
Re: I'd like to discuss scaleout at PGCon Bruce Momjian 03:03
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Ashutosh Sharma 04:51
effect of JIT tuple deform? Pavel Stehule 06:35
Re: effect of JIT tuple deform? Pavel Stehule 06:47
Re: Concurrency bug in UPDATE of partition-key 📎 Amit Kapila 10:16
Re: Keeping temporary tables in shared buffers Amit Kapila 10:19
Re: libpq compression Konstantin Knizhnik 11:40
Re: PATCH: backtraces for error messages Craig Ringer 12:22
Re: PATCH: backtraces for error messages Craig Ringer 12:25
Re: Incorrect errno used with %m for backend code 📎 Michael Paquier 13:13
Re: Incorrect errno used with %m for backend code Michael Paquier 13:25
Re: SCRAM with channel binding downgrade attack Michael Paquier 13:30
Re: SCRAM with channel binding downgrade attack Bruce Momjian 14:07
Re: Adding Markodwn formatting to psql output Bruce Momjian 14:30
Re: Concurrency bug in UPDATE of partition-key Alvaro Herrera 14:55
Re: Adding Markodwn formatting to psql output Alvaro Herrera 15:01
Re: Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1 Bruce Momjian 15:09
Re: Incorrect visibility test function assigned to snapshot Bruce Momjian 15:18
Re: Adding Markodwn formatting to psql output Vik Fearing 15:23
Re: Constraint documentation Fabien COELHO 17:15
postgresql_fdw doesn't handle defaults correctly Pavel Stehule 17:23
comma to delimit fractional seconds Chris Howard 18:13
Log query parameters for terminated execute 📎 Sergei Kornilov 19:54
Retrieve memory size allocated by libpq 📎 Lars Kanis 19:58
Re: Log query parameters for terminated execute Pavel Stehule 20:08
Re: Does logical replication supports cross platform servers? Bruce Momjian 20:36
pg11b1 from outside a txn: "VACUUM cannot run inside a transaction block": should be: ...or multi-command string Justin Pryzby 21:06
[GSoC] array processing questions Charles Cui 23:54

June 24, 2018

Thread Author Time
Re: pg11b1 from outside a txn: "VACUUM cannot run inside a transaction block": should be: ...or multi-command string Andrew Gierth 00:03
[GSoC] working status Charles Cui 00:05
Re: [GSoC] array processing questions Andrew Gierth 00:44
Re: [GSoC] array processing questions Charles Cui 01:00
Re: WIP: BRIN multi-range indexes 📎 Tomas Vondra 02:01
Re: pg_upgrade from 9.4 to 10.4 📎 Bruce Momjian 02:29
Re: comma to delimit fractional seconds Tom Lane 03:17
Re: Keeping temporary tables in shared buffers Bruce Momjian 03:43
Re: Incorrect errno used with %m for backend code Ashutosh Sharma 03:52
Re: utilities to rebuild commit logs from wal Bruce Momjian 03:53
Re: Desirability of client-side expressions in psql? Pavel Stehule 11:07
Re: New GUC to sample log queries 📎 Adrien Nayrat 11:22
Re: Invisible Indexes Andrew Dunstan 11:27
Re: Incorrect errno used with %m for backend code Michael Paquier 12:23
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 13:33
Re: Invisible Indexes Tom Lane 13:59
Re: Desirability of client-side expressions in psql? Fabien COELHO 14:13
Re: Desirability of client-side expressions in psql? Pavel Stehule 14:17
Re: utilities to rebuild commit logs from wal Chris Travers 14:27
Re: Using JSONB directly from application Tomas Vondra 16:42
Re: Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1 Dave Cramer 17:49
Re: New GUC to sample log queries 📎 Vik Fearing 18:41
Re: Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1 Alvaro Hernandez 18:53
Removing obsolete comment block at the top of nbtsort.c. 📎 Peter Geoghegan 19:28
Re: [HACKERS] PATCH: multivariate histograms and MCV lists 📎 Tomas Vondra 19:45
Re: Desirability of client-side expressions in psql? Fabien COELHO 19:59
Re: effect of JIT tuple deform? Dmitry Dolgov 20:32
Re: effect of JIT tuple deform? Andres Freund 20:36
do I correctly understand these date/time data types? Chapman Flack 21:13
Re: comma to delimit fractional seconds Chris Howard 21:20
Re: WIP: BRIN multi-range indexes Thomas Munro 21:39
Re: Invisible Indexes Bruce Momjian 22:17
Re: WIP: BRIN multi-range indexes Tomas Vondra 22:31
Re: do I correctly understand these date/time data types? Bruce Momjian 23:38

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

Browse Archives

Prev | Next