pgsql-performance since 2012-09-23 00:00

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

Sept. 23, 2012

Thread Author Time
Re: Newbie performance problem - semop taking most of time ? mal.oracledba 19:42
Re: Newbie performance problem - semop taking most of time ? Tom Lane 20:36

Sept. 24, 2012

Thread Author Time
Memory issues Shiran Kleiderman 06:41
Memory issues Shiran Kleiderman 06:45
Re: Cost of opening and closing an empty transaction Albe Laurenz 09:48
Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 10:33
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 11:55
Re: Postgres becoming slow, only full vacuum fixes it 📎 Julien Cigar 12:21
Re: Postgres becoming slow, only full vacuum fixes it MirrorX 12:23
Re: Postgres becoming slow, only full vacuum fixes it Andres Freund 12:34
Re: Postgres becoming slow, only full vacuum fixes it 📎 Julien Cigar 12:53
Re: Postgres becoming slow, only full vacuum fixes it Andres Freund 13:34
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 13:51
Re: Postgres becoming slow, only full vacuum fixes it 📎 Julien Cigar 14:14
Spurious failure to obtain row lock possible in PG 9.1? henk de wit 21:18
Re: Postgres becoming slow, only full vacuum fixes it Ondrej Ivanič 21:43
Re: Postgres becoming slow, only full vacuum fixes it Mark Kirkwood 23:08

Sept. 25, 2012

Thread Author Time
Re: Spurious failure to obtain row lock possible in PG 9.1? Albe Laurenz 10:48
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 11:01
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 11:07
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 11:10
Re: Postgres becoming slow, only full vacuum fixes it Thomas Kellerer 11:24
Re: Postgres becoming slow, only full vacuum fixes it Kevin Grittner 12:40
Re: Postgres becoming slow, only full vacuum fixes it Ondrej Ivanič 23:14

Sept. 26, 2012

Thread Author Time
Re: Memory issues Scott Marlowe 00:56
Re: Memory issues Shiran Kleiderman 01:00
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 09:41
Same query doing slow then quick FFW_Rude 12:27
Re: Postgres becoming slow, only full vacuum fixes it Kevin Grittner 12:58
Re: Same query doing slow then quick FFW_Rude 13:03
Re: Same query doing slow then quick 📎 Julien Cigar 13:21
Re: Same query doing slow then quick FFW_Rude 13:36
Re: Same query doing slow then quick 📎 Julien Cigar 13:49
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 13:50
Re: Same query doing slow then quick FFW_Rude 14:14
Re: Same query doing slow then quick 📎 Julien Cigar 14:17
Re: Same query doing slow then quick FFW_Rude 14:19
Re: Same query doing slow then quick FFW_Rude 14:41
Re: Same query doing slow then quick 📎 Julien Cigar 14:52
Re: Same query doing slow then quick FFW_Rude 15:18
Re: Same query doing slow then quick Nikolay Ulyanitsky 15:33
Re: Same query doing slow then quick FFW_Rude 15:38
Re: [PERFORM] Planner selects different execution plans depending on limit Bruce Momjian 15:52
Re: Same query doing slow then quick Nikolay Ulyanitsky 15:52
Re: Same query doing slow then quick Undertaker Rude 16:05
Re: Same query doing slow then quick FFW_Rude 16:09
Re: Memory issues Scott Marlowe 16:29
Re: Same query doing slow then quick Nikolay Ulyanitsky 16:30
Re: Memory issues Shiran Kleiderman 16:41
Inaccurate Explain Cost Robert Sosinski 18:38
Re: Inaccurate Explain Cost Shaun Thomas 20:03
Re: Guide to Posting Slow Query Questions Jeff Janes 20:11
Re: [PERFORM] Inaccurate Explain Cost Edson Richter 20:20
Re: Inaccurate Explain Cost hubert depesz lubaczewski 20:21
Re: [GENERAL] Memory issues Scott Marlowe 20:55
Re: [GENERAL] Memory issues Shiran Kleiderman 21:00
Re: [GENERAL] Memory issues Scott Marlowe 21:11
Re: [GENERAL] Memory issues Shiran Kleiderman 21:36
wrong join result set estimate Evgeny Shishkin 21:57
Re: [GENERAL] Memory issues Shiran Kleiderman 22:01
Re: Inaccurate Explain Cost Samuel Gendler 22:42
Re: [PERFORM] Inaccurate Explain Cost Tom Lane 23:29

Sept. 27, 2012

Thread Author Time
Re: [GENERAL] Inaccurate Explain Cost Jeff Janes 00:04
Re: Memory issues Andres Freund 06:59
Re: Same query doing slow then quick Undertaker Rude 08:33
Re: Same query doing slow then quick Undertaker Rude 09:01
Re: [GENERAL] Inaccurate Explain Cost Matthias 10:48
hardware advice M. D. 19:11
Re: hardware advice Claudio Freire 19:22
Re: hardware advice Craig James 19:37
Re: hardware advice M. D. 19:40
Re: hardware advice David Boreham 19:40
Re: hardware advice David Boreham 19:47
Re: hardware advice M. D. 19:56
Re: hardware advice David Boreham 20:13
Re: hardware advice Alan Hodgson 20:31
Re: hardware advice Scott Marlowe 20:44
Re: hardware advice M. D. 20:46
Re: hardware advice Shaun Thomas 20:47
Re: hardware advice Shaun Thomas 20:50
Re: hardware advice Scott Marlowe 20:55
Re: hardware advice Scott Marlowe 20:55
Re: hardware advice Shaun Thomas 21:01
Re: hardware advice David Boreham 21:04
Re: hardware advice David Boreham 21:08
Re: hardware advice Evgeny Shishkin 21:08
Re: hardware advice Claudio Freire 21:16
Re: hardware advice Alan Hodgson 21:17
Re: hardware advice Shaun Thomas 21:20
Re: hardware advice M. D. 21:22
Re: hardware advice David Boreham 21:28
Re: hardware advice Evgeny Shishkin 21:29
Re: hardware advice Scott Marlowe 21:32
Re: hardware advice Scott Marlowe 21:36
Re: hardware advice Scott Marlowe 21:39
Re: hardware advice Evgeny Shishkin 21:40
Re: hardware advice Shaun Thomas 21:44
Re: hardware advice Scott Marlowe 23:52
Re: hardware advice Scott Marlowe 23:56
Re: hardware advice Scott Marlowe 23:57

Sept. 28, 2012

Thread Author Time
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 06:52
Re: hardware advice Jeremy Harris 10:38
exponentia​l performanc​e decrease, problem with version postgres + RHEL? John Nash 10:43
Re: [PERFORM] exponentia​l performanc​e decrease, problem with version postgres + RHEL? Nikolay Ulyanitsky 10:47
RE: [PERFORM] exponentia​l performanc​e decrease, problem with version postgres + RHEL? Albe Laurenz 10:58
Re: [PERFORM] Re: [PERFORM] exponentia​l performanc​e decrease, problem with version postgres + RHEL? John Nash 10:58
"Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records antthelimey 13:52
Re: "Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records Deron 15:10
Re: hardware advice [email protected] 15:38
Re: hardware advice Craig James 15:46
Re: hardware advice David Boreham 15:57
Re: hardware advice M. D. 17:33
Possible Performance Regression with Transitive Comparisons vs. Constants Shaun Thomas 19:22
Re: Possible Performance Regression with Transitive Comparisons vs. Constants Tom Lane 20:35
Query plan, nested EXISTS Matt Daw 21:04
Re: Possible Performance Regression with Transitive Comparisons vs. Constants Shaun Thomas 21:37
Re: Query plan, nested EXISTS Tom Lane 21:44
Re: Query plan, nested EXISTS Matt Daw 21:47
Re: Possible Performance Regression with Transitive Comparisons vs. Constants Tom Lane 22:25
Re: Query plan, nested EXISTS Matt Daw 22:56
NestedLoops over BitmapScan question Виктор Егоров 23:11
Re: hardware advice Scott Marlowe 23:48

Sept. 29, 2012

Thread Author Time
Re: Postgres becoming slow, only full vacuum fixes it Scott Marlowe 06:59
Re: Spurious failure to obtain row lock possible in PG 9.1? henk de wit 12:40

Oct. 1, 2012

Thread Author Time
Re: Postgres becoming slow, only full vacuum fixes it Igor Neyman 14:09
deadlock_timeout affect on performance pg noob 16:49
A Tale of 2 algorithms Colin Taylor 21:24
Re: NestedLoops over BitmapScan question Виктор Егоров 23:09

Oct. 2, 2012

Thread Author Time
Re: Inserts in 'big' table slowing down the database Stefan Keller 00:15
Re: Inserts in 'big' table slowing down the database Greg Williamson 00:35
Re: A Tale of 2 algorithms Craig Ringer 04:54
Re: deadlock_timeout affect on performance Heikki Linnakangas 08:11
Re: hardware advice Glyn Astill 08:20
Re: hardware advice - opinions about HP? Franklin, Dan (FEN) 14:51
Re: Inserts in 'big' table slowing down the database Shaun Thomas 15:09
Re: hardware advice - opinions about HP? Bruce Momjian 15:14
Re: hardware advice David Boreham 15:14
Re: hardware advice - opinions about HP? Scott Marlowe 16:01
suboptimal query plan Nick Hofstede 16:46

Oct. 3, 2012

Thread Author Time
Re: suboptimal query plan Tom Lane 03:54
Re: suboptimal query plan Nick Hofstede 08:02
Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets Andrea Suisani 11:45
Re: hardware advice Glyn Astill 11:56
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas 13:39
Re: Inserts in 'big' table slowing down the database Jeff Janes 19:35

Oct. 4, 2012

Thread Author Time
how to avoid deadlock on masive update with multiples delete Anibal David Acosta 14:01
Re: how to avoid deadlock on masive update with multiples delete Jeff Janes 16:10

Oct. 5, 2012

Thread Author Time
Re: A Tale of 2 algorithms Colin Taylor 00:34
Re: how to avoid deadlock on masive update with multiples delete Igor Neyman 14:06
Re: how to avoid deadlock on masive update with multiples delete Claudio Freire 14:27
Re: how to avoid deadlock on masive update with multiples delete Maciek Sakrejda 15:08
Re: how to avoid deadlock on masive update with multiples delete Tom Lane 15:31
Re: how to avoid deadlock on masive update with multiples delete Andres Freund 15:36
Re: how to avoid deadlock on masive update with multiples delete Tom Lane 15:46
Re: how to avoid deadlock on masive update with multiples delete Merlin Moncure 15:55
Re: how to avoid deadlock on masive update with multiples delete Claudio Freire 15:58
Re: how to avoid deadlock on masive update with multiples delete Tom Lane 16:21
Re: how to avoid deadlock on masive update with multiples delete Andres Freund 16:33
Re: how to avoid deadlock on masive update with multiples delete Anibal David Acosta 18:33

Oct. 7, 2012

Thread Author Time
UPDATE execution time is increasing virag 13:49
Re: Same query doing slow then quick Ants Aasma 14:27
Re: Guide to Posting Slow Query Questions Ants Aasma 14:43
hash aggregation speedup Korisk 17:33

Oct. 8, 2012

Thread Author Time
Re: Same query doing slow then quick Undertaker Rude 07:39
Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki 08:18
Re: Strange behavior after upgrade from 9.0 to 9.2 Craig Ringer 10:15
Re: Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki 11:40
Re: UPDATE execution time is increasing Valentine Gogichashvili 12:20
Re: [repost] Help me develop new commit_delay advice Peter Geoghegan 12:38
Re: Strange behavior after upgrade from 9.0 to 9.2 Tom Lane 14:52
Scaling 10 million records in PostgreSQL table Navaneethan R 15:26
Re: Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki 15:41
Re: Strange behavior after upgrade from 9.0 to 9.2 Tom Lane 15:56
Re: Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki 16:14
Re: Scaling 10 million records in PostgreSQL table Merlin Moncure 19:50
Re: Scaling 10 million records in PostgreSQL table Julien Cigar 19:52
Re: Scaling 10 million records in PostgreSQL table Larry Rosenman 19:53
Re: Scaling 10 million records in PostgreSQL table Steve Crawford 20:09
Re: Scaling 10 million records in PostgreSQL table Navaneethan R 20:25
Re: Scaling 10 million records in PostgreSQL table Craig Ringer 20:27
Two identical systems, radically different performance Craig James 21:45
Re: Two identical systems, radically different performance Evgeny Shishkin 21:57
Re: Two identical systems, radically different performance Craig James 22:06
Re: Two identical systems, radically different performance Evgeny Shishkin 22:08
Re: Two identical systems, radically different performance Claudio Freire 22:09
Re: Two identical systems, radically different performance Steve Crawford 22:16
Re: Two identical systems, radically different performance Craig James 22:25
Re: Two identical systems, radically different performance Imre Samu 22:28
Re: Two identical systems, radically different performance Craig James 22:29
Re: Two identical systems, radically different performance Evgeny Shishkin 22:33
Re: Two identical systems, radically different performance Craig James 22:42
Re: Scaling 10 million records in PostgreSQL table Samuel Gendler 22:42
Re: Two identical systems, radically different performance Claudio Freire 22:44
Re: Two identical systems, radically different performance Evgeny Shishkin 22:46
Re: Two identical systems, radically different performance Craig James 22:48
Re: Two identical systems, radically different performance Claudio Freire 22:50
Re: Two identical systems, radically different performance Craig James 23:03
Re: Two identical systems, radically different performance Mark Kirkwood 23:10
Re: Two identical systems, radically different performance Claudio Freire 23:12
Re: Two identical systems, radically different performance Tomas Vondra 23:16

Browse Archives

Prev | Next