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: Index scan cost calculation | Glyn Astill | 11:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Index scan cost calculation | Jim Nasby | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Index scan cost calculation | Glyn Astill | 13:06 |
| Thread | Author | Time |
|---|---|---|
| ossp-uuid: Performance considerations for different UUID approaches? | Brendan McCollam | 19:34 |
| Thread | Author | Time |
|---|---|---|
| Slow Index Creation, why is it not consuming more memory. | Tory M Blue | 06:36 |
| Re: Slow Index Creation, why is it not consuming more memory. | Peter Geoghegan | 06:40 |
| Thread | Author | Time |
|---|---|---|
| checkpoints, proper config | Tory M Blue | 09:12 |
| Re: checkpoints, proper config | Joshua D. Drake | 17:20 |
| Re: checkpoints, proper config | Tory M Blue | 18:35 |
| Re: checkpoints, proper config | Joshua D. Drake | 20:00 |
| postgresql upgrade from 9.3 to 9.4 error | Sheena, Prabhjot | 20:35 |
| Re: checkpoints, proper config | Tory M Blue | 20:58 |
| Re: checkpoints, proper config | Joshua D. Drake | 21:14 |
| Re: checkpoints, proper config | Tomas Vondra | 22:40 |
| Re: checkpoints, proper config | Alvaro Herrera | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: checkpoints, proper config | Tomas Vondra | 01:20 |
| Advise needed for a join query with a where conditional | ankur_adwyze | 04:38 |
| Re: Advise needed for a join query with a where conditional | ankur_adwyze | 05:04 |
| Estimation row error | Mathieu VINCENT | 08:53 |
| Re: Estimation row error | Mathieu VINCENT | 11:35 |
| partitioned table set and indexes | Rick Otten | 19:01 |
| Re: partitioned table set and indexes | Andreas Kretschmer | 19:44 |
| Re: partitioned table set and indexes | Rick Otten | 20:40 |
| Re: partitioned table set and indexes | Kevin Grittner | 21:27 |
| Re: partitioned table set and indexes | Andreas Kretschmer | 21:44 |
| Re: partitioned table set and indexes | Rick Otten | 22:09 |
| Re: checkpoints, proper config | Jim Nasby | 23:45 |
| Re: checkpoints, proper config | Jim Nasby | 23:47 |
| Re: Advise needed for a join query with a where conditional | Jim Nasby | 23:50 |
| Thread | Author | Time |
|---|---|---|
| Re: partitioned table set and indexes | Andreas Kretschmer | 00:20 |
| Re: partitioned table set and indexes | Rick Otten | 00:55 |
| Re: partitioned table set and indexes | Andreas Kretschmer | 03:13 |
| Re: Advise needed for a join query with a where conditional | Jeff Janes | 16:58 |
| Thread | Author | Time |
|---|---|---|
| Performance difference between Slon master and slave | Matthew Lunnon | 17:16 |
| Re: Performance difference between Slon master and slave | Jim Nasby | 17:49 |
| Getting an optimal plan on the first execution of a pl/pgsql function | Pedro França | 18:53 |
| Re: Getting an optimal plan on the first execution of a pl/pgsql function | David G. Johnston | 19:21 |
| Re: Getting an optimal plan on the first execution of a pl/pgsql function | Tom Lane | 20:41 |
| Re: Getting an optimal plan on the first execution of a pl/pgsql function | Pedro França | 20:50 |
| Re: Performance difference between Slon master and slave | Mattthew Lunnon | 21:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimation row error | Mathieu VINCENT | 08:05 |
| Re: Estimation row error | Gunnar "Nick" Bluth | 09:25 |
| Re: Estimation row error | Andreas Kretschmer | 09:49 |
| Can't explain db size | Matteo Grolla | 09:52 |
| Re: Can't explain db size | Andreas Kretschmer | 10:07 |
| Re: Estimation row error | Gunnar "Nick" Bluth | 10:21 |
| Re: Can't explain db size | Matteo Grolla | 11:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimation row error | Mathieu VINCENT | 09:10 |
| Re: Estimation row error | Matteo Grolla | 09:14 |
| Selectivity for lopsided foreign key columns | Mikkel Lauritsen | 10:11 |
| Re: Estimation row error | Mathieu VINCENT | 10:37 |
| Re: Estimation row error | Mathieu VINCENT | 10:58 |
| Re: Can't explain db size | Matteo Grolla | 15:12 |
| Re: Selectivity for lopsided foreign key columns | Tom Lane | 15:23 |
| Terrible plan choice for view with distinct on clause | Adam Brusselback | 15:44 |
| Re: Terrible plan choice for view with distinct on clause | Tom Lane | 17:00 |
| Re: Can't explain db size | Matteo Grolla | 17:03 |
| Re: Terrible plan choice for view with distinct on clause | Adam Brusselback | 18:08 |
| Re: Terrible plan choice for view with distinct on clause | Adam Brusselback | 18:51 |
| Re: Selectivity for lopsided foreign key columns | Mikkel Lauritsen | 19:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimation row error | Mathieu VINCENT | 15:21 |
| Re: Estimation row error | Pavel Stehule | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Can't explain db size | Jim Nasby | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Connections "Startup" | Artem Tomyuk | 07:59 |
| Re: Connections "Startup" | Pavel Stehule | 08:09 |
| Re: Connections "Startup" | Rick Otten | 11:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Connections "Startup" | Jim Nasby | 02:32 |
| Re: [PERFORM] Connections "Startup" | Om Prakash Jaiswal | 03:52 |
| Re: [ADMIN] Connections "Startup" | Pavel Stehule | 04:50 |
| Thread | Author | Time |
|---|---|---|
| Plan differences | Anton Melser | 10:12 |
| Re: Plan differences | Pavel Stehule | 10:44 |
| Re: Plan differences | Anton Melser | 14:49 |
| Re: Plan differences | Tom Lane | 15:02 |
| Re: Plan differences | Jim Nasby | 16:29 |
| Re: Plan differences | Tom Lane | 17:11 |
| Re: Plan differences | Anton Melser | 20:10 |