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: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 08:34 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 22:19 |
| Thread | Author | Time |
|---|---|---|
| psql: fe_sendauth: no password supplied | Daulat Ram | 23:36 |
| Re: psql: fe_sendauth: no password supplied | Justin Pryzby | 23:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Why could different data in a table be processed with different performance? | Fabio Pardi | 07:35 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables | Thomas Munro | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 01:34 |
| Re: dsa_allocate() faliure | Thomas Munro | 02:16 |
| Thread | Author | Time |
|---|---|---|
| Why the index is not used ? | ROS Didier | 09:57 |
| Re: Why the index is not used ? | Pavel Stehule | 10:13 |
| Re: Why the index is not used ? | Vladimir Ryabtsev | 16:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Why the index is not used ? | Paul McGarry | 02:20 |
| RE: Why the index is not used ? | ROS Didier | 13:13 |
| RE: Why the index is not used ? | ROS Didier | 13:20 |
| Re: Why the index is not used ? | Francisco Olarte | 15:58 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 17:13 |
| RE: Why the index is not used ? | ROS Didier | 18:32 |
| RE: Why the index is not used ? | Kumar, Virendra | 18:41 |
| Re: Why the index is not used ? | Vladimir Ryabtsev | 18:48 |
| Re: Why the index is not used ? | Vladimir Ryabtsev | 19:32 |
| Re: Why the index is not used ? | Tomas Vondra | 20:07 |
| Re: Why the index is not used ? | Paul McGarry | 22:10 |
| Thread | Author | Time |
|---|---|---|
| RE: Why the index is not used ? | ROS Didier | 06:29 |
| RE: Why the index is not used ? | ROS Didier | 08:32 |
| Re: Why the index is not used ? | Jean-Paul Argudo | 08:44 |
| RE: Why the index is not used ? | ROS Didier | 11:47 |
| RE: Why the index is not used ? | ROS Didier | 12:02 |
| RE: Why the index is not used ? | ROS Didier | 12:07 |
| RE: Why the index is not used ? | Phil Endecott | 13:14 |
| RE: Why the index is not used ? | ROS Didier | 14:10 |
| RE: Why the index is not used ? | ROS Didier | 14:29 |
| RE: Why the index is not used ? | ROS Didier | 15:32 |
| Re: Why the index is not used ? | Tomas Vondra | 20:00 |
| Re: Why the index is not used ? | Paul McGarry | 21:34 |
| Re: Partial index plan/cardinality costing | James Coleman | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Partial index plan/cardinality costing | Justin Pryzby | 00:49 |
| understand query on partition table | Mariel Cherkassky | 09:19 |
| Re: understand query on partition table 📎 | Samed YILDIRIM | 13:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Why could different data in a table be processed with different performance? | Vladimir Ryabtsev | 10:59 |
| Thread | Author | Time |
|---|---|---|
| does work_mem is used on temp tables? | Mariel Cherkassky | 06:56 |
| Re: does work_mem is used on temp tables? | Andrew Gierth | 07:41 |
| Re: does work_mem is used on temp tables? | Mariel Cherkassky | 07:58 |
| Thread | Author | Time |
|---|---|---|
| One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed) | Sam R. | 16:27 |
| Thread | Author | Time |
|---|---|---|
| Import csv in PostgreSQL | Dinesh Chandra 12108 | 05:42 |
| Re: Import csv in PostgreSQL | Gabi D | 06:09 |
| Thread | Author | Time |
|---|---|---|
| Re: One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed) | Sam R. | 03:47 |
| Thread | Author | Time |
|---|---|---|
| Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 07:19 |
| Re: Gained %20 performance after disabling bitmapscan | Justin Pryzby | 13:44 |
| Re: Gained %20 performance after disabling bitmapscan | Tom Lane | 13:52 |
| Re: Gained %20 performance after disabling bitmapscan | Vladimir Ryabtsev | 18:09 |
| Re: Gained %20 performance after disabling bitmapscan | Jeff Janes | 19:40 |
| Thread | Author | Time |
|---|---|---|
| Ynt: Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 06:52 |
| Ynt: Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 06:55 |
| Ynt: Gained %20 performance after disabling bitmapscan | Yavuz Selim Sertoglu | 07:20 |
| High CPU Usage of "SET ROLE" 📎 | Ulf Lohbrügge | 13:44 |
| Re: High CPU Usage of "SET ROLE" | Tom Lane | 13:57 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables | Erik Rijkers | 12:50 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 18:05 |
| Thread | Author | Time |
|---|---|---|
| DELETE / UPDATE from partition not optimized (11.0) | Dave E Martin | 16:43 |
| Thread | Author | Time |
|---|---|---|
| Re: DELETE / UPDATE from partition not optimized (11.0) | Justin Pryzby | 15:45 |
| Re: Gained %20 performance after disabling bitmapscan | Jeff Janes | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Re: DELETE / UPDATE from partition not optimized (11.0) | Justin Pryzby | 21:49 |
| 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 |