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: [HACKERS] full text search index scan query plan changed in 8.4.2? | Chris | 02:38 |
| Autovacuum Tuning advice | Plugge, Joe R. | 03:09 |
| Re: Autovacuum Tuning advice | Scott Marlowe | 06:58 |
| Re: Autovacuum Tuning advice | Greg Williamson | 07:08 |
| Re: Autovacuum Tuning advice | Plugge, Joe R. | 12:39 |
| Query slowing down significantly?? | Rainer Pruy | 12:50 |
| Re: Autovacuum Tuning advice | Grzegorz Jaśkiewicz | 12:50 |
| Re: Autovacuum Tuning advice | Plugge, Joe R. | 12:57 |
| Re: Query slowing down significantly?? | Tom Lane | 16:15 |
| Re: Query slowing down significantly?? | Rainer Pruy | 17:48 |
| Re: Query slowing down significantly?? | Tom Lane | 18:15 |
| Re: Query slowing down significantly?? | Rainer Pruy | 18:49 |
| partition pruning | Anj Adu | 19:29 |
| Re: Query slowing down significantly?? | Yeb Havinga | 19:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimation issue with partitioned tables | Robert Haas | 02:07 |
| Re: partition pruning | Robert Haas | 22:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimation issue with partitioned tables | Josh Berkus | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Testing FusionIO | Devrim GÜNDÜZ | 14:41 |
| Re: Testing FusionIO | Łukasz Jagiełło | 14:53 |
| Re: Testing FusionIO | Yeb Havinga | 14:55 |
| prepared statements and partitioning (partition elimination not working) | Kevin Kempter | 17:24 |
| Re: prepared statements and partitioning (partition elimination not working) | Kenneth Marshall | 17:31 |
| Re: Testing FusionIO | Ben Chobot | 17:38 |
| Paritioning vs. caching | Konrad Garus | 18:28 |
| Re: Paritioning vs. caching | Anj Adu | 19:27 |
| Re: Paritioning vs. caching | Josh Berkus | 20:30 |
| Re: Testing FusionIO | Greg Smith | 20:50 |
| Re: Testing FusionIO | Ben Chobot | 21:09 |
| Re: Estimation issue with partitioned tables | Robert Haas | 21:56 |
| Re: partition pruning | Simon Riggs | 22:39 |
| Re: 10K vs 15k rpm for analytics | Scott Carey | 23:50 |
| Thread | Author | Time |
|---|---|---|
| Re: 10K vs 15k rpm for analytics | Scott Carey | 00:01 |
| Re: 10K vs 15k rpm for analytics | Greg Smith | 07:00 |
| Out of shared memory in postgres 8.4.2 and locks | Vidhya Bondre | 09:38 |
| Re: Out of shared memory in postgres 8.4.2 and locks | Merlin Moncure | 12:34 |
| Re: Extracting superlatives - SQL design philosophy | Merlin Moncure | 12:46 |
| Re: Out of shared memory in postgres 8.4.2 and locks | Vidhya Bondre | 13:27 |
| Re: 10K vs 15k rpm for analytics | Pierre C | 13:39 |
| Re: 10K vs 15k rpm for analytics | Ing. Marcos Ortiz Valmaseda | 14:34 |
| Re: 10K vs 15k rpm for analytics | Michael Stone | 14:47 |
| Re: 10K vs 15k rpm for analytics | david | 14:49 |
| Re: 10K vs 15k rpm for analytics | Kevin Grittner | 14:50 |
| Re: Out of shared memory in postgres 8.4.2 and locks | Merlin Moncure | 15:03 |
| Re: Extracting superlatives - SQL design philosophy | Dave Crooke | 16:13 |
| Deleting Large Objects | John KEA | 18:44 |
| Re: Deleting Large Objects | Kevin Grittner | 19:28 |
| Thread | Author | Time |
|---|---|---|
| shared_buffers advice | Paul McGarry | 01:28 |
| shared_buffers advice | Paul McGarry | 02:22 |
| Re: shared_buffers advice | Ben Chobot | 05:16 |
| How to SELECT | Angayarkanni | 06:56 |
| Re: How to SELECT | A. Kretschmer | 07:14 |
| Re: How to SELECT | Dave Crooke | 07:15 |
| Re: How to SELECT | Angayarkanni | 07:23 |
| Re: shared_buffers advice | Greg Smith | 08:39 |
| Thread | Author | Time |
|---|---|---|
| Re: shared_buffers advice | Paul McGarry | 00:19 |
| [offtopic] Problems subscribing to Postgres mailing lists | Ognjen Blagojevic | 09:54 |
| Is DBLINK transactional | elias ghanem | 15:27 |
| Re: Is DBLINK transactional | Merlin Moncure | 17:07 |
| Re: Is DBLINK transactional | Jeff Davis | 21:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Is DBLINK transactional | Craig Ringer | 12:10 |
| Re: Is DBLINK transactional | Hannu Krosing | 12:18 |
| Deleting bytea, autovacuum, and 8.2/8.4 differences | [email protected] | 21:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Deleting bytea, autovacuum, and 8.2/8.4 differences | Dave Crooke | 03:04 |
| pg_dump far too slow | David Newall | 08:01 |
| Re: Deleting bytea, autovacuum, and 8.2/8.4 differences | [email protected] | 16:31 |
| Re: pg_dump far too slow | Tom Lane | 20:21 |
| default_statistics_target | Carlo Stonebanks | 23:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Block at a time ... | Alvaro Herrera | 00:14 |
| Building multiple indexes concurrently | Rob Wultsch | 01:04 |
| Re: Building multiple indexes concurrently | Ben Chobot | 05:13 |
| Re: Block at a time ... | Pierre C | 07:32 |
| Re: GiST index performance | Yeb Havinga | 09:26 |
| Re: Block at a time ... | Greg Stark | 09:52 |
| Re: Building multiple indexes concurrently | Greg Smith | 10:11 |
| Re: Testing FusionIO | Devrim GÜNDÜZ | 12:30 |
| Re: Testing FusionIO | Brad Nicholson | 13:03 |