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: Maximum number of sequences that can be created | Віталій Тимчишин | 06:29 |
| Re: Maximum number of sequences that can be created | Andres Freund | 10:57 |
| Re: Maximum number of sequences that can be created | Robert Klemme | 11:45 |
| SSD selection | Віталій Тимчишин | 15:21 |
| Re: SSD selection | David Boreham | 17:08 |
| Re: SSD selection | Merlin Moncure | 17:22 |
| Re: Configuration Recommendations | Greg Sabino Mullane | 17:53 |
| Re: SSD selection | Rosser Schwarz | 18:16 |
| Re: SSD selection | David Boreham | 20:00 |
| Re: [pgsql-performance] Daily digest v1.3606 (10 messages) | John Lister | 21:09 |
| Re: [pgsql-performance] Daily digest v1.3606 (10 messages) | Merlin Moncure | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Configuration Recommendations | Robert Klemme | 09:36 |
| Re: SSD selection | Merlin Moncure | 17:01 |
| Re: SSD selection | David Boreham | 17:45 |
| Re: SSD selection | Merlin Moncure | 18:53 |
| Re: SSD selection | Alejandro Carrillo | 19:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Configuration Recommendations | Jan Nielsen | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Configuration Recommendations 📎 | Jan Nielsen | 15:47 |
| Re: Configuration Recommendations | Jan Nielsen | 19:11 |
| Thread | Author | Time |
|---|---|---|
| local-storage versus SAN sequential read performance comparison 📎 | Jan Nielsen | 14:17 |
| Re: local-storage versus SAN sequential read performance comparison | Scott Marlowe | 15:41 |
| Re: local-storage versus SAN sequential read performance comparison | Shaun Thomas | 15:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | geirB | 12:07 |
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | geirB | 12:23 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 01:18 |
| Seqscan slowness and stored procedures | Ivan Voras | 21:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Seqscan slowness and stored procedures | Pavel Stehule | 03:28 |
| Re: pg_dump and thousands of schemas | Hugo <Nabble> | 04:12 |
| Re: Seqscan slowness and stored procedures | Ivan Voras | 15:57 |
| Re: Seqscan slowness and stored procedures | Pavel Stehule | 16:07 |
| Thread | Author | Time |
|---|---|---|
| Re: SSD selection | Greg Smith | 12:14 |
| Recover rows deleted | Alejandro Carrillo | 18:24 |
| Re: pg_dump and thousands of schemas | Jeff Janes | 21:24 |
| Re: pg_dump and thousands of schemas | Tom Lane | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Hugo <Nabble> | 05:21 |
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 09:51 |
| Strong slowdown on huge tables | Job | 14:54 |
| Re: pg_dump and thousands of schemas | Tom Lane | 15:52 |
| Re: Strong slowdown on huge tables | Tom Lane | 17:42 |
| Re: Recover rows deleted | Jeff Davis | 20:53 |
| Re: Recover rows deleted | hubert depesz lubaczewski | 21:33 |
| Re: Recover rows deleted | Alejandro Carrillo | 22:16 |
| Re: Recover rows deleted | Alejandro Carrillo | 22:34 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 00:58 |
| Re: pg_dump and thousands of schemas 📎 | Tatsuo Ishii | 09:06 |
| does the query planner consider work_mem? | Murat Tasan | 17:57 |
| Re: does the query planner consider work_mem? | Ants Aasma | 18:25 |
| Re: does the query planner consider work_mem? | Murat Tasan | 20:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Trouble with plan statistics for behaviour for query. | Craig James | 00:08 |
| Re: Trouble with plan statistics for behaviour for query. | Vitalii Tymchyshyn | 09:06 |
| Select from sequence in slow query log | Chris Rimmer | 13:13 |
| Re: Select from sequence in slow query log | Tom Lane | 13:47 |
| Re: does the query planner consider work_mem? | Tom Lane | 15:15 |
| Re: Trouble with plan statistics for behaviour for query. | Maciek Sakrejda | 15:38 |
| Re: Select from sequence in slow query log | Chris Rimmer | 15:41 |
| Thread | Author | Time |
|---|---|---|
| Re: High load average in 64-core server , no I/O wait and CPU is idle | Kevin Grittner | 02:54 |
| Array fundamentals | idc danny | 17:05 |
| Re: [PERFORM] Array fundamentals | Jeff Davis | 17:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Recover rows deleted | Alejandro Carrillo | 16:14 |
| Re: Recover rows deleted | Shaun Thomas | 16:43 |
| Re: Recover rows deleted | Alejandro Carrillo | 16:47 |
| Re: Recover rows deleted | Merlin Moncure | 17:04 |
| Re: Recover rows deleted | Alejandro Carrillo | 17:46 |
| Re: Recover rows deleted | Merlin Moncure | 18:23 |
| Re: Recover rows deleted | Alejandro Carrillo | 18:37 |
| Re: Recover rows deleted | Kevin Grittner | 18:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Trouble with plan statistics for behaviour for query. | Trevor Campbell | 01:25 |
| Re: Trouble with plan statistics for behaviour for query. | Trevor Campbell | 03:49 |
| Sequencial scan in a JOIN | Andrew Jaimes | 12:48 |
| Re: Sequencial scan in a JOIN | Shaun Thomas | 13:15 |
| Re: Sequencial scan in a JOIN | Andrew Jaimes | 13:31 |
| Re: Sequencial scan in a JOIN | Shaun Thomas | 14:02 |
| Re: Sequencial scan in a JOIN | Shaun Thomas | 14:57 |
| Missing block Magic | Alejandro Carrillo | 16:12 |
| Re: Missing block Magic | Tom Lane | 17:00 |
| Re: Missing block Magic | Alejandro Carrillo | 18:51 |
| Thread | Author | Time |
|---|---|---|
| pg 9.1 brings host machine down | Konstantin Mikhailov | 12:05 |
| Re: pg 9.1 brings host machine down | Vitalii Tymchyshyn | 12:25 |
| Re: pg 9.1 brings host machine down | Patric Bechtel | 12:40 |
| Re: pg 9.1 brings host machine down 📎 | Julien Cigar | 12:55 |
| Thread | Author | Time |
|---|---|---|
| Multiple Concurrent Updates of Shared Resource Counter | Nir Zilberman | 07:53 |
| Re: Multiple Concurrent Updates of Shared Resource Counter | Robert Klemme | 11:48 |
| Thread | Author | Time |
|---|---|---|
| Re: how to change the index chosen in plan? | Rural Hunter | 02:08 |
| Re: how to change the index chosen in plan? | Kevin Grittner | 14:39 |
| Re: how to change the index chosen in plan? | Kevin Grittner | 15:38 |
| partitioning performance question | Kevin Kempter | 17:58 |
| Thread | Author | Time |
|---|---|---|
| Re: pg 9.1 brings host machine down | Craig Ringer | 03:26 |
| Performance of CLUSTER | Mark Thornton | 08:20 |
| Re: partitioning performance question | Robert Klemme | 11:16 |
| Re: pg_dump and thousands of schemas | Jeff Janes | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: how to change the index chosen in plan? | Rural Hunter | 04:46 |
| Re: Tablespaces and query planning | Albe Laurenz | 07:01 |
| Re: how to change the index chosen in plan? | Kevin Grittner | 12:07 |
| Re: how to change the index chosen in plan? | Rural Hunter | 12:55 |
| Re: Performance of CLUSTER | Shaun Thomas | 13:42 |
| postgres clustering interactions with pg_dump | Fitch, Britt | 13:55 |
| Re: Performance of CLUSTER | Mark Thornton | 14:02 |
| Re: Performance of CLUSTER | Shaun Thomas | 14:14 |
| Re: Performance of CLUSTER | Shaun Thomas | 14:44 |
| Re: pg_dump and thousands of schemas | Jeff Janes | 16:32 |
| Re: Performance of CLUSTER | Jeff Davis | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 08:54 |
| Performance of pg_basebackup | Shaun Thomas | 14:54 |
| Re: Performance of pg_basebackup | Magnus Hagander | 14:57 |
| Re: Performance of pg_basebackup | Shaun Thomas | 15:00 |
| Re: pg_dump and thousands of schemas 📎 | Jeff Janes | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 01:45 |
| Thread | Author | Time |
|---|---|---|
| High CPU Usage | Siddharth Shah | 15:15 |
| Thread | Author | Time |
|---|---|---|
| Expected performance of querying 5k records from 4 million records? | Anish Kejariwal | 16:17 |
| Re: Expected performance of querying 5k records from 4 million records? | Josh Berkus | 17:44 |
| Re: Expected performance of querying 5k records from 4 million records? | Jeff Janes | 18:20 |
| Update blocking a select count(*)? | Benedict Holland | 18:22 |
| Re: Update blocking a select count(*)? | Peter Geoghegan | 18:32 |
| Re: Update blocking a select count(*)? | Kevin Grittner | 18:41 |
| Re: Update blocking a select count(*)? | Kevin Grittner | 18:43 |
| Re: Update blocking a select count(*)? | Benedict Holland | 18:46 |
| Re: Update blocking a select count(*)? | Benedict Holland | 18:46 |
| Re: Update blocking a select count(*)? | Kevin Grittner | 18:54 |
| Re: Update blocking a select count(*)? | Kevin Grittner | 19:03 |
| Re: Update blocking a select count(*)? 📎 | Benedict Holland | 19:04 |
| Re: Update blocking a select count(*)? | Benedict Holland | 19:12 |