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: 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 |
| Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) | Laurenz Albe | 14:54 |
| Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) | Chris Stephens | 17:28 |
| Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) | Hannu Krosing | 21:39 |
| Thread | Author | Time |
|---|---|---|
| Odd (slow) plan choice with min/max | Paul McGarry | 04:00 |
| Re: Odd (slow) plan choice with min/max | Justin Pryzby | 05:13 |
| Re: Odd (slow) plan choice with min/max | Paul McGarry | 06:51 |
| Re: Odd (slow) plan choice with min/max | Rick Otten | 13:07 |
| Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) | Chris Stephens | 15:21 |
| Re: Odd (slow) plan choice with min/max | Paul McGarry | 21:38 |
| Re: SQL performance issue (postgresql chooses a bad plan when a better one is available) | Hannu Krosing | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Odd (slow) plan choice with min/max | Yoan SULTAN | 09:26 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables - doc 📎 | Pavel Stehule | 08:05 |
| High-volume writes - what is the max throughput possible | Geervan Hayatnagarkar | 18:12 |
| Thread | Author | Time |
|---|---|---|
| Re: How do we hint a query to use index in postgre | Nikhil Shetty | 11:41 |
| Re: High-volume writes - what is the max throughput possible | Frits Jalvingh | 12:48 |
| Thread | Author | Time |
|---|---|---|
| Re: High-volume writes - what is the max throughput possible | Hannu Krosing | 15:21 |
| Thread | Author | Time |
|---|---|---|
| Re: High availability management tool. | Dorian Hoxha | 07:59 |
| Re: High availability management tool. | Hüseyin Demir | 09:08 |
| Re: High availability management tool. | Adalberto Caccia | 09:23 |
| Thread | Author | Time |
|---|---|---|
| [PATCH] force_parallel_mode and GUC categories 📎 | Justin Pryzby | 01:25 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 08:30 |
| SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | aditya desai | 10:42 |
| Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. | aditya desai | 11:10 |
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | Amine Tengilimoglu | 17:01 |
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | Justin Pryzby | 17:19 |
| Thread | Author | Time |
|---|---|---|
| PosgtgreSQL hot standby reading WAL from muli-attached volume? | Gunther Schadow | 22:22 |
| Thread | Author | Time |
|---|---|---|
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | aditya desai | 05:09 |
| Substitute for synonym in Oracle after migration to postgres | aditya desai | 07:52 |
| Re: Substitute for synonym in Oracle after migration to postgres | Laurenz Albe | 08:19 |
| Re: Substitute for synonym in Oracle after migration to postgres | hubert depesz lubaczewski | 10:41 |
| select count(*) is slow | aditya desai | 13:14 |
| Re: Substitute for synonym in Oracle after migration to postgres | aditya desai | 13:19 |
| Re: select count(*) is slow | Tom Lane | 13:25 |
| Re: select count(*) is slow | aditya desai | 13:30 |
| Re: select count(*) is slow | Andrew Dunstan | 15:44 |
| Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS | Andrew Dunstan | 15:49 |
| Thread | Author | Time |
|---|---|---|
| Re: select count(*) is slow | aditya desai | 08:09 |
| Thread | Author | Time |
|---|---|---|
| procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 11:24 |
| str_aggr function not wokring | aditya desai | 11:31 |
| Re: procedure using CURSOR to insert is extremely slow | Hervé Schweitzer (HER) | 11:40 |
| RE: str_aggr function not wokring | Patrick FICHE | 11:41 |
| RE: procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 11:58 |
| Re: procedure using CURSOR to insert is extremely slow | Milos Babic | 12:31 |
| Re: str_aggr function not wokring | aditya desai | 12:55 |
| Re: str_aggr function not wokring | aditya desai | 12:58 |
| RE: procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 13:56 |
| RE: procedure using CURSOR to insert is extremely slow | Mike Sofen | 16:52 |
| Re: procedure using CURSOR to insert is extremely slow | Milos Babic | 18:21 |
| RE: procedure using CURSOR to insert is extremely slow | Szalontai Zoltán | 19:45 |
| INSERTS waiting with wait_event is "transactionid" | Nagaraj Raj | 20:14 |
| Re: [PATCH] force_parallel_mode and GUC categories 📎 | Justin Pryzby | 21:38 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 01:50 |
| Re: [PATCH] force_parallel_mode and GUC categories | Justin Pryzby | 03:17 |
| Re: INSERTS waiting with wait_event is "transactionid" | Laurenz Albe | 09:15 |
| Re: [PATCH] force_parallel_mode and GUC categories | Bruce Momjian | 11:39 |
| Re: INSERTS waiting with wait_event is "transactionid" | Nagaraj Raj | 18:22 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:58 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 05:01 |
| Re: [PATCH] force_parallel_mode and GUC categories | Bharath Rupireddy | 05:28 |
| Re: [PATCH] force_parallel_mode and GUC categories | Tom Lane | 05:40 |
| LWLocks by LockManager slowing large DB | Paul Friedman | 19:37 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 21:57 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 22:15 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 22:22 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 22:56 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 23:03 |
| Re: LWLocks by LockManager slowing large DB | Nikolay Samokhvalov | 23:33 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 07:34 |
| Re: [PATCH] force_parallel_mode and GUC categories 📎 | Justin Pryzby | 12:31 |
| Re: [PATCH] force_parallel_mode and GUC categories | Tom Lane | 14:12 |
| RE: LWLocks by LockManager slowing large DB 📎 | Paul Friedman | 16:33 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 16:36 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 18:16 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 18:47 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 20:48 |
| Re: LWLocks by LockManager slowing large DB | Alvaro Herrera | 20:54 |
| Re: LWLocks by LockManager slowing large DB | Tom Lane | 22:29 |
| RE: LWLocks by LockManager slowing large DB | Paul Friedman | 22:45 |
| Re: LWLocks by LockManager slowing large DB 📎 | Tom Lane | 23:16 |
| Thread | Author | Time |
|---|---|---|
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 01:01 |
| Re: LWLocks by LockManager slowing large DB | Tom Lane | 03:04 |
| Re: LWLocks by LockManager slowing large DB | Andres Freund | 03:48 |
| Re: [PATCH] force_parallel_mode and GUC categories | Michael Paquier | 04:54 |