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: Simple update query is slow | Justin Pryzby | 17:30 |
| Thread | Author | Time |
|---|---|---|
| Pg_locks and pg_stat_activity | aditya desai | 16:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Pg_locks and pg_stat_activity | aditya desai | 10:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Pg_locks and pg_stat_activity | aditya desai | 06:13 |
| Re: Pg_locks and pg_stat_activity | Ravikumar Reddy | 06:41 |
| Re: Pg_locks and pg_stat_activity | Justin Pryzby | 06:48 |
| Re: Pg_locks and pg_stat_activity | Kyotaro Horiguchi | 07:52 |
| Re: Pg_locks and pg_stat_activity | aditya desai | 08:01 |
| Re: Pg_locks and pg_stat_activity | aditya desai | 08:04 |
| Re: Pg_locks and pg_stat_activity | Justin Pryzby | 08:17 |
| Re: Pg_locks and pg_stat_activity | aditya desai | 08:34 |
| PostgeSQL JSONB Column with various type of data | Riswana Rahman | 10:45 |
| Index for range queries on JSON (user defined fields) | Marco Colli | 15:39 |
| Re: PostgeSQL JSONB Column with various type of data | Michael Lewis | 16:31 |
| Re: Index for range queries on JSON (user defined fields) | Nick Cleaton | 22:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Index for range queries on JSON (user defined fields) | Marco Colli | 10:50 |
| Thread | Author | Time |
|---|---|---|
| "Required checkpoints occurs too frequently" | Atul Kumar | 08:12 |
| Re: "Required checkpoints occurs too frequently" | Laurenz Albe | 08:51 |
| Re: "Required checkpoints occurs too frequently" | Atul Kumar | 09:02 |
| Re: "Required checkpoints occurs too frequently" | Amine Tengilimoglu | 09:19 |
| Re: "Required checkpoints occurs too frequently" | Atul Kumar | 14:34 |
| Re: "Required checkpoints occurs too frequently" | Christophe Pettus | 16:15 |
| Thread | Author | Time |
|---|---|---|
| Performance issues with composite types (partitioned table) 📎 | Sebastijan Wieser | 15:01 |
| Thread | Author | Time |
|---|---|---|
| Autovacuum not functioning for large tables but it is working for few other small tables. | M Tarkeshwar Rao | 11:54 |
| RE: Autovacuum not functioning for large tables but it is working for few other small tables. | M Tarkeshwar Rao | 11:55 |
| Re: Autovacuum not functioning for large tables but it is working for few other small tables. | Martín Marqués | 15:14 |
| Re: Autovacuum not functioning for large tables but it is working for few other small tables. | Michael Lewis | 15:28 |
| Re: Autovacuum not functioning for large tables but it is working for few other small tables. | Jeff Janes | 18:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Autovacuum not functioning for large tables but it is working for few other small tables. | Tomas Vondra | 01:46 |
| Thread | Author | Time |
|---|---|---|
| Oracle to postgresql | bangalore umesh | 10:43 |
| Re: Oracle to postgresql | Ian Lawrence Barwick | 11:14 |
| Thread | Author | Time |
|---|---|---|
| Reversing NULLS in ORDER causes index not to be used? | Ken Tanzer | 01:53 |
| Re: Reversing NULLS in ORDER causes index not to be used? | Tom Lane | 02:02 |
| Re: Reversing NULLS in ORDER causes index not to be used? | Ken Tanzer | 02:30 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:57 |
| Thread | Author | Time |
|---|---|---|
| Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. | Gunther Schadow | 18:01 |
| Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. | Marco Colli | 18:34 |
| Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. | Bruce Momjian | 19:09 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 04:52 |
| Re: proposal: schema variables | Erik Rijkers | 06:18 |
| Re: proposal: schema variables | Pavel Stehule | 06:23 |
| Thread | Author | Time |
|---|---|---|
| Slow recursive CTE query questions, with row estimate and n_distinct issues | Christopher Baines | 14:50 |
| Re: Slow recursive CTE query questions, with row estimate and n_distinct issues | Michael Lewis | 15:12 |
| Re: Slow recursive CTE query questions, with row estimate and n_distinct issues | Greg Spiegelberg | 16:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow recursive CTE query questions, with row estimate and n_distinct issues | Christopher Baines | 22:40 |
| Re: Slow recursive CTE query questions, with row estimate and n_distinct issues | Christopher Baines | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 08:45 |
| Thread | Author | Time |
|---|---|---|
| High COMMIT times | Don Seiler | 16:19 |
| Re: High COMMIT times | Joshua Drake | 16:51 |
| Re: High COMMIT times | Don Seiler | 18:06 |
| Re: High COMMIT times | Joshua Drake | 18:53 |
| Re: High COMMIT times | Kenneth Marshall | 19:15 |
| Re: High COMMIT times | Don Seiler | 20:06 |
| Thread | Author | Time |
|---|---|---|
| Re: High COMMIT times | Laurenz Albe | 02:02 |
| Re: High COMMIT times | Craig Jackson | 17:49 |
| Re: High COMMIT times | Don Seiler | 18:03 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:20 |
| Re: High COMMIT times | Laurenz Albe | 09:05 |
| RE: Autovacuum not functioning for large tables but it is working for few other small tables. | M Tarkeshwar Rao | 11:59 |
| RE: Autovacuum not functioning for large tables but it is working for few other small tables. | M Tarkeshwar Rao | 12:01 |
| Re: Autovacuum not functioning for large tables but it is working for few other small tables. | Michael Lewis | 15:52 |
| Re: High COMMIT times | José Arthur Benetasso Villanova | 17:51 |
| Re: proposal: schema variables 📎 | Erik Rijkers | 17:54 |
| Re: High COMMIT times | Don Seiler | 19:04 |
| Re: High COMMIT times | Craig Jackson | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Re: High COMMIT times | Jeff Janes | 20:07 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Re: High COMMIT times | Don Seiler | 00:42 |
| Re: High COMMIT times | Craig Jackson | 15:05 |
| Re: High COMMIT times | Don Seiler | 15:23 |
| How to deal with analyze gathering irrelevant stats | Rémi Chatenay | 15:50 |
| Re: How to deal with analyze gathering irrelevant stats | Justin Pryzby | 16:29 |
| Re: How to deal with analyze gathering irrelevant stats | Adam Brusselback | 16:37 |
| Re: How to deal with analyze gathering irrelevant stats | Michael Lewis | 16:47 |
| Re: How to deal with analyze gathering irrelevant stats | Rémi Chatenay | 16:52 |
| Re: How to deal with analyze gathering irrelevant stats | Michael Lewis | 18:26 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:35 |
| Re: proposal: schema variables | Erik Rijkers | 09:24 |
| Re: proposal: schema variables | Josef Šimánek | 10:31 |
| RE: Need information on how MM frees up disk space (vaccum) after scheduled DB cleanup by BGwCronScript/BGwLogCleaner | M Tarkeshwar Rao | 12:09 |
| Thread | Author | Time |
|---|---|---|
| Re: High COMMIT times | Don Seiler | 21:18 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 09:50 |
| Re: proposal: schema variables | Pavel Stehule | 09:57 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 09:59 |
| Re: proposal: schema variables | Erik Rijkers | 14:24 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 18:17 |
| Thread | Author | Time |
|---|---|---|
| Understanding logical replication lag | Patrick Molgaard | 18:21 |
| Thread | Author | Time |
|---|---|---|
| Query performance issue | Nagaraj Raj | 01:53 |
| Re: Query performance issue | Justin Pryzby | 02:35 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 09:50 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 08:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Query performance issue | Tomas Vondra | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Slow query and wrong row estimates for CTE | Dane Foster | 17:49 |
| Re: Slow query and wrong row estimates for CTE | Justin Pryzby | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query and wrong row estimates for CTE | Michael Lewis | 15:12 |
| Re: Slow query and wrong row estimates for CTE | Dane Foster | 15:19 |
| Re: Slow query and wrong row estimates for CTE | Dane Foster | 15:25 |
| Re: Query performance issue | Michael Lewis | 16:40 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 17:46 |
| Re: Slow query and wrong row estimates for CTE | Dane Foster | 19:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query and wrong row estimates for CTE | Dane Foster | 16:51 |
| Re: Slow query and wrong row estimates for CTE | Yoan SULTAN | 18:37 |
| Re: Slow query and wrong row estimates for CTE | Dane Foster | 20:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query and wrong row estimates for CTE | Yoan SULTAN | 04:33 |
| Thread | Author | Time |
|---|---|---|
| RE: Autovacuum not functioning for large tables but it is working for few other small tables. | M Tarkeshwar Rao | 10:51 |
| Re: Autovacuum not functioning for large tables but it is working for few other small tables. | Laurenz Albe | 13:29 |
| Thread | Author | Time |
|---|---|---|
| FreeBSD UFS & fsync | Luca Ferrari | 16:48 |
| Re: FreeBSD UFS & fsync | Thomas Munro | 21:37 |
| Thread | Author | Time |
|---|---|---|
| Re: FreeBSD UFS & fsync | Luca Ferrari | 07:46 |
| Re: FreeBSD UFS & fsync | Luca Ferrari | 11:57 |
| Postgres performance comparing GCP and AWS | Maurici Meneghetti | 18:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres performance comparing GCP and AWS | Gunther Schadow | 13:10 |
| Re: Postgres performance comparing GCP and AWS | Milos Babic | 13:15 |
| Re: Postgres performance comparing GCP and AWS | Julien Rouhaud | 13:35 |
| Re: Postgres performance comparing GCP and AWS | Igor Gois | 15:11 |
| Re: Postgres performance comparing GCP and AWS | Imre Samu | 15:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres performance comparing GCP and AWS | Philip Semanchuk | 18:13 |
| Re: Postgres performance comparing GCP and AWS | Igor Gois | 20:46 |
| Re: Postgres performance comparing GCP and AWS | Philip Semanchuk | 20:53 |
| Re: Postgres performance comparing GCP and AWS | Igor Gois | 21:04 |
| Re: Postgres performance comparing GCP and AWS | Philip Semanchuk | 22:32 |
| Disabling options lowers the estimated cost of a query 📎 | Arne Roland | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres performance comparing GCP and AWS | Justin Pitts | 01:06 |
| Re: Disabling options lowers the estimated cost of a query | Tom Lane | 03:00 |
| Thread | Author | Time |
|---|---|---|
| Potential performance issues | Jung, Jinho | 15:04 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:50 |
| Re: Potential performance issues | Andrew Dunstan | 12:59 |
| Re: Potential performance issues | MichaelDBA | 13:04 |
| Re: Potential performance issues | MichaelDBA | 13:05 |
| Re: Potential performance issues | Bob Jolliffe | 13:44 |
| Re: Potential performance issues | Jung, Jinho | 14:41 |
| Re: Potential performance issues | Thomas Kellerer | 14:44 |
| Re: Potential performance issues | Rick Otten | 14:53 |
| Re: Potential performance issues | Pavel Stehule | 15:06 |
| Re: Postgres performance comparing GCP and AWS | Hannu Krosing | 16:01 |
| Re: Potential performance issues | Hannu Krosing | 16:58 |
| Thread | Author | Time |
|---|---|---|
| Potential performance issues related to group by and covering index | Liu, Xinyu | 04:44 |
| Performance issues related to left join and order by | Liu, Xinyu | 04:47 |
| Re: Potential performance issues related to group by and covering index | Pavel Stehule | 09:08 |
| Re: Potential performance issues related to group by and covering index | David Rowley | 09:49 |
| Re: Performance issues related to left join and order by | David Rowley | 10:26 |
| High availability management tool. | Rodriguez Pablo A | 11:58 |
| Re: Potential performance issues related to group by and covering index | Michael Lewis | 21:04 |
| Re: Potential performance issues related to group by and covering index | David Rowley | 21:41 |
| Thread | Author | Time |
|---|---|---|
| tables meta data collection | Nagaraj Raj | 01:20 |
| Re: tables meta data collection | Justin Pryzby | 04:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Potential performance issues related to group by and covering index | Hannu Krosing | 01:14 |
| Slow query performance inside a transaction on a clean database | val.janeiko | 17:55 |
| Thread | Author | Time |
|---|---|---|
| Fwd: different execution time for the same query (and same DB status) | Francesco De Angelis | 21:40 |
| Thread | Author | Time |
|---|---|---|
| RE: different execution time for the same query (and same DB status) | Michel SALAIS | 14:51 |
| Re: different execution time for the same query (and same DB status) | Julien Rouhaud | 15:08 |
| Re: different execution time for the same query (and same DB status) | Tom Lane | 16:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query performance inside a transaction on a clean database | Laurenz Albe | 09:17 |
| Re: different execution time for the same query (and same DB status) | Michael Lewis | 17:03 |
| Users grants with setting options | Nagaraj Raj | 23:30 |
| Re: Users grants with setting options | David G. Johnston | 23:46 |
| Re: Users grants with setting options | Nagaraj Raj | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: different execution time for the same query (and same DB status) | Francesco De Angelis | 22:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: different execution time for the same query (and same DB status) | Justin Pryzby | 08:27 |
| Re: Fwd: different execution time for the same query (and same DB status) | Francesco De Angelis | 11:48 |
| Re: Fwd: different execution time for the same query (and same DB status) | Michael Lewis | 13:29 |
| Thread | Author | Time |
|---|---|---|
| Re: FreeBSD UFS & fsync | Bruce Momjian | 14:29 |
| Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? | Kamil Dziedzic | 21:12 |
| Thread | Author | Time |
|---|---|---|
| Re: FreeBSD UFS & fsync | Luca Ferrari | 09:08 |
| Re: FreeBSD UFS & fsync | Thomas Munro | 09:33 |
| Re: Fwd: different execution time for the same query (and same DB status) | Francesco De Angelis | 13:39 |
| Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? | Michael Lewis | 16:22 |
| Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? | Kamil Dziedzic | 16:30 |
| Re: FreeBSD UFS & fsync | Bruce Momjian | 19:39 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:01 |
| Thread | Author | Time |
|---|---|---|
| Re: FreeBSD UFS & fsync | Luca Ferrari | 13:35 |
| wide table, many many partitions, poor query performance | S Bob | 16:53 |
| Re: wide table, many many partitions, poor query performance | Justin Pryzby | 17:03 |
| Re: wide table, many many partitions, poor query performance | Laurenz Albe | 17:03 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables - doc | Erik Rijkers | 12:05 |
| Extremely inefficient merge-join | Marcin Gozdalik | 16:10 |
| Re: Extremely inefficient merge-join | Tom Lane | 20:47 |
| Re: Extremely inefficient merge-join | Marcin Gozdalik | 21:27 |
| Thread | Author | Time |
|---|---|---|
| How do we hint a query to use index in postgre | Manish Lad | 09:14 |
| Re: How do we hint a query to use index in postgre | Gaetano Mendola | 09:15 |
| Re: How do we hint a query to use index in postgre | Manish Lad | 09:37 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables - doc 📎 | Pavel Stehule | 09:47 |
| SQL performance issue (postgresql chooses a bad plan when a better one is available) | Chris Stephens | 13:10 |