pgsql-hackers since 2017-10-07 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)

Browse Archives

Prev | Next

Oct. 7, 2017

Thread Author Time
Discussion on missing optimizations Adam Brusselback 01:33
Re: Discussion on missing optimizations Andres Freund 01:48
Re: Discussion on missing optimizations Tom Lane 02:19
Re: Discussion on missing optimizations Andres Freund 02:38
Re: [PATCH] A hook for session start Pavel Stehule 03:44
Re: [PATCH] A hook for session start Nico Williams 04:49
Re: [PATCH] A hook for session start Pavel Stehule 04:53
dead or outdated URLs found in win32.h Ashutosh Sharma 05:01
Re: On markers of changed data Michael Paquier 07:35
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple 📎 Alvaro Herrera 08:31
Re: On markers of changed data Alvaro Herrera 08:35
Re: parallel worker (PID ) exited with exit code 1 Andreas Seltenreich 10:00
Predicate Locks for writes? Simon Riggs 11:26
Re: [POC] hash partitioning amul sul 11:52
Re: separate serial_schedule useful? Robert Haas 13:19
Re: Discussion on missing optimizations 📎 Petr Jelinek 13:21
Re: Issue with logical replication: MyPgXact->xmin already is valid Petr Jelinek 13:26
Re: On markers of changed data Stephen Frost 13:34
Re: Proposal: Local indexes for partitioned table Robert Haas 13:34
Re: parallelize queries containing initplans Robert Haas 13:52
Re: separate serial_schedule useful? Tom Lane 14:23
Re: Discussion on missing optimizations David Rowley 15:15
Re: Discussion on missing optimizations 📎 Tom Lane 16:15
Re: Proposal: Local indexes for partitioned table Maksim Milyutin 16:15
Re: Discussion on missing optimizations Tom Lane 16:19
Re: Issue with logical replication: MyPgXact->xmin already is valid Konstantin Knizhnik 16:23
Re: separate serial_schedule useful? 📎 Tom Lane 16:49
Re: Issue with logical replication: MyPgXact->xmin already is valid Petr Jelinek 17:08
Re: Discussion on missing optimizations Petr Jelinek 17:18
Re: Discussion on missing optimizations Tom Lane 17:59
Help required to debug pg_repack breaking logical replication Daniele Varrazzo 18:37
Slow synchronous logical replication konstantin knizhnik 19:39
Re: Slow synchronous logical replication Andres Freund 19:42
Re: Slow synchronous logical replication Konstantin Knizhnik 19:58
Re: Discussion on missing optimizations Nico Williams 20:40
Re: Horrible CREATE DATABASE Performance in High Sierra 📎 Tom Lane 20:46
Re: Discussion on missing optimizations Petr Jelinek 21:22
Prepared statements assume text type in PG10 Jack Christensen 21:56
Re: tablespaces inside $PGDATA considered harmful Mark Kirkwood 22:10
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Peter Geoghegan 23:22
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Alvaro Herrera 23:25
Re: Prepared statements assume text type in PG10 Peter Geoghegan 23:27
Re: Prepared statements assume text type in PG10 Peter Geoghegan 23:31

Oct. 8, 2017

Thread Author Time
Re: Prepared statements assume text type in PG10 Tom Lane 00:23
Re: On markers of changed data Andrey Borodin 07:52
Re: Slow synchronous logical replication Craig Ringer 13:00
Re: Help required to debug pg_repack breaking logical replication Craig Ringer 13:21
Re: On markers of changed data Stephen Frost 15:11
Re: Discussion on missing optimizations Adam Brusselback 15:17
Re: Discussion on missing optimizations Tom Lane 15:28
Re: Discussion on missing optimizations Andres Freund 16:18
Re: Discussion on missing optimizations Tom Lane 16:24
is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 16:36
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Andres Freund 16:44
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 16:51
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 16:57
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Andres Freund 16:59
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 17:04
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 17:10
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 17:23
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Peter Geoghegan 17:29
Re: search path security issue? Joe Conway 18:34
Re: Discussion on missing optimizations Tom Lane 21:11
Re: Discussion on missing optimizations Andres Freund 21:20

Oct. 9, 2017

Thread Author Time
Re: is possible cache tupledesc templates in execution plan? significant performance issue, maybe bug? Pavel Stehule 04:07
Re: Discussion on missing optimizations 📎 David Rowley 04:41
Re: Discussion on missing optimizations 📎 David Rowley 04:47
Re: On markers of changed data Andrey Borodin 05:23
Re: Partition-wise join for join between (declaratively) partitioned tables 📎 Ashutosh Bapat 06:05
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Wood, Dan 06:11
Re: Slow synchronous logical replication Konstantin Knizhnik 07:37
Re: parallelize queries containing initplans 📎 Amit Kapila 09:56
Re: Parallel Append implementation Amit Kapila 10:33
Re: Proposal: Local indexes for partitioned table Ashutosh Bapat 10:35
Re: separate serial_schedule useful? Ashutosh Bapat 10:42
Re: PoC: full merge join on comparison clause Ashutosh Bapat 10:47
Re: [POC] hash partitioning 📎 amul sul 11:14
Re: Partition-wise aggregation/grouping 📎 Jeevan Chalke 12:10
Re: [POC] hash partitioning Ashutosh Bapat 12:21
Re: Predicate Locks for writes? Alexander Korotkov 12:23
Re: On markers of changed data Michael Paquier 12:28
Latches API on windows Abbas Butt 13:26
Re: GSoC 2017 : Patch for predicate locking in Gist index Alexander Korotkov 13:27
oversight in EphemeralNamedRelation support 📎 Julien Rouhaud 13:35
Re: Latches API on windows Craig Ringer 13:47
Re: Latches API on windows Tom Lane 13:56
Re: Latches API on windows Abbas Butt 13:59
Re: Latches API on windows Andres Freund 14:00
Re: Discussion on missing optimizations Ants Aasma 14:08
10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Aleksander Alekseev 14:13
Re: Pluggable storage Alexander Korotkov 14:22
Re: Pluggable storage Tom Lane 14:32
Re: Additional logging for VACUUM and ANALYZE 📎 Bossart, Nathan 14:52
Re: Pluggable storage Alexander Korotkov 15:15
Re: On markers of changed data Andrey Borodin 16:54
Unnecessary complexity around CurrentResourceOwner changes? Tom Lane 16:58
Columnar storage support legrand legrand 20:03
Re: Columnar storage support Joshua D. Drake 20:06
Re: Columnar storage support Jaime Casanova 20:23
Re: oversight in EphemeralNamedRelation support Thomas Munro 20:43
Re: oversight in EphemeralNamedRelation support 📎 Julien Rouhaud 21:13
Re: Partition-wise aggregation/grouping David Rowley 21:45
Re: Support to COMMENT ON DATABASE CURRENT_DATABASE Jing Wang 23:57

Oct. 10, 2017

Thread Author Time
heap/SLRU verification, relfrozenxid cut-off, and freeze-the-dead bug (Was: amcheck (B-Tree integrity checking tool)) Peter Geoghegan 00:19
Re: search path security issue? Fabrízio de Royes Mello 00:45
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Michael Paquier 01:00
Re: Issues with logical replication 📎 Stas Kelvich 01:19
Re: On markers of changed data Peter Geoghegan 01:31
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Masahiko Sawada 02:29
Fix a typo in execReplication.c 📎 Masahiko Sawada 02:59
Extended statistics is not working on Vars hidden under a RelabelType 📎 David Rowley 03:03
Re: Partition-wise aggregation/grouping Ashutosh Bapat 04:57
Re: Partition-wise aggregation/grouping Jeevan Chalke 06:07
Omission in GRANT documentation 📎 Laurenz Albe 07:34
Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger 📎 Masahiko Sawada 07:53
Re: Partition-wise aggregation/grouping David Rowley 08:01
Re: Columnar storage support Konstantin Knizhnik 08:05
Re: Parallel tuplesort (for parallel B-Tree index creation) 📎 Rushabh Lathia 09:23
Re: GUC for cleanup indexes threshold. Pavel Golub 09:55
Re: Partition-wise aggregation/grouping Ashutosh Bapat 10:00
Re: [POC] hash partitioning 📎 amul sul 10:02
Re: [POC] hash partitioning amul sul 10:10
Re: [POC] hash partitioning Ashutosh Bapat 10:12
Re: [POC] hash partitioning Ashutosh Bapat 10:13
Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger 📎 Aleksander Alekseev 10:26
More stats about skipped vacuums Kyotaro HORIGUCHI 10:26
Re: [POC] hash partitioning 📎 amul sul 11:07
Re: [JDBC] Channel binding support for SCRAM-SHA-256 📎 Michael Paquier 13:12
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Petr Jelinek 13:25
How does postgres store the join predicate for a relation in a given query Gourav Kumar 13:59
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Alvaro Herrera 14:14
Re: Proposal: Local indexes for partitioned table Alvaro Herrera 15:22
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Aleksander Alekseev 15:22
Re: How does postgres store the join predicate for a relation in a given query Nico Williams 17:51
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Petr Jelinek 19:54
Re: Help required to debug pg_repack breaking logical replication Petr Jelinek 20:34
Re: On markers of changed data Greg Stark 20:43
Re: Extended statistics is not working on Vars hidden under a RelabelType Tomas Vondra 20:45
Re: On markers of changed data Alvaro Herrera 22:35
Re: On markers of changed data Stephen Frost 22:50

Oct. 11, 2017

Thread Author Time
Re: Is it time to kill support for very old servers? Andres Freund 00:39
pg_regress help output 📎 Joe Conway 01:06
Re: Is it time to kill support for very old servers? Michael Paquier 01:09
Re: Is it time to kill support for very old servers? Andres Freund 01:14
Re: Is it time to kill support for very old servers? Michael Paquier 01:40
Re: Is it time to kill support for very old servers? Andres Freund 01:46
Re: Is it time to kill support for very old servers? Michael Paquier 01:51
BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much marko 02:00
Re: pg_regress help output Tom Lane 02:06
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Michael Paquier 02:25
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Wood, Dan 02:31
Re: pg_regress help output Joe Conway 02:31
Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple Michael Paquier 02:35
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns 📎 Andres Freund 03:19
Re: show precise repos version for dev builds? Jeremy Schneider 03:44
Re: pg_regress help output Alvaro Herrera 04:03
Re: How does postgres store the join predicate for a relation in a given query Ashutosh Bapat 06:30
Re: Slow synchronous logical replication Masahiko Sawada 06:43
Re: Slow synchronous logical replication Craig Ringer 07:07
Re: parallelize queries containing initplans tushar 07:12
Re: utility commands benefiting from parallel plan Haribabu Kommi 07:30
Re: show precise repos version for dev builds? Craig Ringer 08:19
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns Alvaro Herrera 08:53
[PATCH] Lockable views 📎 Yugo Nagata 09:36
BUG #14850: Implement optinal additinal parameter for 'justify' date/time function kes-kes 10:35
performance drop after upgrade (9.6 > 10) johannes graën 11:06
Re: On markers of changed data Greg Stark 11:07
Re: advanced partition matching algorithm for partition-wise join 📎 Ashutosh Bapat 11:08
Re: performance drop after upgrade (9.6 > 10) Pavel Stehule 11:11
Re: Parallel Hash take II Prabhat Sahu 11:55
Re: performance drop after upgrade (9.6 > 10) johannes graën 12:19
Re: Parallel Append implementation 📎 Amit Khandekar 12:51
Re: Is it time to kill support for very old servers? Robert Haas 13:28
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Pavel Stehule 14:11
Re: Partition-wise join for join between (declaratively) partitioned tables Robert Haas 14:17
Re: [PATCH] A hook for session start Robert Haas 14:28
Re: Predicate Locks for writes? Robert Haas 14:33
Re: pg_regress help output Tom Lane 14:38
Re: [PATCH] Add ALWAYS DEFERRED option for constraints Nico Williams 14:53
pgsql: Add port/strnlen support to libpq and ecpg Makefiles. Tom Lane 15:28
Re: pgsql: Add port/strnlen support to libpq and ecpg Makefiles. Andres Freund 15:49
Re: Discussion on missing optimizations Robert Haas 15:50
Re: Predicate Locks for writes? Simon Riggs 15:51
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns Andres Freund 15:54
Re: parallelize queries containing initplans Robert Haas 15:54
Re: pgsql: Add port/strnlen support to libpq and ecpg Makefiles. Tom Lane 15:58
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns Alvaro Herrera 16:05
Re: pgsql: Add port/strnlen support to libpq and ecpg Makefiles. Andres Freund 16:12
Re: Predicate Locks for writes? Robert Haas 16:27
Re: [COMMITTERS] pgsql: Add port/strnlen support to libpq and ecpg Makefiles. Tom Lane 16:32
Re: Slow synchronous logical replication Andres Freund 16:38
Re: Partition-wise aggregation/grouping Robert Haas 16:42
Re: Slow synchronous logical replication Konstantin Knizhnik 16:57
Re: Proposal: Local indexes for partitioned table Robert Haas 17:58
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns Andres Freund 18:47
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns Robert Haas 19:36
Re: Fix a typo in execReplication.c Robert Haas 20:02
Re: Pluggable storage Robert Haas 20:08
Re: show precise repos version for dev builds? Jeremy Schneider 20:28
Re: Pluggable storage Peter Geoghegan 20:54

Browse Archives

Prev | Next