pgsql-hackers since 2018-07-10 13:50

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

Thread Author Time
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Ashutosh Bapat 13:50
Re: Non-reserved replication slots and slot advancing Alvaro Herrera 13:51
Re: [HACKERS] PoC: full merge join on comparison clause Ashutosh Bapat 13:54
Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX Tom Lane 13:54
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Heikki Linnakangas 14:35
Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX Dilip Kumar 15:44
Re: [HACKERS] PoC: full merge join on comparison clause 📎 Alexander Kuzmenkov 16:36
Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX Andrey Borodin 16:37
Re: Let's remove DSM_IMPL_NONE. Peter Eisentraut 16:52
Re: [HACKERS] [PATCH] kNN for SP-GiST Andrey Borodin 17:09
Re: [HACKERS] plpgsql - additional extra checks Pavel Stehule 17:16
Re: [PATCH] Timestamp for a XLOG_BACKUP_END WAL-record Fujii Masao 17:26
_isnan() on Windows 📎 Emre Hasegeli 17:36
Re: [PATCH] Improve geometric types 📎 Emre Hasegeli 17:36
Re: _isnan() on Windows Alvaro Herrera 17:51
performance statistics monitoring without spamming logs Patrick Hemmer 17:54
Re: no partition pruning when partitioning using array type Alvaro Herrera 18:05
Re: no partition pruning when partitioning using array type Alvaro Herrera 18:18
Re: no partition pruning when partitioning using array type Tom Lane 18:30
Re: New GUC to sample log queries 📎 Adrien Nayrat 18:34
Re: performance statistics monitoring without spamming logs Justin Pryzby 18:38
Re: Desirability of client-side expressions in psql? Corey Huinker 18:46
Re: user-friendliness improvement of pageinspect Peter Geoghegan 18:48
Re: Allow COPY's 'text' format to output a header 📎 Simon Muller 18:51
Re: Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Heikki Linnakangas 19:03
Re: Failure assertion in GROUPS mode of window function in current HEAD 📎 Tom Lane 19:21
Re: no partition pruning when partitioning using array type Alvaro Herrera 19:48
Re: no partition pruning when partitioning using array type Alvaro Herrera 19:50
Re: no partition pruning when partitioning using array type Alvaro Herrera 19:53
Re: _isnan() on Windows Tom Lane 19:55
Re: _isnan() on Windows Alvaro Herrera 20:07
Re: GiST VACUUM Heikki Linnakangas 20:07
Re: patch to allow disable of WAL recycling Jerry Jelinek 20:15
Re: _isnan() on Windows Tom Lane 20:23
Re: patch to allow disable of WAL recycling Joshua D. Drake 20:25
Re: patch to allow disable of WAL recycling Alvaro Herrera 20:34
Problem with tupdesc in jsonb_to_recordset 📎 Dmitry Dolgov 20:39
Re: cost_sort() improvements Tomas Vondra 20:56
GSOC 2018 Project - A New Sorting Routine 📎 Kefan Yang 21:02
Re: Optimze usage of immutable functions as relation Heikki Linnakangas 21:25
Re: Jsonb transform for pl/python Tom Lane 21:29
Re: Optimze usage of immutable functions as relation Tom Lane 21:34
Re: Desirability of client-side expressions in psql? Fabien COELHO 21:36
CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Tom Lane 22:31
possible issue with array type created for every heap relation composite type 📎 Jimmy Yih 22:33
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Alvaro Herrera 22:44
Re: possible issue with array type created for every heap relation composite type Tom Lane 22:53
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Tom Lane 22:58
Re: Non-reserved replication slots and slot advancing Michael Paquier 23:58

July 11, 2018

Thread Author Time
Re: shared-memory based stats collector Andres Freund 00:06
TRUNCATE tables referenced by FKs on partitioned tables Alvaro Herrera 00:06
Shared buffer access rule violations? Asim R P 00:15
Re: no partition pruning when partitioning using array type Amit Langote 00:26
Re: Concurrency bug in UPDATE of partition-key Alvaro Herrera 00:29
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 00:34
Re: _isnan() on Windows Michael Paquier 00:37
Re: no partition pruning when partitioning using array type Amit Langote 00:41
RE: How can we submit code patches that implement our (pending) patents? Tsunakawa, Takayuki 01:03
Re: Excessive PostmasterIsAlive calls slow down WAL redo Thomas Munro 01:16
回复： user-friendliness improvement of pageinspect Yang Jie 01:44
Re: Speeding up INSERTs and UPDATEs to partitioned tables David Rowley 01:47
Re: user-friendliness improvement of pageinspect Peter Geoghegan 01:51
Re: user-friendliness improvement of pageinspect Yang Jie 01:55
Re: no partition pruning when partitioning using array type Amit Langote 01:55
Re: [HACKERS] SERIALIZABLE with parallel query Masahiko Sawada 01:58
Re: user-friendliness improvement of pageinspect Peter Geoghegan 02:08
RE: ON CONFLICT DO NOTHING on pg_dump Ideriha, Takeshi 02:20
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 03:26
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Michael Paquier 03:32
Re: Shared buffer access rule violations? Tom Lane 03:33
Re: no partition pruning when partitioning using array type Alvaro Herrera 04:12
Re: Tips on committing Noah Misch 04:14
Re: Concurrency bug in UPDATE of partition-key 📎 Amit Kapila 04:18
Re: Concurrency bug in UPDATE of partition-key Amit Khandekar 04:34
Re: no partition pruning when partitioning using array type 📎 Amit Langote 04:34
Re: patch to allow disable of WAL recycling Thomas Munro 05:32
Preferring index-only-scan when the cost is equal 📎 Yugo Nagata 05:33
Re: [HACKERS] Restricting maximum keep segments by repslots Masahiko Sawada 06:09
RE: automatic restore point Yotsunaga, Naoki 06:11
Re: Problem with tupdesc in jsonb_to_recordset Michael Paquier 06:27
Re: automatic restore point Michael Paquier 06:33
In pageinspect, perform clean-up after testing gin-related functions 📎 Kuntal Ghosh 07:07
Re: TRUNCATE tables referenced by FKs on partitioned tables Michael Paquier 07:16
Re: In pageinspect, perform clean-up after testing gin-related functions Amit Kapila 07:26
Re: Problem with tupdesc in jsonb_to_recordset 📎 Michael Paquier 07:39
Re: How can we submit code patches that implement our (pending) patents? Dave Page 07:49
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 07:53
RE: Typo in Japanese translation of psql. Taiki Kondo 07:58
Re: Libpq support to connect to standby server as priority 📎 Haribabu Kommi 08:00
Re: Excessive PostmasterIsAlive calls slow down WAL redo Heikki Linnakangas 08:10
Allow to specify a index name as ANALYZE parameter 📎 Yugo Nagata 09:04
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 09:06
Negotiating the SCRAM channel binding type Heikki Linnakangas 09:27
Re: Problem with tupdesc in jsonb_to_recordset Dmitry Dolgov 09:33
partition pruning doesn't work with IS NULL clause in multikey range partition case Ashutosh Bapat 09:36
Cannot dump foreign key constraints on partitioned table amul sul 10:19
Re: Negotiating the SCRAM channel binding type Bruce Momjian 10:31
Re: Problem with tupdesc in jsonb_to_recordset Andrew Gierth 10:38
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Dilip Kumar 10:50
Re: Jsonb transform for pl/python Alexander Korotkov 10:52
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 11:02
Re: Allow to specify a index name as ANALYZE parameter Alexander Korotkov 11:26
Re: Preferring index-only-scan when the cost is equal Ashutosh Bapat 11:28
Re: Problem with tupdesc in jsonb_to_recordset Michael Paquier 11:30
Re: Negotiating the SCRAM channel binding type Michael Paquier 11:37
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case 📎 Dilip Kumar 11:40
Re: Negotiating the SCRAM channel binding type Heikki Linnakangas 12:01
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case amul sul 12:06
Re: patch to allow disable of WAL recycling Jerry Jelinek 12:37
Re: Preferring index-only-scan when the cost is equal Tomas Vondra 12:37
Re: partition pruning doesn't work with IS NULL clause in multikey range partition case Dilip Kumar 12:39
Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Haribabu Kommi 12:46
Re: Negotiating the SCRAM channel binding type Heikki Linnakangas 13:00
Re: Add function to release an allocated SQLDA Thomas Munro 13:01
Re: _isnan() on Windows Alvaro Herrera 13:13
Re: Concurrency bug in UPDATE of partition-key Alvaro Herrera 13:16
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Fabien COELHO 13:24
Re: Speeding up INSERTs and UPDATEs to partitioned tables Alvaro Herrera 13:29
Re: [HACKERS] Two pass CheckDeadlock in contentent case Ashutosh Bapat 14:01
Re: [HACKERS] GnuTLS support Heikki Linnakangas 14:21
Re: Negotiating the SCRAM channel binding type Bruce Momjian 14:23
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 14:52
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 14:56
Re: How can we submit code patches that implement our (pending) patents? Nico Williams 14:59
Re: [PATCH] btree_gist: fix union implementation for variable length columns Pavel Raiskup 15:40
Re: GiST VACUUM Andrey Borodin 16:04
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 16:09
Re: In pageinspect, perform clean-up after testing gin-related functions Andres Freund 17:02
Re: cursors with prepared statements 📎 Heikki Linnakangas 17:07
Costing bug in hash join logic for semi joins RK Korlapati 17:09
Re: [PATCH] Improve geometric types 📎 Emre Hasegeli 17:13
Re: [PATCH] btree_gist: fix union implementation for variable length columns Tom Lane 17:26
Re: no partition pruning when partitioning using array type Alvaro Herrera 17:33
Re: In pageinspect, perform clean-up after testing gin-related functions Tom Lane 17:34
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Alvaro Herrera 17:49
Re: [PATCH] Add missing type conversion functions for PL/Python Heikki Linnakangas 18:03
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Alvaro Herrera 18:04
Re: [PATCH] btree_gist: fix union implementation for variable length columns Pavel Raiskup 18:24
Re: Shared buffer access rule violations? Asim R P 18:31
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Nico Williams 18:41
Shouldn't validateForeignKeyConstraint() reset memory context? Andres Freund 18:56
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Alvaro Herrera 19:13
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Fabien COELHO 19:34
Re: make installcheck-world in a clean environment Tom Lane 20:15
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints 📎 Nico Williams 21:10
Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Thomas Munro 22:31
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Tom Lane 22:52
Segfault logical replication PG 10.4 Mai Peng 22:56
Re: TRUNCATE tables referenced by FKs on partitioned tables 📎 Alvaro Herrera 22:59
Re: ERROR: cannot start subtransactions during a parallel operation Mai Peng 23:02
Re: [HACKERS] autovacuum can't keep up, bloat just continues to rise Peter Geoghegan 23:08
Re: Tips on committing Peter Geoghegan 23:35

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

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