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.
| Thread | Author | Time |
|---|---|---|
| Newbie performance problem - semop taking most of time ? | mal.oracledba | 12:34 |
| Thread | Author | Time |
|---|---|---|
| problems with large objects dump | Sergio Gabriel Rodriguez | 12:06 |
| Re: problems with large objects dump | Tom Lane | 14:35 |
| Re: problems with large objects dump | Sergio Gabriel Rodriguez | 15:53 |
| Re: problems with large objects dump | Tom Lane | 16:33 |
| Thread | Author | Time |
|---|---|---|
| Cost of opening and closing an empty transaction | Jon Leighton | 10:46 |
| Query Planner Optimization? | Brandon | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL performance on 64 bit as compared to 32 bit | Claudio Freire | 02:43 |
| Re: Cost of opening and closing an empty transaction | Claudio Freire | 03:08 |
| Re: Newbie performance problem - semop taking most of time ? | Daniel Farina | 05:50 |
| Re: wal_sync_method on FreeBSD 9.0 - ZFS | Sébastien Lorion | 14:01 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |