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: Why is this system swapping? | Josh Berkus | 00:02 |
| Re: Final decision | Josh Berkus | 03:09 |
| ODBC driver overpopulation (was Re: Final decision) | Alvaro Herrera | 03:36 |
| Re: ODBC driver overpopulation (was Re: Final decision) | Joshua D. Drake | 03:38 |
| Re: Final decision | Joshua D. Drake | 03:43 |
| Re: ODBC driver overpopulation (was Re: [PERFORM] Final decision) | Bruce Momjian | 03:44 |
| Re: Final decision | Bruce Momjian | 03:47 |
| Re: Final decision | Dave Page | 07:39 |
| Re: Why is this system swapping? | Jeff | 12:13 |
| Re: Suggestions for a data-warehouse migration routine | Mischa Sandberg | 15:00 |
| Re: [HACKERS] Bad n_distinct estimation; hacks suggested? | Mischa Sandberg | 15:21 |
| Re: [HACKERS] Bad n_distinct estimation; hacks suggested? | Marko Ristola | 17:44 |
| Thread | Author | Time |
|---|---|---|
| index on different types | Enrico Weigelt | 02:35 |
| Re: index on different types | Michael Fuhr | 03:28 |
| Re: Distinct-Sampling (Gibbons paper) for Postgres | a3a18850 | 05:10 |
| Re: Distinct-Sampling (Gibbons paper) for Postgres | Josh Berkus | 05:22 |
| Thread | Author | Time |
|---|---|---|
| Re: BLOB's bypassing the OS Filesystem for better Image | PFC | 23:22 |
| Thread | Author | Time |
|---|---|---|
| batch inserts are "slow" | Tim Terlegård | 13:52 |
| Re: batch inserts are "slow" | Christopher Kings-Lynne | 15:10 |
| Re: batch inserts are "slow" | Christopher Petrilli | 15:17 |
| Re: batch inserts are "slow" | Tim Terlegård | 15:20 |
| Re: batch inserts are "slow" | Christopher Petrilli | 15:27 |
| Re: batch inserts are "slow" | Tom Lane | 15:29 |
| Re: batch inserts are "slow" | David Parker | 15:53 |
| Citation for "Bad n_distinct estimation; hacks suggested?" | Gurmeet Manku | 16:14 |
| Re: batch inserts are "slow" | Chris Browne | 16:16 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Bad n_distinct estimation; hacks suggested? | Markus Schaber | 13:06 |
| Re: batch inserts are "slow" | Markus Schaber | 14:40 |
| Foreign key constraints compile faster in 7.4 | Ashish Arte | 15:11 |
| Re: batch inserts are "slow" | Josh Berkus | 15:41 |
| [No subject] | Steven Rosenstein | 15:55 |
| Re: batch inserts are "slow" | Kris Jurka | 15:57 |
| Re: Foreign key constraints compile faster in 7.4 | Tom Lane | 15:59 |
| Re: | Tom Lane | 16:12 |
| Testing list access | Jona | 17:33 |
| Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 2 | Jona | 17:41 |
| Re: batch inserts are "slow" | Tim Terlegård | 17:44 |
| Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1b | Jona | 17:56 |
| Re: batch inserts are "slow" | Steve Wampler | 18:29 |
| Re: COPY vs INSERT | Mischa Sandberg | 18:53 |
| Re: batch inserts are "slow" | Christopher Petrilli | 19:17 |
| Re: batch inserts are "slow" | Dave Cramer | 19:58 |
| Re: [PERFORM] Bad n_distinct estimation; hacks suggested? | Mischa Sandberg | 21:33 |
| Re: [PERFORM] Bad n_distinct estimation; hacks suggested? | Josh Berkus | 21:43 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Bad n_distinct estimation; hacks suggested? | John A Meinel | 00:45 |
| Re: [PERFORM] Bad n_distinct estimation; hacks suggested? | Josh Berkus | 00:52 |
| Kernel Resources and max_connections | Chris Hebrard | 01:12 |
| Re: Kernel Resources and max_connections | Mark Kirkwood | 01:46 |
| Re: Kernel Resources and max_connections | Chris Hebrard | 02:04 |
| Kernel Resources Solved | Chris Hebrard | 02:40 |
| Re: [PERFORM] Bad n_distinct estimation; hacks suggested? | Mischa Sandberg | 02:52 |
| Re: Kernel Resources and max_connections | Jim C. Nasby | 04:07 |
| Re: Kernel Resources and max_connections | Mark Kirkwood | 05:16 |
| Re: | Mike Rylander | 11:08 |
| Table stats | Mike G. | 14:58 |
| Re: COPY vs INSERT | David Roussel | 22:41 |
| Re: COPY vs INSERT | Mischa Sandberg | 23:11 |
| Re: COPY vs INSERT | John A Meinel | 23:23 |
| Re: COPY vs INSERT | Christopher Petrilli | 23:29 |
| Re: COPY vs INSERT | Kris Jurka | 23:33 |
| Thread | Author | Time |
|---|---|---|
| Re: COPY vs INSERT | Christopher Kings-Lynne | 01:51 |
| Re: COPY vs INSERT | Tom Lane | 02:22 |
| Re: COPY vs INSERT | Mischa Sandberg | 04:41 |
| Re: COPY vs INSERT | Kris Jurka | 09:15 |
| Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1 | Jona | 09:52 |
| Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1 | Tom Lane | 16:02 |
| Re: Table stats | David Roussel | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 | Jona | 12:00 |
| Re: Whence the Opterons? | Andrew Sullivan | 14:57 |
| Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 | Tom Lane | 15:40 |
| Re: Whence the Opterons? | Josh Berkus | 21:00 |
| Re: [SQL] ORDER BY Optimization | Tom Lane | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 | Jona | 11:10 |
| Re: sequence scan on PK | John A Meinel | 13:44 |
| sequence scan on PK | Jeroen van Iddekinge | 14:59 |
| Re: sequence scan on PK | Matteo Beccati | 16:18 |
| Re: sequence scan on PK | John A Meinel | 16:24 |
| Re: sequence scan on PK | Tom Lane | 16:49 |
| Re: sequence scan on PK | Matteo Beccati | 17:05 |
| Re: COPY vs INSERT | Jim C. Nasby | 17:12 |
| Re: sequence scan on PK | Jeroen van Iddekinge | 17:49 |
| Re: sequence scan on PK | Jeroen van Iddekinge | 18:32 |
| Re: sequence scan on PK | Jeroen van Iddekinge | 20:15 |
| Re: Whence the Opterons? | Sam Vilain | 21:59 |
| Re: Whence the Opterons? | Mischa Sandberg | 22:33 |
| Query tuning help | Dan Harris | 23:20 |