Home > mailing lists

Mailing lists [pgsql-performance]

1 October 2014

00:12 Re: Yet another abort-early plan disaster on 9.3 Gavin Flower
01:14 Re: Yet another abort-early plan disaster on 9.3 Merlin Moncure
02:02 Re: Yet another abort-early plan disaster on 9.3 Simon Riggs
21:56 Re: Yet another abort-early plan disaster on 9.3 Josh Berkus

2 October 2014

07:43 auto vaccum is dying Rodrigo Barboza
09:53 Re: auto vaccum is dying Heikki Linnakangas
10:43 Re: auto vaccum is dying Dorian Hoxha
11:19 Re: Yet another abort-early plan disaster on 9.3 Simon Riggs
12:30 Re: Yet another abort-early plan disaster on 9.3 Peter Geoghegan
16:59 Re: Yet another abort-early plan disaster on 9.3 Ryan Johnson
18:34 Re: auto vaccum is dying Jeff Janes
22:56 Re: Yet another abort-early plan disaster on 9.3 Josh Berkus

3 October 2014

03:54 Re: Yet another abort-early plan disaster on 9.3 Peter Geoghegan
05:18 performance of SELECT * much faster than SELECT with large offset Marc Slemko
05:39 Re: performance of SELECT * much faster than SELECT with large offset Tom Lane
11:40 Re: performance of SELECT * much faster than SELECT with large offset Marti Raudsepp
11:55 Planning for Scalability Roberto Grandi
16:00 Re: Planning for Scalability ktm@rice.edu
16:44 Re: Planning for Scalability Roberto Grandi
17:42 Re: Planning for Scalability Graeme B. Bell
19:33 Re: Planning for Scalability Claudio Freire
22:58 Re: Yet another abort-early plan disaster on 9.3 Jeff Janes

4 October 2014

02:30 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra
02:42 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra
20:31 Re: auto vaccum is dying Rodrigo Barboza
20:32 Re: auto vaccum is dying Rodrigo Barboza
21:12 Re: auto vaccum is dying Jeff Janes

5 October 2014

21:57 query plan question, nested loop vs hash join Andrey Lizenko
22:18 Re: query plan question, nested loop vs hash join Victor Yegorov
22:47 Re: query plan question, nested loop vs hash join Tom Lane

6 October 2014

15:50 Re: query plan question, nested loop vs hash join Andrey Lizenko
15:58 Re: query plan question, nested loop vs hash join Andrey Lizenko
17:54 issue? Emi Lu
18:07 Re: issue? Felipe Santos
21:53 pg_basebackup - odd performance Mike Blackwell

7 October 2014

00:10 Re: issue? jaime soler
05:59 Re: pg_basebackup - odd performance Jov
13:13 Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 Vladimir Kamarzin
16:56 Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 Tom Lane
22:27 help: function failing George Neuner
22:27 query plan question, nested loop vs hash join Andrey Lizenko
22:55 Re: pg_basebackup - odd performance Mike Blackwell
23:27 Re: query plan question, nested loop vs hash join Marti Raudsepp
23:41 Re: help: function failing Sergey Konoplev

8 October 2014

00:28 Re: help: function failing Andrew Dunstan
09:35 Bad optimization/planning on Postgres window-based queries (partition by(, group by?)) - 1000x speedup and
11:40 Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 Vladimir Kamarzin
12:49 Re: query plan question, nested loop vs hash join Andrey Lizenko
17:22 char(N), varchar(N), varchar, text Emi Lu
17:30 Re: char(N), varchar(N), varchar, text Andrew Dunstan
17:43 Re: char(N), varchar(N), varchar, text Emi Lu

10 October 2014

14:16 Re: Yet another abort-early plan disaster on 9.3 Greg Stark
15:10 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra
17:21 Re: Yet another abort-early plan disaster on 9.3 Craig James
19:54 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra
20:54 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra
21:00 Re: Yet another abort-early plan disaster on 9.3 Craig James
21:13 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra

14 October 2014

20:08 Partitions and work_mem? Dave Johansen
21:29 Re: Partitions and work_mem? Jeff Janes

15 October 2014

20:11 Re: Partitions and work_mem? Josh Berkus
20:20 Re: Yet another abort-early plan disaster on 9.3 Josh Berkus
21:02 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra
23:05 Re: Partitions and work_mem? Dave Johansen
23:09 Re: Partitions and work_mem? Igor Neyman
23:19 Re: Partitions and work_mem? Dave Johansen
23:37 Re: Partitions and work_mem? Igor Neyman
23:49 Re: Partitions and work_mem? Dave Johansen

16 October 2014

00:00 Re: Partitions and work_mem? Igor Neyman
01:25 Re: Partitions and work_mem? Josh Berkus
01:58 Re: Partitions and work_mem? Tom Lane
15:35 Partitioned tables and SELECT ... ORDER BY ... LIMIT Дмитрий Шалашов
16:19 Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT François Beausoleil
16:33 Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Дмитрий Шалашов
20:04 Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Jeff Janes
20:15 Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Felipe Santos
20:22 Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Дмитрий Шалашов
21:31 CopyManager(In/out) vs. delete/insert directly Emi Lu
23:06 9.4 performance improvements test Josh Berkus

17 October 2014

20:26 Re: Yet another abort-early plan disaster on 9.3 Greg Stark

18 October 2014

20:01 Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra

19 October 2014

07:11 IS NOT NULL and LEFT JOIN Laurent Martelli
11:42 Re: IS NOT NULL and LEFT JOIN David Rowley

20 October 2014

01:25 Re: Yet another abort-early plan disaster on 9.3 Greg Stark
12:29 Re: IS NOT NULL and LEFT JOIN Laurent Martelli
16:58 Re: IS NOT NULL and LEFT JOIN Tom Lane
23:33 Query with large number of joins Marco Di Cesare

21 October 2014

00:02 Re: IS NOT NULL and LEFT JOIN Laurent Martelli
01:19 Re: IS NOT NULL and LEFT JOIN David G Johnston
01:30 Re: IS NOT NULL and LEFT JOIN David G Johnston
03:00 Re: Query with large number of joins Tom Lane
11:44 Re: IS NOT NULL and LEFT JOIN David Rowley
13:45 Re: Query with large number of joins Felipe Santos
15:57 Query Performance Problem
16:16 Re: Query Performance Problem Felipe Santos
16:39 Re: Query with large number of joins Merlin Moncure
19:10 Re: Query with large number of joins Marco Di Cesare
19:31 Re: Query with large number of joins Andrew Dunstan
19:47 Re: Query with large number of joins Tom Lane
19:50 Re: Query with large number of joins Tom Lane
20:26 extremly bad select performance on huge table Björn Wittich
20:35 Re: extremly bad select performance on huge table Björn Wittich
20:40 Re: extremly bad select performance on huge table Igor Neyman
22:07 Re: extremly bad select performance on huge table Tom Lane
22:32 Re: extremly bad select performance on huge table Björn Wittich
22:53 Re: extremly bad select performance on huge table Igor Neyman
23:03 Re: Query with large number of joins Marco Di Cesare
23:07 Re: Query with large number of joins Marco Di Cesare
23:12 Re: Query with large number of joins Igor Neyman

22 October 2014

01:25 ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Montana Low
01:35 Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Tom Lane
01:46 Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Tomas Vondra
01:55 Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Montana Low
08:05 Re: extremly bad select performance on huge table Björn Wittich
09:24 Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Montana Low
09:29 Re: IS NOT NULL and LEFT JOIN Laurent Martelli
16:23 Re: Query with large number of joins Merlin Moncure
16:57 Re: extremly bad select performance on huge table Igor Neyman
17:54 Re: extremly bad select performance on huge table Kevin Grittner
18:13 Re: extremly bad select performance on huge table Björn Wittich

23 October 2014

16:24 Checkpoints tuning pinker

24 October 2014

08:16 Re: extremly bad select performance on huge table Björn Wittich

28 October 2014

09:27 unnecessary sort in the execution plan when doing group by Huang, Suya
10:06 Re: unnecessary sort in the execution plan when doing group by David Rowley
23:55 Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh

29 October 2014

00:16 Sanity checking big select performance Jeff Chen
00:19 Re: Incredibly slow restore times after 9.0>9.2 upgrade Tomas Vondra
00:42 Re: Sanity checking big select performance Tomas Vondra
02:43 Re: unnecessary sort in the execution plan when doing group by Huang, Suya
16:47 Re: Sanity checking big select performance Kevin Grittner
18:12 Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh
18:34 Re: Incredibly slow restore times after 9.0>9.2 upgrade Mathis, Jason
19:33 Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh

30 October 2014

09:49 pgtune + configurations with 9.3 Tory M Blue
19:23 Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh
19:58 Re: Incredibly slow restore times after 9.0>9.2 upgrade Jerry Sievers
22:08 Re: Incredibly slow restore times after 9.0>9.2 upgrade Tomas Vondra

31 October 2014

12:44 Re: pgtune + configurations with 9.3 Albe Laurenz