pgsql-hackers before 2018-07-16 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 12, 2018

Thread Author Time
Re: [PATCH] Add missing type conversion functions for PL/Python 📎 Nikita Glukhov 15:06
Re: Postgres 11 release notes Tom Lane 15:14
Re: Failure assertion in GROUPS mode of window function in current HEAD Tom Lane 15:17
Re: _isnan() on Windows Andrew Dunstan 15:28
Re: Failure assertion in GROUPS mode of window function in current HEAD Masahiko Sawada 15:33
Re: [PATCH] btree_gist: fix union implementation for variable length columns Teodor Sigaev 15:53
Re: generating bootstrap entries for array types Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 15:58
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Fabien COELHO 16:00
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Fabien COELHO 16:04
Re: GiST VACUUM 📎 Andrey Borodin 16:06
Re: [PATCH] Add missing type conversion functions for PL/Python Heikki Linnakangas 16:09
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 16:18
Re: TRUNCATE tables referenced by FKs on partitioned tables Alvaro Herrera 16:29
Re: small doc fix - using expressions in plpgsql FETCH command Tom Lane 16:29
Re: Vacuum: allow usage of more than 1GB of work mem Claudio Freire 16:38
Re: GiST VACUUM Heikki Linnakangas 16:40
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Andres Freund 16:40
Re: assert in nested SQL procedure call in current HEAD Andres Freund 16:43
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Tom Lane 16:43
Re: Concurrency bug in UPDATE of partition-key Andres Freund 16:44
Re: patch to allow disable of WAL recycling Jerry Jelinek 16:49
Re: Fix error message when trying to alter statistics on included column Andres Freund 16:53
Re: small doc fix - using expressions in plpgsql FETCH command Pavel Stehule 17:00
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Alvaro Herrera 17:06
Re: GiST VACUUM Andrey Borodin 17:07
Re: Cannot dump foreign key constraints on partitioned table Alvaro Herrera 17:15
requested timeline ... does not contain minimum recovery point ... Christophe Pettus 17:20
Re: requested timeline ... does not contain minimum recovery point ... Andres Freund 17:29
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Fabien COELHO 18:27
Re: assert in nested SQL procedure call in current HEAD Peter Eisentraut 18:28
Re: Cannot dump foreign key constraints on partitioned table 📎 Alvaro Herrera 18:45
Re: Cache invalidation after authentication (on-the-fly role creation) Tom Lane 18:52
Re: [WIP] [B-Tree] Retail IndexTuple deletion Peter Geoghegan 19:00
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Robbie Harwood 19:07
Re: Failed assertion due to procedure created with SECURITY DEFINER option Jonathan S. Katz 19:52
Re: When use prepared protocol, transaction will hold backend_xmin until the end of the transaction. Tom Lane 20:05
Re: requested timeline ... does not contain minimum recovery point ... Christophe Pettus 21:26
Re: Temporary WAL segments files not cleaned up after an instance crash Michael Paquier 21:45
Re: pgsql: Allow using the updated tuple while moving it to a different par Tom Lane 21:57
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Fabien COELHO 22:03
Re: Vacuum: allow usage of more than 1GB of work mem Andrew Dunstan 22:15
Re: performance statistics monitoring without spamming logs Lukas Fittl 22:25
Re: Shared buffer access rule violations? Tom Lane 22:30
Re: Vacuum: allow usage of more than 1GB of work mem Alvaro Herrera 22:34
Re: Vacuum: allow usage of more than 1GB of work mem Andrew Dunstan 22:39

July 13, 2018

Thread Author Time
RE: ON CONFLICT DO NOTHING on pg_dump Ideriha, Takeshi 00:33
Re: pg_create_logical_replication_slot returns text instead of name Michael Paquier 00:48
Re: GSOC 2018 Project - A New Sorting Routine 📎 Tomas Vondra 00:50
Re: requested timeline ... does not contain minimum recovery point ... Michael Paquier 00:52
Re: Cannot dump foreign key constraints on partitioned table Michael Paquier 01:00
Re: patch to allow disable of WAL recycling Thomas Munro 01:06
Re: [HACKERS] WAL logging problem in 9.4.3? Michael Paquier 01:47
Re: ON CONFLICT DO NOTHING on pg_dump Thomas Munro 02:02
Re: pg_create_logical_replication_slot returns text instead of name Masahiko Sawada 02:14
RE: Locking B-tree leafs immediately in exclusive mode 📎 Imai, Yoshikazu 02:14
Re: pg_create_logical_replication_slot returns text instead of name Michael Paquier 02:22
Re: requested timeline ... does not contain minimum recovery point ... Christophe Pettus 02:22
Re: pg_create_logical_replication_slot returns text instead of name Masahiko Sawada 02:28
Re: requested timeline ... does not contain minimum recovery point ... Christophe Pettus 02:38
RE: ON CONFLICT DO NOTHING on pg_dump Ideriha, Takeshi 02:46
Re: requested timeline ... does not contain minimum recovery point ... Andres Freund 02:54
How to make partitioning scale better for larger numbers of partitions Kato, Sho 02:58
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 03:00
Re: [PATCH] Timestamp for a XLOG_BACKUP_END WAL-record Andrey V. Lepikhov 03:13
Re: Cannot dump foreign key constraints on partitioned table Alvaro Herrera 03:34
RE: How to make partitioning scale better for larger numbers of partitions Kato, Sho 03:53
Re: Cache invalidation after authentication (on-the-fly role creation) Thomas Munro 04:23
Re: Temporary tables prevent autovacuum, leading to XID wraparound Michael Paquier 04:29
Re: How to make partitioning scale better for larger numbers of partitions Amit Langote 04:34
Re: [PATCH] Timestamp for a XLOG_BACKUP_END WAL-record Michael Paquier 04:40
Re: Checkpoint not retrying failed fsync? Thomas Munro 04:44
Re: Cannot dump foreign key constraints on partitioned table Michael Paquier 04:50
Re: file cloning in pg_upgrade and CREATE DATABASE Thomas Munro 05:09
RE: How to make partitioning scale better for larger numbers of partitions Tsunakawa, Takayuki 05:49
Re: [PATCH] pg_hba.conf : new auth option : clientcert=verify-full Thomas Munro 05:49
Re: Cannot dump foreign key constraints on partitioned table amul sul 06:07
Re: How to make partitioning scale better for larger numbers of partitions Justin Pryzby 06:15
Re: How to make partitioning scale better for larger numbers of partitions David Rowley 06:20
Re: How to make partitioning scale better for larger numbers of partitions David Rowley 06:25
Re: How to make partitioning scale better for larger numbers of partitions Amit Langote 06:28
RE: How to make partitioning scale better for larger numbers of partitions Tsunakawa, Takayuki 06:53
RE: Global shared meta cache Ideriha, Takeshi 07:03
Re: How can we submit code patches that implement our (pending) patents? Chris Travers 07:07
Re: How to make partitioning scale better for larger numbers of partitions David Rowley 07:11
RE: How to make partitioning scale better for larger numbers of partitions Tsunakawa, Takayuki 07:11
Re: performance statistics monitoring without spamming logs Adrien NAYRAT 07:23
Re: performance statistics monitoring without spamming logs Adrien NAYRAT 07:24
RE: How to make partitioning scale better for larger numbers of partitions Kato, Sho 07:29
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case 📎 Amit Langote 07:45
Re: Preferring index-only-scan when the cost is equal Yugo Nagata 07:52
Re: performance statistics monitoring without spamming logs Julien Rouhaud 07:55
Re: [HACKERS] WIP: Data at rest encryption Toshi Harada 07:56
Re: How to make partitioning scale better for larger numbers of partitions Amit Langote 07:58
Re: [PATCH] Include application_name in "connection authorized" log message Peter Eisentraut 08:11
Re: Constraint documentation Peter Eisentraut 08:14
RE: automatic restore point Yotsunaga, Naoki 08:16
[PATCH] LLVM tuple deforming improvements 📎 Pierre Ducroquet 08:20
Re: Speeding up INSERTs and UPDATEs to partitioned tables 📎 Amit Langote 08:20
Re: file cloning in pg_upgrade and CREATE DATABASE Peter Eisentraut 08:22
Re: Constraint documentation Fabien COELHO 08:39
Re: [HACKERS] Restricting maximum keep segments by repslots 📎 Kyotaro HORIGUCHI 08:40
Re: pgbench's expression parsing & negative numbers 📎 Fabien COELHO 08:46
Re: Failed assertion due to procedure created with SECURITY DEFINER option Peter Eisentraut 08:46
Re: ALTER TABLE on system catalogs Peter Eisentraut 09:05
RE: How to make partitioning scale better for larger numbers of partitions Kato, Sho 09:08
Re: Problem on pg_dump RANGE partition with expressions 📎 Yugo Nagata 09:45
Re: Temporary WAL segments files not cleaned up after an instance crash Yugo Nagata 09:50
function lca('{}'::ltree[]) caused DB Instance crash 📎 李海龙 10:09
Re: TupleTableSlot abstraction 📎 Ashutosh Bapat 10:15
Re: function lca('{}'::ltree[]) caused DB Instance crash 📎 Pierre Ducroquet 10:48
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 11:19
Re: automatic restore point Michael Paquier 12:18
Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Oliver Ford 12:52
Re: patch to allow disable of WAL recycling Jerry Jelinek 13:09
Re: How to make partitioning scale better for larger numbers of partitions Ashutosh Bapat 13:10
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Ashutosh Bapat 13:36
Re: Fix some error handling for read() and errno 📎 Michael Paquier 13:38
Re: file cloning in pg_upgrade and CREATE DATABASE Michael Paquier 13:40
Re: GiST VACUUM Andrey Borodin 13:41
Re: Vacuum: allow usage of more than 1GB of work mem Heikki Linnakangas 13:44
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Ashutosh Bapat 13:50
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 14:05
Re: GiST VACUUM Heikki Linnakangas 14:10
Re: GiST VACUUM Heikki Linnakangas 14:25
Re: function lca('{}'::ltree[]) caused DB Instance crash Tom Lane 14:26
Re: [PATCH] Include application_name in "connection authorized" log message Stephen Frost 14:37
Re: [PATCH] Include application_name in "connection authorized" log message Don Seiler 15:13
Re: Fix some error handling for read() and errno Alvaro Herrera 15:31
Finding database for pg_upgrade missing library Bruce Momjian 16:28
Re: Generating partitioning tuple conversion maps faster Heikki Linnakangas 16:57
Re: Problem with tupdesc in jsonb_to_recordset Tom Lane 17:22
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 17:27
Re: Cannot dump foreign key constraints on partitioned table Alvaro Herrera 17:28
Re: [HACKERS] PATCH: Keep one postmaster monitoring pipe per process Heikki Linnakangas 17:34
Re: requested timeline ... does not contain minimum recovery point ... Christophe Pettus 18:06
Re: [PATCH] Include application_name in "connection authorized" log message 📎 Don Seiler 18:20
Re: GiST VACUUM 📎 Andrey Borodin 18:28
Re: pgsql: Fix parallel index and index-only scans to fall back to serial. Heikki Linnakangas 19:22
Logical decoding from promoted standby with same replication slot Jeremy Finzel 19:30
Re: [HACKERS] Client Connection redirection support for PostgreSQL Heikki Linnakangas 20:00
Re: [HACKERS] Client Connection redirection support for PostgreSQL Andres Freund 20:05
Re: [HACKERS] Client Connection redirection support for PostgreSQL Dave Cramer 20:20
Re: GiST VACUUM Heikki Linnakangas 20:28
Re: Vacuum: allow usage of more than 1GB of work mem Andrew Dunstan 20:43
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Tom Lane 20:54
Re: [PATCH] LLVM tuple deforming improvements Andres Freund 21:08
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case 📎 Alvaro Herrera 21:11
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 David G. Johnston 21:17
Re: [WIP PATCH] Index scan offset optimisation using visibility map Heikki Linnakangas 21:17
Re: pgsql: Fix parallel index and index-only scans to fall back to serial. David G. Johnston 21:19
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Tom Lane 21:23
Re: [HACKERS] [PATCH] kNN for SP-GiST 📎 Nikita Glukhov 21:31
Re: pgsql: Fix parallel index and index-only scans to fall back to serial. Robert Haas 21:56
Re: pgsql: Add wait event for fsync of WAL segments Robert Haas 21:57
Fwd: GSOC 2018 Project - A New Sorting Routine Kefan Yang 22:04
Re: GSOC 2018 Project - A New Sorting Routine Peter Geoghegan 22:10
Re: Finding database for pg_upgrade missing library Daniel Gustafsson 22:14
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Andrew Dunstan 22:16
Re: function lca('{}'::ltree[]) caused DB Instance crash Tom Lane 22:50
Re: Generating partitioning tuple conversion maps faster David Rowley 23:25
Re: Fix some error handling for read() and errno Michael Paquier 23:47

July 14, 2018

Thread Author Time
Re: [PATCH] LLVM tuple deforming improvements 📎 Pierre Ducroquet 00:00
Re: Fwd: GSOC 2018 Project - A New Sorting Routine Tomas Vondra 01:03
Re: Fwd: GSOC 2018 Project - A New Sorting Routine Peter Geoghegan 01:24
Re: Finding database for pg_upgrade missing library Justin T Pryzby 03:15
Re: [HACKERS] Small patch for pg_basebackup argument parsing Alvaro Herrera 04:28
Re: Fix some error handling for read() and errno Alvaro Herrera 04:50
Re: Fix some error handling for read() and errno 📎 Michael Paquier 06:37
Re: GiST VACUUM Andrey Borodin 07:26
Re: missing toast table for pg_policy 📎 John Naylor 08:47
Re: assert in nested SQL procedure call in current HEAD Peter Eisentraut 08:59
Re: psql \df option for procedures 📎 Peter Eisentraut 10:20
Re: GiST VACUUM Heikki Linnakangas 10:39
Re: make installcheck-world in a clean environment Peter Eisentraut 10:57
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Peter Eisentraut 11:14
Re: Segfault logical replication PG 10.4 Peter Eisentraut 11:15
Re: missing toast table for pg_policy Michael Paquier 12:13
Re: [PATCH] pg_hba.conf : new auth option : clientcert=verify-full 📎 Julian Markwort 12:47
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Tom Lane 14:29
Re: Costing bug in hash join logic for semi joins Tom Lane 16:04
Re: GiST VACUUM 📎 Andrey Borodin 17:43
YA race condition in 001_stream_rep.pl (was Re: pgsql: Allow using the updated tuple while moving it to a different par) 📎 Tom Lane 18:16
Re: GSOC 2018 Project - A New Sorting Routine Tomas Vondra 21:20
Re: [HACKERS] plpgsql - additional extra checks Tomas Vondra 23:38

July 15, 2018

Thread Author Time
Re: Speeding up INSERTs and UPDATEs to partitioned tables David Rowley 08:34
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 09:36
Re: make installcheck-world in a clean environment Alexander Lakhin 10:32
Re: New GUC to sample log queries Vik Fearing 10:53
Re: YA race condition in 001_stream_rep.pl (was Re: pgsql: Allow using the updated tuple while moving it to a different par) Amit Kapila 11:09
Re: Allow to specify a index name as ANALYZE parameter Vik Fearing 11:10
Re: [HACKERS] [PATCH] kNN for SP-GiST Andrey Borodin 11:54
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 13:29
Re: [HACKERS] Removing LEFT JOINs in more cases 📎 David Rowley 13:42
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 14:43
Re: why partition pruning doesn't work? 📎 Tom Lane 17:02
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Dmitry Dolgov 17:43
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Tom Lane 18:55
Re: Usage of epoch in txid_current Tom Lane 20:41
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 22:16
Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)" 📎 Tom Lane 22:48

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