pgsql-hackers since 2018-07-12 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: Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Haribabu Kommi 00:19
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 00:20
Re: patch to allow disable of WAL recycling David Pacheco 00:25
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 00:29
Re: patch to allow disable of WAL recycling Andres Freund 00:29
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 00:34
Re: patch to allow disable of WAL recycling David Pacheco 00:35
Re: Costing bug in hash join logic for semi joins David Rowley 00:50
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Nico Williams 00:50
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints 📎 Nico Williams 00:55
Upper limit arguments of pg_logical_slot_xxx_changes functions accept invalid values 📎 Masahiko Sawada 00:58
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 01:10
Re: Allow to specify a index name as ANALYZE parameter Yugo Nagata 01:17
Re: [HACKERS] Replication status in logical replication Michael Paquier 01:22
Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS) David Rowley 01:28
Re: How can we submit code patches that implement our (pending) patents? Craig Ringer 01:33
Re: Preferring index-only-scan when the cost is equal Yugo Nagata 01:44
pread() and pwrite() 📎 Thomas Munro 01:55
Re: [HACKERS] Replication status in logical replication Masahiko Sawada 01:58
Re: Failure assertion in GROUPS mode of window function in current HEAD 📎 Masahiko Sawada 02:06
Re: _isnan() on Windows Michael Paquier 02:16
bgworkers should share more of BackendRun / PostgresMain Craig Ringer 02:34
Re: TRUNCATE tables referenced by FKs on partitioned tables Michael Paquier 02:53
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 03:19
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 03:32
Re: Cannot dump foreign key constraints on partitioned table 📎 Michael Paquier 03:48
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 04:07
Re: Negotiating the SCRAM channel binding type Michael Paquier 04:14
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 04:38
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case 📎 Amit Langote 05:32
Re: Add SKIP LOCKED to VACUUM and ANALYZE Michael Paquier 05:37
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case 📎 Amit Langote 05:40
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Dilip Kumar 06:09
Re: Temporary WAL segments files not cleaned up after an instance crash Yugo Nagata 06:35
Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX 📎 Yugo Nagata 06:58
Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX Yugo Nagata 07:20
pgsql: Allow using the updated tuple while moving it to a different par Amit Kapila 07:33
Re: Temporary WAL segments files not cleaned up after an instance crash 📎 Michael Paquier 07:44
Re: Possible bug in logical replication. Michael Paquier 07:47
Re: In pageinspect, perform clean-up after testing gin-related functions Amit Kapila 07:52
Re: pgsql: Allow using the updated tuple while moving it to a different par Michael Paquier 07:59
Problem on pg_dump RANGE partition with expressions Yugo Nagata 07:59
Binary difference in pg_internal.init after running pg_initdb multiple times samuel.coulee 08:08
Re: [PATCH] Add missing type conversion functions for PL/Python Haozhou Wang 08:12
Re: Negotiating the SCRAM channel binding type Heikki Linnakangas 08:26
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 08:28
Re: Problem on pg_dump RANGE partition with expressions Amit Langote 08:44
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 08:57
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation 📎 Amit Langote 08:59
Re: Negotiating the SCRAM channel binding type Michael Paquier 09:06
Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan 📎 Pavel Stehule 09:12
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 09:15
Re: no partition pruning when partitioning using array type Amit Langote 09:21
Re: Negotiating the SCRAM channel binding type Heikki Linnakangas 09:34
Re: buildfarm vs code Heikki Linnakangas 09:54
pg_create_logical_replication_slot returns text instead of name 📎 Masahiko Sawada 10:00
Re: Temporary WAL segments files not cleaned up after an instance crash Heikki Linnakangas 10:15
Re: [HACKERS] plpgsql - additional extra checks 📎 Pavel Stehule 10:32
Re: ON CONFLICT DO NOTHING on pg_dump 📎 Thomas Munro 10:42
Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan Tatsuro Yamada 10:45
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 10:45
Re: patch to allow disable of WAL recycling Tomas Vondra 10:52
Re: Preferring index-only-scan when the cost is equal Tomas Vondra 10:59
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 11:02
Re: pgsql: Allow using the updated tuple while moving it to a different par Amit Kapila 11:14
Re: missing toast table for pg_policy Peter Eisentraut 11:16
Re: Copy function for logical replication slots 📎 Masahiko Sawada 12:28
Re: make installcheck-world in a clean environment Alexander Lakhin 12:32
Re: Temporary WAL segments files not cleaned up after an instance crash Michael Paquier 12:38
Re: Temporary WAL segments files not cleaned up after an instance crash Heikki Linnakangas 12:40
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Ashutosh Bapat 13:01
Re: Binary difference in pg_internal.init after running pg_initdb multiple times Tomas Vondra 13:02
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Ashutosh Bapat 13:03
Re: Negotiating the SCRAM channel binding type Michael Paquier 13:08
Re: Negotiating the SCRAM channel binding type Michael Paquier 13:10
Re: pg_create_logical_replication_slot returns text instead of name Michael Paquier 13:18
Re: Binary difference in pg_internal.init after running pg_initdb multiple times Tom Lane 13:24
Re: buildfarm vs code Andrew Dunstan 13:31
Re: Vacuum: allow usage of more than 1GB of work mem Andrew Dunstan 13:44
Re: [HACKERS] WAL logging problem in 9.4.3? Andrew Dunstan 13:51
Re: [HACKERS] WAL logging problem in 9.4.3? Heikki Linnakangas 14:12
Re: _isnan() on Windows Tom Lane 14:20
Re: cost_sort() improvements 📎 Teodor Sigaev 14:31
Re: _isnan() on Windows Andrew Dunstan 14:33
Re: _isnan() on Windows Tom Lane 14:38
Re: cost_sort() improvements Teodor Sigaev 14:42
Re: cost_sort() improvements 📎 Teodor Sigaev 14:48
Re: cost_sort() improvements Teodor Sigaev 15:00
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

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