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: Tuning Postgres 9.1 on Windows | Walker, James Les | 12:51 |
| Re: Tuning Postgres 9.1 on Windows | Merlin Moncure | 13:06 |
| Re: Tuning Postgres 9.1 on Windows | Walker, James Les | 13:14 |
| Re: Tuning Postgres 9.1 on Windows | Andy Colson | 13:42 |
| Re: Tuning Postgres 9.1 on Windows | Merlin Moncure | 13:43 |
| Any disadvantages of using =ANY(ARRAY()) instead of IN? | Clemens Eisserer | 14:34 |
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | Tom Lane | 14:43 |
| Re: Tuning Postgres 9.1 on Windows | Walker, James Les | 14:44 |
| Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? | Clemens Eisserer | 15:04 |
| Re: Tuning Postgres 9.1 on Windows | Merlin Moncure | 16:45 |
| Re: Tuning Postgres 9.1 on Windows | Thomas Kellerer | 17:00 |
| Re: Tuning Postgres 9.1 on Windows | Walker, James Les | 19:13 |
| Re: Tuning Postgres 9.1 on Windows | Walker, James Les | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Several optimization options (config/hardware) | Martin Grotzke | 13:19 |
| Re: Several optimization options (config/hardware) | Tomas Vondra | 14:57 |
| 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 |