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

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
Re: Omission in GRANT documentation	Tom Lane	20:58
Re: [HACKERS] Re: BUG #14821: idle_in_transaction_session_timeout sometimes gets ignored when statement timeout is pending	Andres Freund	21:11
Re: Windows warnings from VS 2017	Andres Freund	21:28
Re: SendRowDescriptionMessage() is slow for queries with a lot of columns	Andres Freund	22:04
Re: Windows warnings from VS 2017 📎	Tom Lane	22:20
Re: [HACKERS] Re: BUG #14821: idle_in_transaction_session_timeout sometimes gets ignored when statement timeout is pending	Lukas Fittl	22:23
Re: show precise repos version for dev builds?	Peter Eisentraut	22:46
Re: Fix a typo in execReplication.c 📎	Masahiko Sawada	22:52
replace GrantObjectType with ObjectType 📎	Peter Eisentraut	22:55
Re: Is it time to kill support for very old servers?	Michael Paquier	23:11
pgsql: Add configure infrastructure to detect support for C99's restric	Andres Freund	23:11
Re: [PATCH] Lockable views	Tatsuo Ishii	23:50

Oct. 12, 2017

Thread	Author	Time
Re: 64-bit queryId?	Robert Haas	00:05
Re: pgsql: Add configure infrastructure to detect support for C99's restric	Andres Freund	00:13
pgsql: Improve performance of SendRowDescriptionMessage.	Andres Freund	00:28
Re: 64-bit queryId?	Michael Paquier	00:46
Re: [POC] hash partitioning	Robert Haas	01:01
Re: Slow synchronous logical replication	Craig Ringer	01:23
Re: show precise repos version for dev builds?	Craig Ringer	01:27
Re: [POC] hash partitioning	Amit Langote	01:31
Re: Partition-wise join for join between (declaratively) partitioned tables	Ashutosh Bapat	02:43
Re: show precise repos version for dev builds?	Tom Lane	02:48
Continuous integration on Windows?	Thomas Munro	03:04
Re: [PATCH] Lockable views	Tatsuo Ishii	04:11
Re: Proposal: Improve bitmap costing for lossy pages 📎	Dilip Kumar	04:28
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much	Michael Paquier	04:42
Re: [COMMITTERS] pgsql: Add configure infrastructure to detect support for C99's restric	Andres Freund	04:59
Re: [HACKERS] Re: pgsql: Add configure infrastructure to detect support for C99's restric	Andres Freund	05:05
Re: replace GrantObjectType with ObjectType	Michael Paquier	05:59
Re: Discussion on missing optimizations	Laurenz Albe	07:22
Re: Omission in GRANT documentation	Laurenz Albe	07:27
Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function 📎	KES	08:00
Re: Slow synchronous logical replication 📎	Konstantin Knizhnik	08:09
Re: Slow synchronous logical replication	Konstantin Knizhnik	08:24
Re: replace GrantObjectType with ObjectType	Alvaro Herrera	08:43
Re: Discussion on missing optimizations	Alvaro Herrera	09:05
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function	Arthur Zakirov	09:15
Re: PoC plpgsql - possibility to force custom or generic plan 📎	Pavel Stehule	09:31
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function	KES	10:01
Query started showing wrong result after Ctrl+c	tushar	10:03
Re: Query started showing wrong result after Ctrl+c	Marko Tiikkaja	10:16
Re: Query started showing wrong result after Ctrl+c	tushar	10:38
Re: Fix a typo in execReplication.c	Petr Jelinek	10:55
Parallel Bitmap Heap Scans segfaults due to (tbm->dsa==NULL) on PostgreSQL 10 📎	Tomas Vondra	11:01
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much	Andrew Dunstan	12:38
Re: Parallel Bitmap Heap Scans segfaults due to (tbm->dsa==NULL) on PostgreSQL 10 📎	Dilip Kumar	12:40
Re: Parallel Bitmap Heap Scans segfaults due to (tbm->dsa==NULL) on PostgreSQL 10	Tomas Vondra	13:07
Re: [POC] hash partitioning	amul sul	13:08
Re: Parallel Bitmap Heap Scans segfaults due to (tbm->dsa==NULL) on PostgreSQL 10	Dilip Kumar	13:14
Re: Extended statistics is not working on Vars hidden under a RelabelType 📎	Alvaro Herrera	13:17
Re: Extended statistics is not working on Vars hidden under a RelabelType	David Rowley	13:43
BLK_DONE state in XLogReadBufferForRedoExtended	Amit Kapila	13:47
Re: Discussion on missing optimizations	Tom Lane	14:00
Re: [POC] hash partitioning	Robert Haas	14:05
Re: Discussion on missing optimizations	Robert Haas	14:06
Re: Query started showing wrong result after Ctrl+c	Tom Lane	14:14
Re: Discussion on missing optimizations	David Rowley	14:27
Re: Fix a typo in execReplication.c	Robert Haas	14:30
Re: Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function	Brian Dunavant	14:37
Re: pgsql: Improve performance of SendRowDescriptionMessage.	Tom Lane	14:44
Re: pgsql: Add configure infrastructure to detect support for C99's restric	Tom Lane	15:30
Re: Extended statistics is not working on Vars hidden under a RelabelType	Alvaro Herrera	15:56
Re: GUC for cleanup indexes threshold.	Robert Haas	16:14
Re: advanced partition matching algorithm for partition-wise join	Robert Haas	16:16

Browse Archives

Prev | Next