Home > mailing lists

Mailing lists [pgsql-performance]

4 June 2016

00:26 Re: index fragmentation on insert-only table with non-unique column Claudio Freire
02:03 slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 avi Singh
02:53 Re: index fragmentation on insert-only table with non-unique column Justin Pryzby
05:05 Re: index fragmentation on insert-only table with non-unique column Claudio Freire
10:36 pg_database_size sangeetha
11:10 Re: pg_database_size Venkata Balaji N
16:40 Re: index fragmentation on insert-only table with non-unique column Kevin Grittner

5 June 2016

19:04 Re: index fragmentation on insert-only table with non-unique column Tom Lane
22:28 Re: index fragmentation on insert-only table with non-unique column Jeff Janes

7 June 2016

10:32 Locking concurrency: select for update vs update Streamsoft - Mirek Szajowski
10:35 Re: Locking concurrency: select for update vs update Szymon Lipiński
10:38 Re: Locking concurrency: select for update vs update Streamsoft - Mirek Szajowski
14:44 array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
15:31 Re: array size exceeds the maximum allowed (1073741823) when building a json David G. Johnston
15:36 Re: array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
15:39 Re: array size exceeds the maximum allowed (1073741823) when building a json David G. Johnston
15:42 Re: array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
15:58 Re: array size exceeds the maximum allowed (1073741823) when building a json David G. Johnston
16:03 Re: array size exceeds the maximum allowed (1073741823) when building a json Josh Berkus
16:24 Re: Locking concurrency: select for update vs update Tom Lane
16:26 Re: Locking concurrency: select for update vs update Streamsoft - Mirek Szajowski
16:39 Combination of partial and full indexes Rafał Gutkowski
20:36 Re: Combination of partial and full indexes Gerardo Herzig
22:23 Re: array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris

8 June 2016

01:59 Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Антон Бушмелев
07:57 Performance of LIKE/NOT LIKE when used in single query Ed Felstein
08:33 Re: Performance of LIKE/NOT LIKE when used in single query David G. Johnston
08:56 Re: array size exceeds the maximum allowed (1073741823) when building a json Michael Paquier
09:04 Re: array size exceeds the maximum allowed (1073741823) when building a json Tom Lane
11:52 Re: Combination of partial and full indexes Rafał Gutkowski
12:01 Re: Combination of partial and full indexes Rafał Gutkowski

9 June 2016

16:31 Re: array size exceeds the maximum allowed (1073741823) when building a json Merlin Moncure
16:43 Re: array size exceeds the maximum allowed (1073741823) when building a json Nicolas Paris
18:32 Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 Glyn Astill
19:38 Re: Performance of LIKE/NOT LIKE when used in single query Jeff Janes
23:36 Re: array size exceeds the maximum allowed (1073741823) when building a json Merlin Moncure

10 June 2016

01:29 Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Andres Freund
16:04 Many-to-many performance problem Rowan Seymour
17:13 Re: Many-to-many performance problem Tom Lane
17:27 Re: Many-to-many performance problem Yves Dorfsman
18:23 Re: Many-to-many performance problem Tom Lane
19:11 Re: Many-to-many performance problem Alex Ignatov

13 June 2016

00:51 Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 Andres Freund

15 June 2016

00:03 Re: pg_database_size Jim Nasby
00:03 Re: Clarification on using pg_upgrade Jim Nasby
00:08 Re: Clarification on using pg_upgrade Tory M Blue
12:35 Indexes for hashes Ivan Voras
13:14 Re: Clarification on using pg_upgrade Glyn Astill
15:45 Re: Indexes for hashes Torsten Zuehlsdorff
16:03 Re: Indexes for hashes ktm@rice.edu
16:09 Re: Indexes for hashes Ivan Voras
16:16 Re: Indexes for hashes ktm@rice.edu
16:38 Re: Indexes for hashes hubert depesz lubaczewski
16:54 Re: Indexes for hashes Ivan Voras
16:58 Re: Indexes for hashes julyanto SUTANDANG
17:01 Re: Indexes for hashes Ivan Voras
17:21 Re: Indexes for hashes Ivan Voras
17:36 Re: Indexes for hashes Joshua D. Drake
17:53 Re: Indexes for hashes ktm@rice.edu
18:14 Re: Indexes for hashes Jeff Janes

16 June 2016

01:00 pg_restore seems very slow Adrian Myers
01:08 Re: pg_restore seems very slow David G. Johnston
02:41 Re: pg_restore seems very slow Adrian Myers
04:44 Re: pg_restore seems very slow Adam Scott
10:58 Index not used meike.talbach@women-at-work.org
11:30 Re: Many-to-many performance problem Rowan Seymour
15:27 Re: Index not used John Gorman
18:05 Re: Index not used Tom Lane
18:53 Re: Index not used David G. Johnston

17 June 2016

04:56 9.6 query slower than 9.5.3 Adam Brusselback
05:04 Re: 9.6 query slower than 9.5.3 Tom Lane
05:10 Re: 9.6 query slower than 9.5.3 Adam Brusselback
05:14 Re: 9.6 query slower than 9.5.3 Adam Brusselback
05:45 Re: 9.6 query slower than 9.5.3 Tom Lane
06:36 Re: 9.6 query slower than 9.5.3 Adam Brusselback
06:51 Re: Indexes for hashes Claudio Freire
06:57 Re: 9.6 query slower than 9.5.3 Tom Lane
07:07 Re: 9.6 query slower than 9.5.3 Adam Brusselback
07:16 Re: Indexes for hashes julyanto SUTANDANG
07:18 Re: Indexes for hashes Claudio Freire
11:32 Re: Indexes for hashes Ivan Voras
11:49 Re: Indexes for hashes julyanto SUTANDANG
18:18 Re: 9.6 query slower than 9.5.3 Adam Brusselback
18:20 Savepoint and Releasepoint in Logs
18:22 Re: 9.6 query slower than 9.5.3 Tom Lane

19 June 2016

12:59 Re: Index not used meike.talbach@women-at-work.org
19:55 Re: Savepoint and Releasepoint in Logs Jeff Janes

20 June 2016

17:00 Looking for more Beta Users! jonescam

22 June 2016

19:03 Can't get two index scans Craig James
21:36 Re: Can't get two index scans Jeff Janes

23 June 2016

07:36 Re: Can't get two index scans Craig James
18:48 Re: Can't get two index scans Jeff Janes
22:52 Re: Can't get two index scans Craig James

25 June 2016

19:20 can't explain commit performance win7 vs linux : 8000/s vs 419/s t.dalpozzo@gmail.com
21:08 Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s Tom Lane
22:23 Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s Jeff Janes

26 June 2016

01:28 Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s Imre Samu

27 June 2016

14:43 [PERFORM] Cache performance decreases Suren Arustamyan

28 June 2016

17:15 testing - ignore George Neuner

29 June 2016

04:24 Random slow queries devel.brain99@xoxy.net
13:00 pg_xlog dir not getting swept Niels Kristian Schjødt
15:45 Re: Random slow queries Kevin Grittner
17:32 Re: Random slow queries Igor Neyman
21:02 Re: Random slow queries devel.brain99@xoxy.net
21:05 Re: Random slow queries devel.brain99@xoxy.net
22:19 Re: pg_xlog dir not getting swept Jeff Janes
23:20 Re: Random slow queries Tom Lane

30 June 2016

00:30 Re: Random slow queries Jeff Janes
00:44 Re: Random slow queries Tom Lane
12:37 Re: pg_xlog dir not getting swept Niels Kristian Schjødt