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: OIDs as keys | Tom Lane | 15:20 |
| Re: Planner matching constants across tables in a join | Richard Huxton | 16:12 |
| Re: Planner matching constants across tables in a | Josh Berkus | 19:00 |
| Re: Planner matching constants across tables in a | Richard Huxton | 19:25 |
| Re: Planner matching constants across tables in a | Richard Huxton | 19:31 |
| Re: Batch copying of databases | Josh Berkus | 19:37 |
| Batch copying of databases | Tim Mohler | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: pgsql-server/ /configure /configure.in rc/incl ... | Sean Chittenden | 00:36 |
| Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... | Neil Conway | 00:47 |
| Re: OIDs as keys | Bruce Momjian | 01:50 |
| Re: New Interface for Win | Aspire Something | 05:33 |
| Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... | Sean Chittenden | 06:04 |
| Re: New Interface for Win | Mr.F | 06:47 |
| Re: Write ahead logging | Matthias Meixner | 08:44 |
| Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... | Tom Lane | 14:29 |
| Stored Procedures and compiling | Daniel Bruce Lynes | 21:21 |
| Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... | Sean Chittenden | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Index / Performance issues | Lucas Adamski | 00:15 |
| Re: Index / Performance issues | scott.marlowe | 00:33 |
| Re: Index / Performance issues | Greg Stark | 02:39 |
| Re: Stored Procedures and compiling | Tom Lane | 03:13 |
| Re: Slow query performance on large table | Manfred Koizar | 10:15 |
| Re: Stored Procedures and compiling | Daniel Bruce Lynes | 18:34 |
| Re: OIDs as keys | daniel alvarez | 20:01 |
| Re: OIDs as keys | Tom Lane | 20:09 |
| Re: OIDs as keys | daniel alvarez | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Re: OIDs as keys | Bruce Momjian | 16:05 |
| Re: Index / Performance issues | scott.marlowe | 16:55 |
| Large difference between elapsed time and run time for queries | Scott Buchan | 18:58 |
| Re: Large difference between elapsed time and run time for queries | Tom Lane | 20:07 |
| Thread | Author | Time |
|---|---|---|
| Postgresql performance | Enix Empreendimentos e Construções Ltda. | 20:47 |
| Re: Postgresql performance | Chad Thompson | 21:38 |
| Re: Postgresql performance | Rod Taylor | 21:45 |
| speeding up COUNT and DISTINCT queries | Max Baker | 22:38 |
| Re: speeding up COUNT and DISTINCT queries | Rod Taylor | 22:52 |
| Re: speeding up COUNT and DISTINCT queries | Chad Thompson | 22:55 |
| Re: speeding up COUNT and DISTINCT queries | Jean-Luc Lachance | 23:40 |
| Re: speeding up COUNT and DISTINCT queries | Manfred Koizar | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: speeding up COUNT and DISTINCT queries | Max Baker | 01:00 |
| Re: speeding up COUNT and DISTINCT queries | Max Baker | 01:55 |
| Re: speeding up COUNT and DISTINCT queries | Joe Conway | 01:57 |
| Re: speeding up COUNT and DISTINCT queries | Max Baker | 02:05 |
| Re: speeding up COUNT and DISTINCT queries | Christopher Kings-Lynne | 02:20 |
| Re: speeding up COUNT and DISTINCT queries | Greg Stark | 15:42 |
| Re: speeding up COUNT and DISTINCT queries | Robert Treat | 20:05 |
| Re: speeding up COUNT and DISTINCT queries | Max Baker | 20:22 |
| Re: Postgresql performance | Hannu Krosing | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: speeding up COUNT and DISTINCT queries | Josh Berkus | 17:10 |
| Thread | Author | Time |
|---|---|---|
| postgresql meltdown on PlanetMath.org | Aaron Krowne | 06:01 |
| Re: postgresql meltdown on PlanetMath.org | Sean Chittenden | 06:12 |
| Re: postgresql meltdown on PlanetMath.org | Tom Lane | 06:26 |
| Re: postgresql meltdown on PlanetMath.org | Joe Conway | 06:37 |
| Re: postgresql meltdown on PlanetMath.org | Aaron Krowne | 07:52 |
| Re: postgresql meltdown on PlanetMath.org | Aaron Krowne | 08:06 |
| Re: postgresql meltdown on PlanetMath.org | Sean Chittenden | 08:20 |
| Re: postgresql meltdown on PlanetMath.org | Aaron Krowne | 08:30 |
| Re: postgresql meltdown on PlanetMath.org | Sean Chittenden | 08:35 |
| Re: postgresql meltdown on PlanetMath.org | Tom Lane | 08:37 |
| Re: postgresql meltdown on PlanetMath.org | Joe Conway | 11:29 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql meltdown on PlanetMath.org | Christopher Kings-Lynne | 01:34 |
| Re: postgresql meltdown on PlanetMath.org | Aaron Krowne | 02:31 |
| Re: postgresql meltdown on PlanetMath.org 📎 | Logan Bowers | 02:41 |
| Re: postgresql meltdown on PlanetMath.org | Christopher Kings-Lynne | 02:44 |
| Re: postgresql meltdown on PlanetMath.org | Tom Lane | 02:51 |
| Re: postgresql meltdown on PlanetMath.org | Chris Sutton | 14:59 |
| Re: postgresql meltdown on PlanetMath.org | Kendrick C. Wilson | 15:19 |
| Re: postgresql meltdown on PlanetMath.org | Josh Berkus | 16:26 |
| Thread | Author | Time |
|---|---|---|
| Re: ABOUT YOUR CREDIT......... lquwj 📎 | Lodovico | 02:28 |
| Re: postgresql meltdown on PlanetMath.org | Manfred Koizar | 19:52 |
| Thread | Author | Time |
|---|---|---|
| Make PGSQL faster | Torsten Schulz | 18:53 |
| Page Size in Future Releases | Kendrick C. Wilson | 20:45 |
| just to get some opinion on my configuration | Guillaume Houssay | 21:26 |
| Help with LIKE | David Olbersen | 21:41 |
| Re: Help with LIKE | Josh Berkus | 21:55 |
| Re: postgresql meltdown on PlanetMath.org | Florian Weimer | 23:01 |
| Re: Help with LIKE | David Olbersen | 23:19 |
| Re: Help with LIKE | David Olbersen | 23:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with LIKE | Josh Berkus | 01:27 |
| Re: Help with LIKE | Tom Lane | 02:06 |
| Re: Page Size in Future Releases | Shridhar Daithankar<shridhar_daithankar@persistent.co.in> | 03:39 |
| Re: postgresql meltdown on PlanetMath.org | Shridhar Daithankar<shridhar_daithankar@persistent.co.in> | 03:48 |
| Re: Page Size in Future Releases | Christopher Kings-Lynne | 03:51 |
| Re: Page Size in Future Releases | Josh Berkus | 04:03 |
| Re: postgresql meltdown on PlanetMath.org | Tom Lane | 06:18 |
| Re: Make PGSQL faster | Andrew McMillan | 20:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Page Size in Future Releases | Tom Lane | 00:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Page Size in Future Releases | Mario Weilguni | 08:46 |
| Slow update of indexed column with many nulls | bsamwel | 17:38 |
| Adding a foreign key constraint is extremely slow | bsamwel | 17:58 |
| Re: Adding a foreign key constraint is extremely slow | Stephan Szabo | 19:30 |
| Re: Slow update of indexed column with many nulls | Josh Berkus | 21:55 |
| Thread | Author | Time |
|---|---|---|
| Slow query 📎 | Oleg Lebedev | 17:48 |
| Re: Slow query | Josh Berkus | 18:54 |
| Re: Slow query | Oleg Lebedev | 19:02 |
| Re: Slow query | Stephan Szabo | 19:03 |
| Re: Slow query 📎 | Oleg Lebedev | 19:20 |
| Re: Slow query | Josh Berkus | 19:47 |
| Re: Slow query | Oleg Lebedev | 20:28 |
| Re: Slow query | Tom Lane | 20:48 |
| Re: Slow query 📎 | Oleg Lebedev | 21:46 |
| Re: Slow query | Tom Lane | 22:08 |
| Re: Slow query 📎 | Oleg Lebedev | 22:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query | Nikolaus Dilger | 03:26 |
| Finding the PID keeping a transaction open | Andrew Sullivan | 13:12 |
| Re: Finding the PID keeping a transaction open | Tom Lane | 14:37 |
| Re: Finding the PID keeping a transaction open | Andrew Sullivan | 15:30 |
| What's better: one huge database or several smaller ones? | dharana | 20:31 |
| [No subject] | dharana | 20:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding a foreign key constraint is extremely slow | Greg Stark | 14:17 |
| Re: Adding a foreign key constraint is extremely slow | Bart Samwel | 17:08 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Abhishek Sharma | 00:26 |
| max_fsm settings | Robert D Oden | 16:58 |
| Re: max_fsm settings | Robert Treat | 21:10 |
| Thread | Author | Time |
|---|---|---|
| slow query - where not in | Jeremiah Elliott | 15:38 |
| Re: slow query - where not in | Bruno Wolff III | 15:59 |
| Re: slow query - where not in | Greg Stark | 16:20 |
| Re: slow query - where not in | Michael Paesold | 16:53 |
| calling analyze from a stored procedure in C | Ulli Mueckstein | 17:04 |
| Re: slow query - where not in | Bruno Wolff III | 17:53 |
| Re: slow query - where not in | Jeremiah Elliott | 20:58 |
| Thread | Author | Time |
|---|---|---|
| Index not used, performance problem | Andreas Kostyrka | 09:49 |
| Re: Index not used, performance problem | Christopher Kings-Lynne | 13:47 |
| Re: Index not used, performance problem | Andrew Sullivan | 15:34 |
| Re: Index not used, performance problem | John K. Herreshoff | 16:49 |
| Re: Index not used, performance problem | Andreas Kostyrka | 16:57 |
| Re: Index not used, performance problem | Andreas Kostyrka | 16:59 |
| Re: Index not used, performance problem | Jord Tanner | 16:59 |
| Re: Index not used, performance problem | Matt Mello | 17:55 |
| Bad perfomance of pl/pgsql-function on new server | Wil Peters | 21:17 |
| Re: Index not used, performance problem | Tom Lane | 23:13 |
| Re: Bad perfomance of pl/pgsql-function on new server | Tom Lane | 23:25 |
| Thread | Author | Time |
|---|---|---|
| WAL monitoring and optimizing | Marco Colombo | 12:06 |
| Re: WAL monitoring and optimizing | Tom Lane | 17:54 |
| Re: Index not used, performance problem | scott.marlowe | 18:21 |
| Re: Index not used, performance problem | Tom Lane | 18:53 |
| ext3 filesystem / linux 7.3 | Shankar K | 20:55 |
| 30-70 seconds query... | alexandre :: aldeia digital | 21:13 |
| Re: 30-70 seconds query... | Tomasz Myrta | 22:15 |
| Re: 30-70 seconds query... | Tom Lane | 22:17 |
| Re: 30-70 seconds query... | Tom Lane | 22:58 |
| Re: 30-70 seconds query... | scott.marlowe | 23:44 |