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 |
|---|---|---|
| Re: encourging bitmap AND | Jim Nasby | 21:00 |
| Re: CPU bound | Jim Nasby | 21:57 |
| Thread | Author | Time |
|---|---|---|
| Re: How to turn autovacuum prevent wrap around run faster? | marc.hsiao | 02:01 |
| Re: CPU bound | Mladen Gogala | 16:17 |
| Thread | Author | Time |
|---|---|---|
| Question: BlockSize > 8192 with FusionIO | Strange, John W | 00:33 |
| Re: Question: BlockSize > 8192 with FusionIO | Greg Smith | 02:13 |
| Re: Performance of PostgreSQL over NFS | Greg Smith | 02:28 |
| Re: adding foreign key constraint locks up table | Florian Weimer | 13:52 |
| Re: concurrent IO in postgres? | Greg Smith | 13:53 |
| Re: PostgreSQL | Greg Smith | 14:07 |
| Re: adding foreign key constraint locks up table | Tom Lane | 15:21 |
| Re: Question: BlockSize > 8192 with FusionIO | Merlin Moncure | 16:48 |
| Same stament sometime fast, something slow | Fernando Mertins | 18:03 |
| Re: Same stament sometime fast, something slow | Kevin Grittner | 18:12 |
| Re: Question: BlockSize > 8192 with FusionIO | Ben Chobot | 18:36 |
| Re: Question: BlockSize > 8192 with FusionIO | Strange, John W | 19:01 |
| Re: Question: BlockSize > 8192 with FusionIO | Strange, John W | 20:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Same stament sometime fast, something slow | Craig Ringer | 01:24 |
| Re: Same stament sometime fast, something slow | Greg Smith | 01:51 |
| Re: Question: BlockSize > 8192 with FusionIO | Scott Carey | 06:41 |
| Re: adding foreign key constraint locks up table | kakarukeys | 07:09 |
| Re: Major performance problem after upgrade from 8.3 to 8.4 | Marc Antonio | 20:06 |
| Wrong docs on wal_buffers? | Josh Berkus | 20:43 |
| Re: Wrong docs on wal_buffers? | Jeff Janes | 21:45 |
| plan question - query with order by and limit not choosing index depends on size of limit, table | Mike Broers | 22:57 |
| Re: Wrong docs on wal_buffers? | Pierre C | 22:58 |
| Re: plan question - query with order by and limit not choosing index depends on size of limit, table | Kevin Grittner | 23:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Wrong docs on wal_buffers? | Josh Berkus | 18:58 |
| Re: postgres performance tunning | Robert Haas | 21:31 |
| Re: plan question - query with order by and limit not choosing index depends on size of limit, table | Mike Broers | 21:36 |
| Re: postgres performance tunning | Scott Marlowe | 21:41 |
| Re: postgres performance tunning | Scott Marlowe | 21:41 |
| Re: Wrong docs on wal_buffers? | Scott Carey | 21:50 |
| Re: Wrong docs on wal_buffers? | Jeff Janes | 23:02 |
| Thread | Author | Time |
|---|---|---|
| "SELECT .. WHERE NOT IN" query running for hours | Γιωργος Βαλκανας | 02:36 |
| Re: How to turn autovacuum prevent wrap around run faster? | marc47marc47 | 03:57 |
| Re: "SELECT .. WHERE NOT IN" query running for hours | Mladen Gogala | 04:25 |
| Re: Wrong docs on wal_buffers? | Greg Smith | 04:37 |
| Re: How to turn autovacuum prevent wrap around run faster? | marc.hsiao | 08:14 |
| Re: "SELECT .. WHERE NOT IN" query running for hours | Γιωργος Βαλκανας | 09:29 |
| Wrong docs on checkpoint_segments? | Florian Weimer | 12:45 |
| Re: Wrong docs on checkpoint_segments? | Andres Freund | 13:39 |
| Re: Wrong docs on checkpoint_segments? | Florian Weimer | 13:45 |
| Re: Wrong docs on checkpoint_segments? | Andres Freund | 13:47 |
| Re: plan question - query with order by and limit not choosing index depends on size of limit, table | pasman pasmański | 14:00 |
| Re: Wrong docs on wal_buffers? | Samuel Gendler | 14:09 |
| Re: Wrong docs on wal_buffers? | Tom Lane | 15:07 |
| Re: Wrong docs on wal_buffers? | Samuel Gendler | 17:25 |
| Re: Wrong docs on wal_buffers? | Greg Smith | 18:46 |
| Thread | Author | Time |
|---|---|---|
| pgbench to the MAXINT | Greg Smith | 01:59 |
| Thread | Author | Time |
|---|---|---|
| Re: adding foreign key constraint locks up table | Robert Haas | 03:34 |
| Re: MySQL HandlerSocket - Is this possible in PG? | Dimitri Fontaine | 13:58 |
| Thread | Author | Time |
|---|---|---|
| Re: pgbench to the MAXINT | Euler Taveira de Oliveira | 05:17 |
| Re: pgbench to the MAXINT | Greg Smith | 08:25 |
| Re: plan question - query with order by and limit not choosing index depends on size of limit, table | Mike Broers | 16:21 |
| Re: "SELECT .. WHERE NOT IN" query running for hours | Mladen Gogala | 17:28 |
| Re: "SELECT .. WHERE NOT IN" query running for hours | Scott Carey | 20:24 |
| Re: "SELECT .. WHERE NOT IN" query running for hours | Kevin Grittner | 20:37 |
| Re: "SELECT .. WHERE NOT IN" query running for hours | Scott Carey | 21:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Problems with FTS | Rauan Maemirov | 08:16 |
| Re: pgbench to the MAXINT 📎 | Euler Taveira de Oliveira | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of PostgreSQL over NFS | Jignesh Shah | 01:43 |
| Performance test of Oracle and PostgreSQL using same binary | Divakar Singh | 06:54 |
| Re: How to turn autovacuum prevent wrap around run faster? | marc.hsiao | 08:21 |
| Slow query + why bitmap index scan?? | Laszlo Nagy | 12:14 |
| Re: Slow query + why bitmap index scan?? | Florian Weimer | 13:42 |
| The good, old times | Mladen Gogala | 13:49 |
| Re: The good, old times | Guillaume Cottenceau | 14:16 |
| Re: Slow query + why bitmap index scan?? | Laszlo Nagy | 14:21 |
| Re: Slow query + why bitmap index scan?? | Kenneth Marshall | 14:26 |
| Re: Slow query + why bitmap index scan?? | Kevin Grittner | 14:36 |
| Re: Slow query + why bitmap index scan?? | Laszlo Nagy | 15:20 |
| Re: Slow query + why bitmap index scan?? | Kevin Grittner | 16:31 |
| Re: Performance test of Oracle and PostgreSQL using same binary | Jeff Janes | 17:11 |
| Re: Slow query + why bitmap index scan?? | Cédric Villemain | 20:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Best way to get the latest revision from a table | Kevin Grittner | 00:59 |
| Re: Best way to get the latest revision from a table | Nikolas Everett | 01:50 |
| Re: The good, old times | Craig Ringer | 13:36 |
| Problem with query | Barbara Woolums | 17:56 |
| Re: queries with lots of UNIONed relations | Jon Nelson | 18:15 |
| Re: Best way to get the latest revision from a table | Shaun Thomas | 19:54 |
| Re: Best way to get the latest revision from a table | Shaun Thomas | 19:58 |
| Thread | Author | Time |
|---|---|---|
| Re: The good, old times | Craig Ringer | 06:50 |
| Thread | Author | Time |
|---|---|---|
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Achilleas Mantzios | 08:06 |
| Re: The good, old times | Devrim GÜNDÜZ | 08:43 |
| Re: The good, old times | Dave Page | 08:57 |
| Migrating to Postgresql and new hardware | Lars | 10:56 |
| Re: Bad plan when join on function | Shaun Thomas | 14:15 |
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Mladen Gogala | 14:26 |
| Re: [PERFORM] pgbench to the MAXINT | Greg Smith | 18:42 |
| Re: hashed subplan 5000x slower than two sequential operations | masterchief | 18:56 |
| Re: Migrating to Postgresql and new hardware | Andy Colson | 19:17 |
| Re: Migrating to Postgresql and new hardware | Andy Colson | 19:19 |
| Re: hashed subplan 5000x slower than two sequential operations | Віталій Тимчишин | 21:29 |
| Re: Migrating to Postgresql and new hardware | Strange, John W | 22:06 |
| Re: Migrating to Postgresql and new hardware | Mark Felder | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Migrating to Postgresql and new hardware | Craig Ringer | 00:42 |
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Achilleas Mantzios | 07:05 |
| Re: the XID question | Charles.Hou | 07:26 |
| Re: anti-join chosen even when slower than old plan | Cédric Villemain | 09:17 |
| Re: anti-join chosen even when slower than old plan | Robert Haas | 14:19 |
| Re: Migrating to Postgresql and new hardware | Andy Colson | 14:48 |
| Re: Running PostgreSQL as fast as possible no matter the consequences | Robert Haas | 15:25 |
| Re: Migrating to Postgresql and new hardware | Scott Marlowe | 15:43 |
| Re: anti-join chosen even when slower than old plan | Cédric Villemain | 16:16 |
| Re: anti-join chosen even when slower than old plan | Cédric Villemain | 16:36 |
| Re: the XID question | Kevin Grittner | 17:04 |
| copy command and blobs | Madhu Ramachandran | 20:12 |
| Re: copy command and blobs | Mladen Gogala | 20:17 |
| Re: copy command and blobs | Tom Lane | 21:11 |
| Thread | Author | Time |
|---|---|---|
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Robert Haas | 17:09 |
| Re: Best way to get the latest revision from a table | Robert Haas | 17:13 |
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Mladen Gogala | 17:42 |
| Re: the XID question | Robert Haas | 17:49 |
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Robert Haas | 17:51 |
| Fun little performance IMPROVEMENT... | grant | 18:12 |
| Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 | Mladen Gogala | 18:12 |