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: Postgresql 14 partitioning advice | Rick Otten | 14:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql 13 partitioning advice | Ameya Bidwalkar | 11:05 |
| Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries | bruno da silva | 15:12 |
| Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries | Tom Lane | 15:17 |
| Thread | Author | Time |
|---|---|---|
| pg_wal filling up while running huge updates | aditya desai | 12:30 |
| Re: pg_wal filling up while running huge updates | Don Seiler | 13:56 |
| Re: pg_wal filling up while running huge updates | Justin Pryzby | 14:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql 14 partitioning advice | Slava Mudry | 22:45 |
| Re: Postgresql 14 partitioning advice | Justin Pryzby | 22:55 |
| Thread | Author | Time |
|---|---|---|
| to_jsonb performance on array aggregated correlated subqueries | Nico Heller | 18:49 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Justin Pryzby | 18:56 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Nico Heller | 19:02 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Nico Heller | 19:07 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Justin Pryzby | 19:10 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Andres Freund | 19:15 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Nico Heller | 19:18 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Nico Heller | 19:48 |
| Re: to_jsonb performance on array aggregated correlated subqueries | Rick Otten | 20:17 |
| Thread | Author | Time |
|---|---|---|
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Tom Lane | 00:20 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Thomas Munro | 02:02 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Tom Lane | 02:18 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Thomas Munro | 02:43 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Tom Lane | 02:55 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable 📎 | Tom Lane | 16:57 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Kevin McKibbin | 21:14 |
| Thread | Author | Time |
|---|---|---|
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Thomas Munro | 02:42 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Junwang Zhao | 03:12 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Tom Lane | 03:37 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Junwang Zhao | 03:46 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Tom Lane | 03:53 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Thomas Munro | 03:58 |
| Thread | Author | Time |
|---|---|---|
| Re: pgbench: could not connect to server: Resource temporarily unavailable 📎 | Thomas Munro | 02:55 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Tom Lane | 03:06 |
| Re: pgbench: could not connect to server: Resource temporarily unavailable | Thomas Munro | 04:53 |
| Thread | Author | Time |
|---|---|---|
| Select on partitioned table is very slow 📎 | Jose Osinde | 08:49 |
| Re: Select on partitioned table is very slow | hubert depesz lubaczewski | 09:10 |
| Re: Select on partitioned table is very slow | Laurenz Albe | 10:00 |
| Re: Select on partitioned table is very slow 📎 | Jose Osinde | 13:42 |
| Re: Select on partitioned table is very slow | Ranier Vilela | 13:48 |