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: Could someone please help us share the procedure to troubleshoot the locks on proc issues. | postgann2020 s | 05:11 |
| slow query | dangal | 16:03 |
| Re: slow query | Justin Pryzby | 16:07 |
| Re: slow query | dangal | 16:18 |
| Re: Increasing work_mem slows down query, why? | Silvio Moioli | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good | Tejaswini GC | 06:27 |
| Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good | Julien Rouhaud | 07:06 |
| Thread | Author | Time |
|---|---|---|
| Postgresql 12, 512 partition by hash. Slow select | Arya F | 17:48 |
| Re: Postgresql 12, 512 partition by hash. Slow select | Andreas Kretschmer | 18:41 |
| Re: Postgresql 12, 512 partition by hash. Slow select | Tom Lane | 18:55 |
| Re: Postgresql 12, 512 partition by hash. Slow select | Arya F | 19:50 |
| Re: Postgresql 12, 512 partition by hash. Slow select | Neil | 20:48 |
| Thread | Author | Time |
|---|---|---|
| Postgres not using index on views | Rick Vincent | 14:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres not using index on views | Justin Pryzby | 04:59 |
| Re: Postgres not using index on views | Tom Lane | 05:09 |
| Re: Postgres not using index on views | Laurenz Albe | 06:42 |
| RE: Postgres not using index on views | Rick Vincent | 07:53 |
| RE: Postgres not using index on views | Rick Vincent | 09:08 |
| Re: Postgres not using index on views | Thomas Kellerer | 09:18 |
| Re: Postgres not using index on views | Thomas Kellerer | 09:24 |
| Re: slow query | Michael Christofides | 10:20 |
| PostgreSQL DBA consulting | daya airody | 11:50 |
| Re: PostgreSQL DBA consulting | Justin Pryzby | 11:56 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 17:30 |
| Thread | Author | Time |
|---|---|---|
| High kswapd | Don Seiler | 14:34 |
| Re: High kswapd | Justin Pryzby | 14:42 |
| Re: High kswapd | Don Seiler | 14:46 |
| Re: High kswapd | Justin Pryzby | 14:58 |
| Re: PostgreSQL DBA consulting | Amol Tarte | 15:04 |
| Re: High kswapd | Don Seiler | 15:08 |
| Thread | Author | Time |
|---|---|---|
| Duplicate WHERE condition changes performance and plan | singh400@gmail.com | 19:55 |
| Using unlogged tables for web sessions | Stephen Carboni | 22:53 |
| Re: Duplicate WHERE condition changes performance and plan | David Rowley | 23:57 |
| Thread | Author | Time |
|---|---|---|
| RE: Postgres not using index on views | Rick Vincent | 14:28 |
| Postgres not using index on views | David G. Johnston | 14:55 |
| RE: Postgres not using index on views | Rick Vincent | 15:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Duplicate WHERE condition changes performance and plan | singh400@gmail.com | 00:50 |
| Re: Duplicate WHERE condition changes performance and plan | Justin Pryzby | 02:33 |
| RE: Postgres not using index on views | Rick Vincent | 11:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Duplicate WHERE condition changes performance and plan | singh400@gmail.com | 16:33 |
| Re: PostgreSQL does not choose my indexes well | Jeff Janes | 18:26 |
| Re: PostgreSQL does not choose my indexes well | Stephen Frost | 18:33 |
| Re: PostgreSQL does not choose my indexes well | Tom Lane | 19:39 |
| The query plan get all columns but I'm using only one column. | Moises Lopez | 21:11 |
| Re: PostgreSQL does not choose my indexes well | Jeff Janes | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL does not choose my indexes well | Stephen Frost | 12:02 |
| Re: The query plan get all columns but I'm using only one column. | Tom Lane | 14:24 |
| Re: PostgreSQL does not choose my indexes well | Arcadio Ortega Reinoso | 19:47 |
| Re: The query plan get all columns but I'm using only one column. | Michael Lewis | 20:40 |
| Thread | Author | Time |
|---|---|---|
| Recursive query slow on strange conditions | Jean-Christophe Boggio | 17:49 |
| Re: Recursive query slow on strange conditions | Justin Pryzby | 18:10 |
| Re: Recursive query slow on strange conditions | Andreas Joseph Krogh | 19:37 |
| Re: Recursive query slow on strange conditions | Jean-Christophe Boggio | 20:22 |
| Thread | Author | Time |
|---|---|---|
| NUMA settings | Marc Rechté | 06:54 |
| Re: NUMA settings | Laurenz Albe | 08:50 |
| Re: The query plan get all columns but I'm using only one column. 📎 | Moises Lopez | 19:21 |
| Re: The query plan get all columns but I'm using only one column. | Michael Lewis | 19:36 |
| Thread | Author | Time |
|---|---|---|
| Re: The query plan get all columns but I'm using only one column. | Michael Lewis | 15:52 |
| Re: The query plan get all columns but I'm using only one column. | Moises Lopez | 16:26 |