pgsql-performance - June 2016

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

June 2, 2016

Thread	Author	Time
Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6	Антон Бушмелев	11:18

June 3, 2016

Thread	Author	Time
Re: index fragmentation on insert-only table with non-unique column	Claudio Freire	21:26
slony rpm help slony1-95-2.2.2-1.rhel6.x86_64	avi Singh	23:03
Re: index fragmentation on insert-only table with non-unique column	Justin Pryzby	23:54

June 4, 2016

Thread	Author	Time
Re: index fragmentation on insert-only table with non-unique column	Claudio Freire	02:05
pg_database_size	sangeetha	07:35
Re: pg_database_size	Venkata Balaji N	08:10
Re: index fragmentation on insert-only table with non-unique column	Kevin Grittner	13:39

June 5, 2016

Thread	Author	Time
Re: index fragmentation on insert-only table with non-unique column	Tom Lane	16:03
Re: index fragmentation on insert-only table with non-unique column	Jeff Janes	19:28

June 7, 2016

Thread	Author	Time
Locking concurrency: select for update vs update	Streamsoft - Mirek Szajowski	07:31
Re: Locking concurrency: select for update vs update	Szymon Lipiński	07:35
Re: Locking concurrency: select for update vs update	Streamsoft - Mirek Szajowski	07:38
array size exceeds the maximum allowed (1073741823) when building a json	Nicolas Paris	11:44
Re: array size exceeds the maximum allowed (1073741823) when building a json	David G. Johnston	12:31
Re: array size exceeds the maximum allowed (1073741823) when building a json	Nicolas Paris	12:36
Re: array size exceeds the maximum allowed (1073741823) when building a json	David G. Johnston	12:39
Re: array size exceeds the maximum allowed (1073741823) when building a json	Nicolas Paris	12:42
Re: array size exceeds the maximum allowed (1073741823) when building a json	David G. Johnston	12:58
Re: array size exceeds the maximum allowed (1073741823) when building a json	Josh Berkus	13:03
Re: Locking concurrency: select for update vs update	Tom Lane	13:24
Re: Locking concurrency: select for update vs update	Streamsoft - Mirek Szajowski	13:26
Combination of partial and full indexes	Rafał Gutkowski	13:39
Re: Combination of partial and full indexes	Gerardo Herzig	17:36
Re: array size exceeds the maximum allowed (1073741823) when building a json	Nicolas Paris	19:23

June 8, 2016

Thread	Author	Time
Performance of LIKE/NOT LIKE when used in single query	Ed Felstein	04:57
Re: Performance of LIKE/NOT LIKE when used in single query	David G. Johnston	05:33
Re: array size exceeds the maximum allowed (1073741823) when building a json	Michael Paquier	05:56
Re: array size exceeds the maximum allowed (1073741823) when building a json	Tom Lane	06:04
Re: Combination of partial and full indexes	Rafał Gutkowski	08:52
Re: Combination of partial and full indexes	Rafał Gutkowski	09:01

June 9, 2016

Thread	Author	Time
Re: array size exceeds the maximum allowed (1073741823) when building a json	Merlin Moncure	13:31
Re: array size exceeds the maximum allowed (1073741823) when building a json	Nicolas Paris	13:43
Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64	Glyn Astill	15:32
Re: Performance of LIKE/NOT LIKE when used in single query	Jeff Janes	16:37
Re: array size exceeds the maximum allowed (1073741823) when building a json	Merlin Moncure	20:36
Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6	Andres Freund	22:28

June 10, 2016

Thread	Author	Time
Many-to-many performance problem	Rowan Seymour	13:04
Re: Many-to-many performance problem	Tom Lane	14:13
Re: Many-to-many performance problem	Yves Dorfsman	14:27
Re: Many-to-many performance problem	Tom Lane	15:23
Re: Many-to-many performance problem	Alex Ignatov	16:11

June 12, 2016

Thread	Author	Time
Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6	Vladimir Borodin	21:42
Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6	Andres Freund	21:51

June 13, 2016

Thread	Author	Time
Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6	Vladimir Borodin	18:58

June 14, 2016

Thread	Author	Time
Re: pg_database_size	Jim Nasby	21:00
Re: Clarification on using pg_upgrade	Jim Nasby	21:03
Re: Clarification on using pg_upgrade	Tory M Blue	21:08

June 15, 2016

Thread	Author	Time
Indexes for hashes	Ivan Voras	09:34
Re: Clarification on using pg_upgrade	Glyn Astill	10:14
Re: Indexes for hashes	Torsten Zuehlsdorff	12:45
Re: Indexes for hashes	[email protected]	13:03
Re: Indexes for hashes	Ivan Voras	13:09
Re: Indexes for hashes	[email protected]	13:16
Re: Indexes for hashes	hubert depesz lubaczewski	13:38
Re: Indexes for hashes	Ivan Voras	13:54
Re: Indexes for hashes	julyanto SUTANDANG	13:58
Re: Indexes for hashes	Ivan Voras	14:00
Re: Indexes for hashes	Ivan Voras	14:20
Re: Indexes for hashes	Joshua D. Drake	14:36
Re: Indexes for hashes	[email protected]	14:53
Re: Indexes for hashes	Jeff Janes	15:14
pg_restore seems very slow	Adrian Myers	22:00
Re: pg_restore seems very slow	David G. Johnston	22:08
Re: pg_restore seems very slow	Adrian Myers	23:41

June 16, 2016

Thread	Author	Time
Re: pg_restore seems very slow	Adam Scott	01:43
Index not used	meike.talbach	07:58
Re: Many-to-many performance problem	Rowan Seymour	08:29
Re: Index not used	John Gorman	12:27
Re: Index not used	Tom Lane	15:05
Re: Index not used	David G. Johnston	15:53

June 17, 2016

Thread	Author	Time
9.6 query slower than 9.5.3	Adam Brusselback	01:56
Re: 9.6 query slower than 9.5.3	Tom Lane	02:04
Re: 9.6 query slower than 9.5.3	Adam Brusselback	02:09
Re: 9.6 query slower than 9.5.3	Adam Brusselback	02:14
Re: 9.6 query slower than 9.5.3	Tom Lane	02:45
Re: 9.6 query slower than 9.5.3	Adam Brusselback	03:36
Re: Indexes for hashes	Claudio Freire	03:51
Re: 9.6 query slower than 9.5.3	Tom Lane	03:57
Re: 9.6 query slower than 9.5.3	Adam Brusselback	04:07
Re: Indexes for hashes	julyanto SUTANDANG	04:09
Re: Indexes for hashes	Claudio Freire	04:18
Re: Indexes for hashes	Ivan Voras	08:32
Re: Indexes for hashes	julyanto SUTANDANG	08:48
Re: 9.6 query slower than 9.5.3	Adam Brusselback	15:18
Savepoint and Releasepoint in Logs	e.ratnakar.shetty	15:19
Re: 9.6 query slower than 9.5.3	Tom Lane	15:22

June 19, 2016

Thread	Author	Time
Re: Index not used 📎	meike.talbach	09:59
Re: Savepoint and Releasepoint in Logs	Jeff Janes	16:55

June 20, 2016

Thread	Author	Time
Looking for more Beta Users!	jonescam	14:00

June 22, 2016

Thread	Author	Time
Can't get two index scans	Craig James	16:03
Re: Can't get two index scans	Jeff Janes	18:36

June 23, 2016

Thread	Author	Time
Re: Can't get two index scans	Craig James	04:36
Re: Can't get two index scans	Jeff Janes	15:47
Re: Can't get two index scans	Craig James	19:52

June 25, 2016

Thread	Author	Time
can't explain commit performance win7 vs linux : 8000/s vs 419/s	[email protected]	16:19
Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s	Tom Lane	18:08
Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s	Jeff Janes	19:23
Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s	Imre Samu	22:27

June 27, 2016

Thread	Author	Time
[PERFORM] Cache performance decreases	Suren Arustamyan	11:43

June 28, 2016

Thread	Author	Time
testing - ignore	George Neuner	14:10

June 29, 2016

Thread	Author	Time
Random slow queries	devel.brain99	01:24
pg_xlog dir not getting swept	Niels Kristian Schjødt	10:00
Re: Random slow queries	Kevin Grittner	12:45
Re: Random slow queries	Igor Neyman	14:32
Re: Random slow queries	devel.brain99	18:01
Re: Random slow queries	devel.brain99	18:04
Re: pg_xlog dir not getting swept	Jeff Janes	19:19
Re: Random slow queries	Tom Lane	20:20
Re: Random slow queries	Jeff Janes	21:30
Re: Random slow queries	Tom Lane	21:44

June 30, 2016

Thread	Author	Time
Re: pg_xlog dir not getting swept	Niels Kristian Schjødt	09:36

Browse Archives

Prev | Next