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 | 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 |
| Thread | Author | Time |
|---|---|---|
| Re: 30-70 seconds query... | alexandre :: aldeia digital | 12:23 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 17:33 |
| Re: ext3 filesystem / linux 7.3 | Shankar K | 17:39 |
| Re: ext3 filesystem / linux 7.3 | eric soroos | 17:53 |
| Re: ext3 filesystem / linux 7.3 | Bruce Momjian | 17:54 |
| Re: ext3 filesystem / linux 7.3 | Andrew Sullivan | 17:55 |
| Re: ext3 filesystem / linux 7.3 | Bruce Momjian | 18:26 |
| Postgresql performance on Solaris | Scott Buchan | 19:31 |
| Re: Postgresql performance on Solaris | Tom Lane | 20:21 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 20:42 |
| Re: ext3 filesystem / linux 7.3 | Keith Bottner | 20:43 |
| Re: Postgresql performance on Solaris | scott.marlowe | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: ext3 filesystem / linux 7.3 | Christopher Kings-Lynne | 01:33 |
| Re: ext3 filesystem / linux 7.3 | Sean Chittenden | 01:49 |
| Re: ext3 filesystem / linux 7.3 | Shridhar Daithankar | 04:12 |
| Re: ext3 filesystem / linux 7.3 | Andreas Kostyrka | 15:13 |
| Re: ext3 filesystem / linux 7.3 | Andreas Kostyrka | 15:18 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 15:37 |
| Re: ext3 filesystem / linux 7.3 | Andreas Kostyrka | 15:47 |
| Re: ext3 filesystem / linux 7.3 | Andrew Sullivan | 15:56 |
| Re: ext3 filesystem / linux 7.3 | Andreas Pflug | 16:45 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 17:07 |
| Re: ext3 filesystem / linux 7.3 | Josh Berkus | 20:05 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] OSS database needed for testing | Jeffrey D. Brower | 02:43 |
| Re: [HACKERS] OSS database needed for testing | Josh Berkus | 04:29 |