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: Several optimization options (config/hardware) | Albe Laurenz | 07:57 |
| Re: scale up (postgresql vs mssql) | Merlin Moncure | 13:04 |
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | Clemens Eisserer | 13:19 |
| Unexpected sequence scan | Dan Fairs | 14:24 |
| Re: Unexpected sequence scan | Kevin Grittner | 14:40 |
| Re: Unexpected sequence scan | Tom Lane | 14:43 |
| Re: Unexpected sequence scan | Dan Fairs | 14:56 |
| Partitioned/inherited tables with check constraints causing slower query plans | Richard Jones | 15:01 |
| Re: Configuration Recommendations 📎 | Jan Nielsen | 15:07 |
| Re: Configuration Recommendations | Kevin Grittner | 15:33 |
| Re: Configuration Recommendations | Jeff Janes | 16:30 |
| Re: Partitioned/inherited tables with check constraints causing slower query plans | Tom Lane | 16:39 |
| Re: Partitioned/inherited tables with check constraints causing slower query plans | Richard Jones | 17:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Several optimization options (config/hardware) | Martin Grotzke | 09:37 |
| Re: Result Set over Network Question | Robert Klemme | 12:03 |
| Re: Result Set over Network Question | Thomas Kellerer | 12:11 |
| Re: Result Set over Network Question | Robert Klemme | 13:44 |
| Re: Result Set over Network Question | Thomas Kellerer | 14:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Result Set over Network Question | Robert Klemme | 09:54 |
| Re: Sudden Query slowdown on our Postgresql Server | Robert Haas | 16:17 |
| Thread | Author | Time |
|---|---|---|
| Maximum number of sequences that can be created | Vidhya Bondre | 10:50 |
| Re: Maximum number of sequences that can be created | Robert Klemme | 10:56 |
| Re: Could synchronous streaming replication really degrade the performance of the primary? | MauMau | 13:19 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Jessica Richard | 13:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Maximum number of sequences that can be created | Віталій Тимчишин | 08:12 |
| Re: Maximum number of sequences that can be created | Robert Klemme | 10:56 |
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | Clemens Eisserer | 14:35 |
| Re: Maximum number of sequences that can be created | Craig James | 16:01 |
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | Noah Misch | 22:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Maximum number of sequences that can be created | Jeff Janes | 22:50 |
| 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 |
|---|---|---|
| Tablespaces and query planning | Albe Laurenz | 08:15 |
| Re: Seqscan slowness and stored procedures | Albe Laurenz | 09:58 |
| Re: Tablespaces and query planning | Cédric Villemain | 10:36 |
| Re: Multiple Concurrent Updates of Shared Resource Counter | Cédric Villemain | 10:59 |
| Re: Seqscan slowness and stored procedures | Ivan Voras | 11:00 |
| non index use on LIKE on a non pattern string | Guillaume Cottenceau | 11:11 |
| Re: non index use on LIKE on a non pattern string | Cédric Villemain | 11:51 |