pgsql-performance - October 2014

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
Jump to day: 1 2 3 4 5 6 7 8 10 14 15 16 17 18 19 20 21 22 23 24 28 29 30 31

Oct. 1, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 18:56

Oct. 2, 2014

Thread Author Time
auto vaccum is dying Rodrigo Barboza 04:43
Re: auto vaccum is dying Heikki Linnakangas 06:53
Re: auto vaccum is dying Dorian Hoxha 07:42
Re: Yet another abort-early plan disaster on 9.3 Simon Riggs 08:19
Re: Yet another abort-early plan disaster on 9.3 Peter Geoghegan 09:30
Re: Yet another abort-early plan disaster on 9.3 Ryan Johnson 13:59
Re: auto vaccum is dying Jeff Janes 15:34
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 19:56
help: function failing George Neuner 23:00

Oct. 3, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Peter Geoghegan 00:54
performance of SELECT * much faster than SELECT <colname> with large offset Marc Slemko 02:17
Re: performance of SELECT * much faster than SELECT <colname> with large offset Tom Lane 02:39
Re: performance of SELECT * much faster than SELECT <colname> with large offset Marti Raudsepp 08:40
Planning for Scalability Roberto Grandi 08:55
Re: Planning for Scalability Graeme B. Bell 10:47
Re: Planning for Scalability [email protected] 13:00
Re: Planning for Scalability Roberto Grandi 13:43
query plan question, nested loop vs hash join Andrey Lizenko 15:38
Re: Planning for Scalability Claudio Freire 16:33
Re: Yet another abort-early plan disaster on 9.3 Jeff Janes 19:58
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 23:30
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 23:41

Oct. 4, 2014

Thread Author Time
Re: auto vaccum is dying Rodrigo Barboza 17:31
Re: auto vaccum is dying Rodrigo Barboza 17:31
Re: auto vaccum is dying Jeff Janes 18:12

Oct. 5, 2014

Thread Author Time
query plan question, nested loop vs hash join Andrey Lizenko 18:57
Re: query plan question, nested loop vs hash join Victor Yegorov 19:18
Re: query plan question, nested loop vs hash join Tom Lane 19:47

Oct. 6, 2014

Thread Author Time
Re: query plan question, nested loop vs hash join Andrey Lizenko 12:50
Re: query plan question, nested loop vs hash join Andrey Lizenko 12:58
<idle> issue? 📎 Emi Lu 14:54
Re: <idle> issue? Felipe Santos 15:07
pg_basebackup - odd performance Mike Blackwell 18:53
Re: <idle> issue? jaime soler 21:10

Oct. 7, 2014

Thread Author Time
Re: pg_basebackup - odd performance Jov 02:59
Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 Vladimir Kamarzin 10:13
Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 Tom Lane 13:56
Re: pg_basebackup - odd performance Mike Blackwell 19:55
Re: query plan question, nested loop vs hash join Marti Raudsepp 20:26
Re: help: function failing Sergey Konoplev 20:41
Re: help: function failing Andrew Dunstan 21:27

Oct. 8, 2014

Thread Author Time
Bad optimization/planning on Postgres window-based queries (partition by(, group by?)) - 1000x speedup and 06:35
Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660 Vladimir Kamarzin 08:40
Re: query plan question, nested loop vs hash join Andrey Lizenko 09:48
char(N), varchar(N), varchar, text 📎 Emi Lu 14:22
Re: char(N), varchar(N), varchar, text Andrew Dunstan 14:30
Re: char(N), varchar(N), varchar, text Emi Lu 14:42

Oct. 10, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Greg Stark 11:16
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 12:10
Re: Yet another abort-early plan disaster on 9.3 Craig James 14:21
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 16:53
Re: Yet another abort-early plan disaster on 9.3 📎 Tomas Vondra 17:53
Re: Yet another abort-early plan disaster on 9.3 Craig James 17:59
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 18:13

Oct. 14, 2014

Thread Author Time
Partitions and work_mem? Dave Johansen 17:08
Re: Partitions and work_mem? Jeff Janes 18:29

Oct. 15, 2014

Thread Author Time
Re: Partitions and work_mem? Josh Berkus 17:10
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 17:20
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 18:02
Re: Partitions and work_mem? Dave Johansen 20:05
Re: Partitions and work_mem? Igor Neyman 20:08
Re: Partitions and work_mem? Dave Johansen 20:19
Re: Partitions and work_mem? Igor Neyman 20:36
Re: Partitions and work_mem? Dave Johansen 20:49
Re: Partitions and work_mem? Igor Neyman 21:00
Re: Partitions and work_mem? Josh Berkus 22:25
Re: Partitions and work_mem? Tom Lane 22:58

Oct. 16, 2014

Thread Author Time
Partitioned tables and SELECT ... ORDER BY ... LIMIT Дмитрий Шалашов 12:35
Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT François Beausoleil 13:19
Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Дмитрий Шалашов 13:33
Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Jeff Janes 17:04
Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Felipe Santos 17:15
Re: Partitioned tables and SELECT ... ORDER BY ... LIMIT Дмитрий Шалашов 17:22
CopyManager(In/out) vs. delete/insert directly Emi Lu 18:30
9.4 performance improvements test Josh Berkus 20:06

Oct. 17, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Greg Stark 17:25

Oct. 18, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Tomas Vondra 17:01

Oct. 19, 2014

Thread Author Time
IS NOT NULL and LEFT JOIN Laurent Martelli 04:10
Re: IS NOT NULL and LEFT JOIN David Rowley 08:41
Re: Yet another abort-early plan disaster on 9.3 Greg Stark 22:24

Oct. 20, 2014

Thread Author Time
Re: IS NOT NULL and LEFT JOIN Laurent Martelli 09:29
Re: IS NOT NULL and LEFT JOIN Tom Lane 13:58
Query with large number of joins Marco Di Cesare 20:32
Re: IS NOT NULL and LEFT JOIN Laurent Martelli 21:02
Re: IS NOT NULL and LEFT JOIN David G Johnston 22:19
Re: IS NOT NULL and LEFT JOIN David G Johnston 22:30
Re: Query with large number of joins Tom Lane 23:59

Oct. 21, 2014

Thread Author Time
Re: IS NOT NULL and LEFT JOIN David Rowley 08:44
Re: Query with large number of joins Felipe Santos 10:45
Query Performance Problem 📎 john 12:57
Re: Query Performance Problem Felipe Santos 13:16
Re: Query with large number of joins Merlin Moncure 13:39
Re: Query with large number of joins Marco Di Cesare 16:09
Re: Query with large number of joins Andrew Dunstan 16:31
Re: Query with large number of joins Tom Lane 16:46
Re: Query with large number of joins Tom Lane 16:50
extremly bad select performance on huge table Björn Wittich 17:26
Re: extremly bad select performance on huge table Björn Wittich 17:35
Re: extremly bad select performance on huge table Igor Neyman 17:39
Re: extremly bad select performance on huge table Tom Lane 19:07
Re: extremly bad select performance on huge table Björn Wittich 19:32
Re: extremly bad select performance on huge table Igor Neyman 19:53
Re: Query with large number of joins Marco Di Cesare 20:02
Re: Query with large number of joins Marco Di Cesare 20:06
Re: Query with large number of joins Igor Neyman 20:12
ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Montana Low 22:25
Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Tom Lane 22:35
Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Tomas Vondra 22:46
Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Montana Low 22:55

Oct. 22, 2014

Thread Author Time
Re: extremly bad select performance on huge table Björn Wittich 05:05
Re: ERROR: out of memory | with 23GB cached 7GB reserved on 30GB machine Montana Low 06:23
Re: IS NOT NULL and LEFT JOIN Laurent Martelli 06:29
Re: Query with large number of joins Merlin Moncure 13:22
Re: extremly bad select performance on huge table Igor Neyman 13:57
Re: extremly bad select performance on huge table Kevin Grittner 14:53
Re: extremly bad select performance on huge table Björn Wittich 15:13

Oct. 23, 2014

Thread Author Time
Checkpoints tuning pinker 13:24

Oct. 24, 2014

Thread Author Time
Re: extremly bad select performance on huge table Björn Wittich 05:16

Oct. 28, 2014

Thread Author Time
unnecessary sort in the execution plan when doing group by Huang, Suya 06:26
Re: unnecessary sort in the execution plan when doing group by David Rowley 07:06
Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh 20:55
Sanity checking big select performance Jeff Chen 21:15
Re: Incredibly slow restore times after 9.0>9.2 upgrade Tomas Vondra 21:19
Re: Sanity checking big select performance Tomas Vondra 21:42
Re: unnecessary sort in the execution plan when doing group by Huang, Suya 23:43

Oct. 29, 2014

Thread Author Time
Re: Sanity checking big select performance Kevin Grittner 13:47
Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh 15:12
Re: Incredibly slow restore times after 9.0>9.2 upgrade Mathis, Jason 15:34
Re: Incredibly slow restore times after 9.0>9.2 upgrade jmcdonagh 16:33

Oct. 30, 2014

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

Oct. 31, 2014

Thread Author Time
Re: pgtune + configurations with 9.3 Albe Laurenz 09:43

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 10 14 15 16 17 18 19 20 21 22 23 24 28 29 30 31