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: Equivalent praxis to CLUSTERED INDEX? | Gaetano Mendola | 01:02 |
| Re: Equivalent praxis to CLUSTERED INDEX? | Gaetano Mendola | 02:08 |
| Re: Equivalent praxis to CLUSTERED INDEX? | Bruce Momjian | 03:54 |
| Re: Equivalent praxis to CLUSTERED INDEX? | Greg Stark | 08:15 |
| Re: Why those queries do not utilize indexes? | Christopher Kings-Lynne | 08:50 |
| ill-planned queries inside a stored procedure | Gaetano Mendola | 11:14 |
| Re: Equivalent praxis to CLUSTERED INDEX? | Gaetano Mendola | 11:39 |
| Re: ill-planned queries inside a stored procedure | andrew | 15:13 |
| Re: ill-planned queries inside a stored procedure | Gaetano Mendola | 16:35 |
| Performance hit on loading from HD | Vitaly Belman | 17:41 |
| Re: Performance hit on loading from HD | Josh Berkus | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Why does a simple query not use an obvious index? | Mr Pink | 18:04 |
| Re: Why does a simple query not use an obvious index? | Scott Marlowe | 18:28 |
| Re: Why does a simple query not use an obvious index? | Steinar H. Gunderson | 18:57 |
| Re: Equivalent praxis to CLUSTERED INDEX? | Josh Berkus | 18:59 |
| Re: Why does a simple query not use an obvious index? | Greg Stark | 21:10 |
| Re: Why does a simple query not use an obvious index? | Greg Stark | 21:12 |
| Re: Why does a simple query not use an obvious index? | Scott Marlowe | 21:38 |
| Re: Why does a simple query not use an obvious index? | Scott Marlowe | 21:44 |
| Re: Why does a simple query not use an obvious index? | Tom Lane | 22:03 |
| Re: Why does a simple query not use an obvious index? | Steinar H. Gunderson | 22:04 |
| Re: Why does a simple query not use an obvious index? | Greg Stark | 22:10 |
| Re: Why does a simple query not use an obvious index? | Rod Taylor | 22:18 |
| Re: Query performance problem in 8.0.0beta1 | Russell Smith | 22:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Table UPDATE is too slow | Ron St-Pierre | 00:18 |
| Re: Table UPDATE is too slow | Tom Lane | 05:32 |
| Changing the column length | Michael Ryan S. Puncia | 06:42 |
| Fw: Query performance issue with 8.0.0beta1 | Stefano Bonnin | 07:56 |
| Re: odbc/ado problems | Markus Donath | 08:19 |
| Re: Changing the column length | gnari | 08:47 |
| Re: Query performance issue with 8.0.0beta1 | Stefano Bonnin | 09:18 |
| slower every day | G u i d o B a r o s i o | 10:06 |
| Re: slower every day | Shridhar Daithankar | 10:25 |
| Re: slower every day | Peter Eisentraut | 10:28 |
| Re: slower every day | G u i d o B a r o s i o | 10:57 |
| Re: slower every day | G u i d o B a r o s i o | 11:58 |
| Re: [ADMIN] slower every day | Richard Huxton | 12:27 |
| Re: Why does a simple query not use an obvious index? | Mr Pink | 12:50 |
| Re: slower every day | Michael Paesold | 14:28 |
| Re: slower every day | G u i d o B a r o s i o | 15:07 |
| Re: seqscan instead of index scan | Chester Kustarz | 15:47 |
| Re: Changing the column length | Josh Berkus | 16:32 |
| Re: seqscan instead of index scan | Merlin Moncure | 17:53 |
| Thread | Author | Time |
|---|---|---|
| Re: odbc/ado problems | Raymond O'Donnell | 10:46 |
| Multiple Uniques | Markus Schaber | 13:43 |
| Re: Multiple Uniques | Tom Lane | 14:22 |
| Re: Multiple Uniques | Greg Stark | 19:33 |
| Thread | Author | Time |
|---|---|---|
| disk performance benchmarks | Shane Wright | 16:44 |
| Re: fsync vs open_sync | Merlin Moncure | 17:08 |
| Re: fsync vs open_sync | Pierre-Frédéric Caillaud | 18:24 |
| restoring to wrong encoding db | Vivek Khera | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Re: fsync vs open_sync | Gaetano Mendola | 10:43 |
| Thread | Author | Time |
|---|---|---|
| Re: fsync vs open_sync | Cott Lang | 02:46 |
| Re: fsync vs open_sync | Christopher Browne | 03:47 |
| Dump/Restore performance improvement | Adi Alurkar | 04:07 |
| Re: fsync vs open_sync | Steve Bergman | 05:16 |
| Re: fsync vs open_sync | Geoffrey | 11:41 |
| Re: Dump/Restore performance improvement | Tom Lane | 17:07 |
| Re: fsync vs open_sync | Pierre-Frédéric Caillaud | 18:01 |
| Re: fsync vs open_sync | Pierre-Frédéric Caillaud | 18:03 |
| Re: Table UPDATE is too slow | Marinos J. Yannikos | 23:28 |
| Thread | Author | Time |
|---|---|---|
| Tanking a server with shared memory | Martin Foster | 01:15 |
| Re: Table UPDATE is too slow | Kevin Barnard | 01:19 |
| Re: Tanking a server with shared memory | Tom Lane | 02:18 |
| The usual sequential scan, but with LIMIT ! | Pierre-Frédéric Caillaud | 12:15 |
| Re: The usual sequential scan, but with LIMIT ! | Pierre-Frédéric Caillaud | 12:27 |
| Re: The usual sequential scan, but with LIMIT ! | Dennis Bjorklund | 12:45 |
| Re: Multiple Uniques | Markus Schaber | 15:56 |
| Re: The usual sequential scan, but with LIMIT ! | Tom Lane | 16:40 |
| Thread | Author | Time |
|---|---|---|
| Re: The usual sequential scan, but with LIMIT ! | Pierre-Frédéric Caillaud | 06:51 |
| TOAST tables, cannot truncate | G u i d o B a r o s i o | 10:41 |
| Re: TOAST tables, cannot truncate | G u i d o B a r o s i o | 11:12 |
| Re: The usual sequential scan, but with LIMIT ! | Tom Lane | 13:47 |
| Re: [PERFORM] TOAST tables, cannot truncate | Tom Lane | 14:16 |
| Re: The usual sequential scan, but with LIMIT ! | Pierre-Frédéric Caillaud | 14:30 |
| Re: [PERFORM] Table UPDATE is too slow | Ron St-Pierre | 16:20 |
| Re: The usual sequential scan, but with LIMIT ! | Gaetano Mendola | 16:54 |
| Re: [PERFORM] Table UPDATE is too slow | Tom Lane | 18:00 |
| Re: [PERFORM] Table UPDATE is too slow | Ron St-Pierre | 18:42 |
| Stuck using Sequential Scan | Jeremy M. Guthrie | 21:32 |
| Thread | Author | Time |
|---|---|---|
| Problem with large query | Marc Cousin | 13:49 |
| Re: Problem with large query | Tom Lane | 14:40 |
| Re: Problem with large query | Adam Sah | 14:47 |
| Re: Problem with large query | Marc Cousin | 14:49 |