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 |
|---|---|---|
| Indexes on UUID - Fragmentation Issue | Uday Bhaskar V | 13:29 |
| Re: Indexes on UUID - Fragmentation Issue | Merlin Moncure | 14:28 |
| Re: Indexes on UUID - Fragmentation Issue | Andreas Karlsson | 14:52 |
| Re: Indexes on UUID - Fragmentation Issue | Uday Bhaskar V | 14:56 |
| Re: Indexes on UUID - Fragmentation Issue | MichaelDBA | 19:12 |
| Thread | Author | Time |
|---|---|---|
| SCRAM question | MichaelDBA | 17:51 |
| Re: SCRAM question | Joshua D. Drake | 18:03 |
| Re: High CPU Usage of "SET ROLE" | Ulf Lohbrügge | 19:49 |
| Re: High CPU Usage of "SET ROLE" | Tom Lane | 20:27 |
| Re: High CPU Usage of "SET ROLE" | Jeff Janes | 22:34 |
| Thread | Author | Time |
|---|---|---|
| Re: SCRAM question | Michael Paquier | 09:55 |
| Thread | Author | Time |
|---|---|---|
| Fwd: Query with high planning time compared to execution time 📎 | Richard Lee | 09:36 |
| Re: Fwd: Query with high planning time compared to execution time | Tomas Vondra | 13:55 |
| Re: Fwd: Query with high planning time compared to execution time | legrand legrand | 22:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: Query with high planning time compared to execution time | Richard Lee | 03:36 |
| Re: Fwd: Query with high planning time compared to execution time | Justin Pryzby | 04:10 |
| Re: Fwd: Query with high planning time compared to execution time 📎 | Richard Lee | 07:04 |
| Re: Fwd: Query with high planning time compared to execution time | Justin Pryzby | 13:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: Query with high planning time compared to execution time | Richard Lee | 11:40 |
| Thread | Author | Time |
|---|---|---|
| NOT IN vs. NOT EXISTS performance | Lincoln Swaine-Moore | 19:35 |
| Re: NOT IN vs. NOT EXISTS performance | David Rowley | 21:11 |
| Thread | Author | Time |
|---|---|---|
| Re: NOT IN vs. NOT EXISTS performance | Merlin Moncure | 13:45 |
| Thread | Author | Time |
|---|---|---|
| Re: NOT IN vs. NOT EXISTS performance | Lincoln Swaine-Moore | 00:06 |
| Thread | Author | Time |
|---|---|---|
| Re: dsa_allocate() faliure | Jakub Glapa | 13:08 |
| Thread | Author | Time |
|---|---|---|
| checkpoint occurs very often when vacuum full running | Mariel Cherkassky | 18:53 |
| Re: checkpoint occurs very often when vacuum full running | Sergei Kornilov | 19:10 |
| Re: checkpoint occurs very often when vacuum full running | Mariel Cherkassky | 19:29 |
| Re: checkpoint occurs very often when vacuum full running | Sergei Kornilov | 20:28 |
| Re: checkpoint occurs very often when vacuum full running | Laurenz Albe | 20:32 |
| Re: checkpoint occurs very often when vacuum full running | Justin Pryzby | 20:46 |
| Thread | Author | Time |
|---|---|---|
| Re: checkpoint occurs very often when vacuum full running | Mariel Cherkassky | 11:31 |
| Re: checkpoint occurs very often when vacuum full running | Mariel Cherkassky | 11:36 |
| Re: checkpoint occurs very often when vacuum full running | Laurenz Albe | 19:28 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL VS MongoDB: a use case comparison | Fabio Pardi | 15:38 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Stephen Frost | 17:26 |
| autovacuum is running but pg_stat_all_tables empty | Mariel Cherkassky | 17:31 |
| Re: autovacuum is running but pg_stat_all_tables empty | Laurenz Albe | 18:52 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL VS MongoDB: a use case comparison | Fabio Pardi | 13:11 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Stephen Frost | 13:34 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Fabio Pardi | 15:53 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Merlin Moncure | 16:41 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Stephen Frost | 16:43 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Merlin Moncure | 17:02 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Stephen Frost | 17:28 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Merlin Moncure | 19:45 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Stephen Frost | 19:46 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL VS MongoDB: a use case comparison | Thomas Kellerer | 06:48 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 07:24 |
| Re: dsa_allocate() faliure | Jakub Glapa | 14:26 |
| Thread | Author | Time |
|---|---|---|
| Re: performance statistics monitoring without spamming logs | Justin Pryzby | 05:41 |
| Re: performance statistics monitoring without spamming logs | Adrien NAYRAT | 08:20 |
| Re: dsa_allocate() faliure | Justin Pryzby | 16:09 |
| Performance impact of updating target columns with unchanged values ON CONFLICT | Abi Noda | 19:32 |
| Re: Performance impact of updating target columns with unchanged values ON CONFLICT | Abi Noda | 21:31 |
| Re: Performance impact of updating target columns with unchanged values ON CONFLICT | Justin Pryzby | 22:40 |
| Thread | Author | Time |
|---|---|---|
| Re: dsa_allocate() faliure | Jakub Glapa | 14:31 |
| Re: dsa_allocate() faliure | Justin Pryzby | 16:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance impact of updating target columns with unchanged values ON CONFLICT | Abi Noda | 03:44 |
| Re: Performance impact of updating target columns with unchanged values ON CONFLICT | Abi Noda | 03:53 |
| Thread | Author | Time |
|---|---|---|
| explain analyze faster then query | Mariel Cherkassky | 13:08 |
| Re: explain analyze faster then query | Justin Pryzby | 13:30 |
| Re: explain analyze faster then query | Mariel Cherkassky | 13:37 |
| Re: explain analyze faster then query | Justin Pryzby | 14:12 |
| Thread | Author | Time |
|---|---|---|
| Optimizer choosing the wrong plan | Viswanath | 10:11 |
| autovacuum run but last_autovacuum is empty | Mariel Cherkassky | 15:12 |
| Re: autovacuum run but last_autovacuum is empty | Tom Lane | 15:24 |
| Re: dsa_allocate() faliure | Jakub Glapa | 15:26 |
| Re: dsa_allocate() faliure | Jakub Glapa | 15:38 |
| Re: autovacuum run but last_autovacuum is empty | Mariel Cherkassky | 15:51 |
| Re: dsa_allocate() faliure | Justin Pryzby | 15:52 |
| Re: Optimizer choosing the wrong plan | Jeff Janes | 15:53 |
| Re: dsa_allocate() faliure | Jakub Glapa | 16:00 |
| Re: autovacuum run but last_autovacuum is empty | Tom Lane | 16:10 |
| Re: dsa_allocate() faliure | Alvaro Herrera | 18:45 |
| Thread | Author | Time |
|---|---|---|
| Re: dsa_allocate() faliure | Thomas Munro | 03:00 |
| Re: dsa_allocate() faliure | Thomas Munro | 08:02 |
| Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 14:16 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Tom Lane | 15:00 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 15:11 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Jeff Janes | 19:34 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 20:20 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 20:30 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Justin Pryzby | 21:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Justin Pryzby | 00:44 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 01:00 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Justin Pryzby | 01:27 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 01:36 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Justin Pryzby | 03:01 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | David Rowley | 04:03 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Justin Pryzby | 04:17 |
| Slow Bitmap Index Scan | Scott Rankin | 19:08 |
| Re: Slow Bitmap Index Scan | Justin Pryzby | 19:17 |
| Re: Slow Bitmap Index Scan | Scott Rankin | 19:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Justin Pryzby | 00:40 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 01:01 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Oleg Bartunov | 21:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Sanyo Moura | 14:37 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Pavel Stehule | 14:54 |
| Re: dsa_allocate() faliure | Jakub Glapa | 19:20 |
| Re: dsa_allocate() faliure | Justin Pryzby | 20:46 |
| Re: [HACKERS] proposal: schema variables | Dmitry Dolgov | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 06:32 |
| Thread | Author | Time |
|---|---|---|
| Re: dsa_allocate() faliure 📎 | Thomas Munro | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow Bitmap Index Scan | Scott Rankin | 18:41 |
| Re: Slow Bitmap Index Scan | Alan Hodgson | 18:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Alvaro Herrera | 21:43 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Alvaro Herrera | 21:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 📎 | Amit Langote | 02:14 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Amit Langote | 02:19 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Amit Langote | 04:50 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Amit Langote | 05:00 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Alvaro Herrera | 07:55 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Alvaro Herrera | 07:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Ashutosh Bapat | 05:43 |
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Ashutosh Bapat | 11:14 |
| Thread | Author | Time |
|---|---|---|
| amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Square Bob | 19:00 |
| Fwd: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Square Bob | 19:03 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Pavel Stehule | 19:21 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Bob Lunney | 19:48 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Jeremy Schneider | 20:06 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Andres Freund | 23:12 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Rob Sargent | 23:23 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Andres Freund | 23:38 |
| Thread | Author | Time |
|---|---|---|
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Andrew Dunstan | 12:51 |
| Database size 1T but unclear why | Mariel Cherkassky | 15:18 |
| Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic) | Square Bob | 15:20 |
| Re: Database size 1T but unclear why | Rick Otten | 15:42 |
| Re: Database size 1T but unclear why | Justin Pryzby | 16:01 |
| Thread | Author | Time |
|---|---|---|
| database crash during pgbench run | Mariel Cherkassky | 17:18 |
| Re: database crash during pgbench run | Tom Lane | 17:44 |
| Thread | Author | Time |
|---|---|---|
| RE: database crash during pgbench run | Greg Clough | 14:35 |
| Re: database crash during pgbench run | Tom Lane | 16:01 |
| Re: Database size 1T but unclear why | Justin Pryzby | 18:55 |
| Thread | Author | Time |
|---|---|---|
| pgbench results arent accurate | Mariel Cherkassky | 12:53 |
| Re: PostgreSQL VS MongoDB: a use case comparison | Nicolas Paris | 22:37 |
| Thread | Author | Time |
|---|---|---|
| RE: pgbench results arent accurate | Greg Clough | 13:05 |
| Thread | Author | Time |
|---|---|---|
| Re: pgbench results arent accurate | Mark Kirkwood | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: pgbench results arent accurate | Mariel Cherkassky | 11:58 |
| Thread | Author | Time |
|---|---|---|
| Why Postgres doesn't use TID scan? | Vladimir Ryabtsev | 01:16 |
| Re: Why Postgres doesn't use TID scan? | Tom Lane | 01:40 |
| Re: Why Postgres doesn't use TID scan? | Vladimir Ryabtsev | 01:54 |
| Re: Why Postgres doesn't use TID scan? | Tom Lane | 02:32 |
| Re: Why Postgres doesn't use TID scan? | Vladimir Ryabtsev | 02:40 |
| Re: pgbench results arent accurate | Mark Kirkwood | 03:10 |
| Re: Why Postgres doesn't use TID scan? | Alvaro Herrera | 16:40 |
| Thread | Author | Time |
|---|---|---|
| Increasing parallelism of queries while using file fdw and partitions | Patrick Mulrooney | 04:39 |
| SQL Perfomance during autovacuum | anand086 | 06:04 |
| Re: SQL Perfomance during autovacuum | David Rowley | 06:33 |
| Re: Increasing parallelism of queries while using file fdw and partitions | Justin Pryzby | 06:51 |
| Re: Increasing parallelism of queries while using file fdw and partitions | Patrick Mulrooney | 07:36 |
| Re: Why Postgres doesn't use TID scan? | Andrew Gierth | 11:41 |
| Re: Why Postgres doesn't use TID scan? | Vladimir Ryabtsev | 20:22 |
| Re: Why Postgres doesn't use TID scan? | Andrew Gierth | 22:23 |
| Re: Why Postgres doesn't use TID scan? | Vladimir Ryabtsev | 23:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Why Postgres doesn't use TID scan? | Rick Otten | 13:46 |
| Re: pgbench results arent accurate | Merlin Moncure | 16:46 |
| Thread | Author | Time |
|---|---|---|
| Re: database crash during pgbench run | Merlin Moncure | 13:40 |
| psql cli tool and connection pooling | DJ Coertzen | 19:08 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL Perfomance during autovacuum | Jeff Janes | 00:13 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL Read IOPS limit per connection | Haroldo Kerry | 16:44 |
| Re: PostgreSQL Read IOPS limit per connection | Justin Pryzby | 16:55 |
| Query Performance Issue | neslişah demirci | 19:25 |
| Re: PostgreSQL Read IOPS limit per connection | Haroldo Kerry | 19:33 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL Read IOPS limit per connection | Jeff Janes | 01:20 |
| Re: PostgreSQL Read IOPS limit per connection | Justin Pryzby | 01:29 |
| Re: psql cli tool and connection pooling | Sebastiaan Mannem | 09:04 |
| Re: Query Performance Issue | Alexey Bashtanov | 14:53 |
| Re: Query Performance Issue | Justin Pryzby | 15:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Performance Issue | David Rowley | 06:58 |
| Re: Query Performance Issue | Justin Pryzby | 07:15 |
| Re: Query Performance Issue | Jim Finnerty | 12:00 |
| Re: Optimizer choosing the wrong plan | Jim Finnerty | 12:17 |
| Re: Optimizer choosing the wrong plan | Jeff Janes | 17:14 |
| Re: Gained %20 performance after disabling bitmapscan | Jim Finnerty | 20:11 |
| Re: Query Performance Issue | Jeff Janes | 20:27 |
| Re: Query Performance Issue | David Rowley | 22:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help with optimising simple query | Jim Finnerty | 01:25 |
| Re: Need help with optimising simple query | Jim Finnerty | 01:31 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 13:23 |
| Re: [HACKERS] proposal: schema variables | Erik Rijkers | 15:40 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 17:33 |
| Thread | Author | Time |
|---|---|---|
| select query does not pick up the right index | Abadie Lana | 16:28 |
| Re: select query does not pick up the right index | Justin Pryzby | 16:45 |
| Thread | Author | Time |
|---|---|---|
| Re: select query does not pick up the right index | David Rowley | 00:15 |
| RE: select query does not pick up the right index | Abadie Lana | 12:57 |
| RE: select query does not pick up the right index | Abadie Lana | 12:58 |
| Re: select query does not pick up the right index | David Rowley | 13:01 |
| RE: select query does not pick up the right index | Abadie Lana | 13:13 |
| Re: select query does not pick up the right index | David Rowley | 13:17 |
| RE: select query does not pick up the right index | Abadie Lana | 13:20 |
| RE: select query does not pick up the right index | Abadie Lana | 14:34 |
| Re: select query does not pick up the right index | David Rowley | 21:42 |
| Re: select query does not pick up the right index | Justin Pryzby | 23:47 |
| Thread | Author | Time |
|---|---|---|
| RE: select query does not pick up the right index | Abadie Lana | 08:10 |
| RE: select query does not pick up the right index | Abadie Lana | 08:17 |
| RE: select query does not pick up the right index | Abadie Lana | 08:58 |
| Thread | Author | Time |
|---|---|---|
| Re: select query does not pick up the right index | Justin Pryzby | 04:23 |
| Thread | Author | Time |
|---|---|---|
| RE: select query does not pick up the right index | Abadie Lana | 16:09 |
| Thread | Author | Time |
|---|---|---|
| Re: select query does not pick up the right index | Justin Pryzby | 08:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 | Amit Langote | 00:30 |