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: Catching up with performance & PostgreSQL 15 | Andrew Dunstan | 17:05 |
| Thread | Author | Time |
|---|---|---|
| Odd Choice of seq scan | Paul McGarry | 00:52 |
| Re: Odd Choice of seq scan | Justin Pryzby | 01:21 |
| Re: Odd Choice of seq scan | Ronuk Raval | 05:37 |
| Re: Odd Choice of seq scan | Tom Lane | 06:16 |
| Re: Odd Choice of seq scan | Paul McGarry | 08:04 |
| Re: Odd Choice of seq scan | Chris Hoover | 19:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Catching up with performance & PostgreSQL 15 | Jeff Janes | 03:50 |
| Thread | Author | Time |
|---|---|---|
| wrong rows and cost estimation when generic plan 📎 | James Pang | 02:28 |
| RE: wrong rows and cost estimation when generic plan | James Pang (chaolpan) | 05:28 |
| RE: wrong rows and cost estimation when generic plan 📎 | James Pang (chaolpan) | 05:29 |
| Re: wrong rows and cost estimation when generic plan | David Rowley | 05:59 |
| RE: wrong rows and cost estimation when generic plan | James Pang (chaolpan) | 07:16 |
| Re: wrong rows and cost estimation when generic plan | David Rowley | 09:04 |
| Thread | Author | Time |
|---|---|---|
| Increased iowait and blk_read_time with higher shared_buffers 📎 | Jordan Hurwich | 00:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Increased iowait and blk_read_time with higher shared_buffers | Samed YILDIRIM | 12:38 |
| Re: Increased iowait and blk_read_time with higher shared_buffers | Jordan Hurwich | 18:12 |
| Re: Increased iowait and blk_read_time with higher shared_buffers | Tom Lane | 18:27 |
| Re: Increased iowait and blk_read_time with higher shared_buffers | Jordan Hurwich | 18:32 |
| Re: Increased iowait and blk_read_time with higher shared_buffers | Samed YILDIRIM | 18:41 |
| Re: Increased iowait and blk_read_time with higher shared_buffers | Jordan Hurwich | 18:43 |
| creating hash indexes | Rick Otten | 20:03 |
| Re: creating hash indexes | Peter Geoghegan | 20:28 |
| time sorted UUIDs | Tim Jones | 21:56 |
| Thread | Author | Time |
|---|---|---|
| DML sql execution time slow down PGv14 compared with PGv13 📎 | James Pang (chaolpan) | 08:12 |
| DML sql execution time slow down PGv14 compared with PGv13 📎 | James Pang (chaolpan) | 08:22 |
| Re: DML sql execution time slow down PGv14 compared with PGv13 | Samed YILDIRIM | 08:38 |
| RE: DML sql execution time slow down PGv14 compared with PGv13 📎 | James Pang (chaolpan) | 08:44 |
| RE: DML sql execution time slow down PGv14 compared with PGv13 | James Pang (chaolpan) | 08:46 |
| Re: DML sql execution time slow down PGv14 compared with PGv13 | David Rowley | 10:42 |
| RE: DML sql execution time slow down PGv14 compared with PGv13 | James Pang (chaolpan) | 11:34 |
| Re: time sorted UUIDs | Laurenz Albe | 11:59 |
| Re: time sorted UUIDs | Adrien Nayrat | 12:05 |
| RE: DML sql execution time slow down PGv14 compared with PGv13 | James Pang (chaolpan) | 12:19 |
| Thread | Author | Time |
|---|---|---|
| JSON down performacen when id:1 | Render Comunicacion S.L. | 13:30 |
| Re: JSON down performacen when id:1 | Tom Lane | 15:06 |
| Postgres12 looking for possible HashAggregate issue workarounds? | João Paulo Luís | 15:24 |
| Re: Postgres12 looking for possible HashAggregate issue workarounds? | Justin Pryzby | 16:06 |
| Re: JSON down performacen when id:1 | Render Comunicacion S.L. | 17:01 |
| RE: Postgres12 looking for possible HashAggregate issue workarounds? | João Paulo Luís | 17:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres12 looking for possible HashAggregate issue workarounds? | David Rowley | 11:06 |
| temp_file_limit? | Frits Jalvingh | 11:48 |
| Re: temp_file_limit? | Justin Pryzby | 15:57 |
| Fwd: temp_file_limit? | Frits Jalvingh | 17:29 |
| Re: Fwd: temp_file_limit? | Tom Lane | 19:28 |
| Re: Fwd: temp_file_limit? | Justin Pryzby | 20:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: temp_file_limit? | Thomas Munro | 00:51 |
| Re: Fwd: temp_file_limit? | Thomas Munro | 00:53 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 09:47 |
| Re: Fwd: temp_file_limit? | Ranier Vilela | 12:15 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 14:45 |
| Re: Fwd: temp_file_limit? | Ranier Vilela | 14:52 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 15:01 |
| RE: Postgres12 looking for possible HashAggregate issue workarounds? | João Paulo Luís | 16:50 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 16:57 |
| Re: Fwd: temp_file_limit? | Justin Pryzby | 17:15 |
| Re: Fwd: temp_file_limit? 📎 | Frits Jalvingh | 17:27 |
| Re: Fwd: temp_file_limit? | Justin Pryzby | 17:46 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 19:29 |
| Re: Fwd: temp_file_limit? | Ranier Vilela | 19:42 |
| Re: Fwd: temp_file_limit? | Justin Pryzby | 19:50 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 19:59 |
| Re: Fwd: temp_file_limit? | Thomas Munro | 20:07 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 20:10 |
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 20:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: temp_file_limit? | Justin Pryzby | 21:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: temp_file_limit? | Frits Jalvingh | 08:12 |
| Thread | Author | Time |
|---|---|---|
| When you really want to force a certain join type? | Gunther Schadow | 15:39 |
| Re: When you really want to force a certain join type? | Justin Pryzby | 15:48 |
| Thread | Author | Time |
|---|---|---|
| Re: When you really want to force a certain join type? | Gunther Schadow | 07:31 |
| Re: When you really want to force a certain join type? | Tom Lane | 07:52 |
| Thread | Author | Time |
|---|---|---|
| How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) | Maxim Boguk | 12:26 |
| Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) | Justin Pryzby | 14:32 |
| Thread | Author | Time |
|---|---|---|
| Max write throughput for single COPY | Joe Wildish | 21:09 |
| Thread | Author | Time |
|---|---|---|
| Advice on best way to store a large amount of data in postgresql | spiral | 12:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice on best way to store a large amount of data in postgresql | Michaeldba@sqlexec.com | 10:39 |
| Re: Advice on best way to store a large amount of data in postgresql | Justin Pryzby | 17:56 |
| Re: Advice on best way to store a large amount of data in postgresql | Samed YILDIRIM | 23:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice on best way to store a large amount of data in postgresql | spiral | 09:25 |
| Thread | Author | Time |
|---|---|---|
| change the default value of enable_bitmapscan to off | hehaochen@hotmail.com | 14:51 |
| Re: change the default value of enable_bitmapscan to off | Pavel Stehule | 15:00 |
| Re: change the default value of enable_bitmapscan to off | Tom Lane | 15:57 |
| Thread | Author | Time |
|---|---|---|
| ALTER STATEMENT getting blocked | aditya desai | 17:30 |
| Re: ALTER STATEMENT getting blocked | Tom Lane | 17:45 |
| Re: ALTER STATEMENT getting blocked | MichaelDBA | 21:06 |
| Thread | Author | Time |
|---|---|---|
| Re: ALTER STATEMENT getting blocked | aditya desai | 11:29 |
| LIKE CLAUSE on VIEWS | aditya desai | 11:33 |
| Re: LIKE CLAUSE on VIEWS | Samed YILDIRIM | 11:40 |
| Re: LIKE CLAUSE on VIEWS | Rick Otten | 15:55 |
| Re: LIKE CLAUSE on VIEWS | Jeff Janes | 17:49 |
| Thread | Author | Time |
|---|---|---|
| Database Stalls | Mok | 17:47 |
| Re: Database Stalls | Justin Pryzby | 17:51 |
| Re: Database Stalls | José Arthur Benetasso Villanova | 18:10 |
| Re: Database Stalls | Shiv Iyer | 18:47 |
| Re: Database Stalls | Mok | 21:31 |
| Fwd: Database Stalls | Rick Otten | 22:47 |
| Thread | Author | Time |
|---|---|---|
| Getting an index scan to be a parallel index scan | Alex Kaiser | 05:39 |
| Re: Getting an index scan to be a parallel index scan | Ranier Vilela | 11:17 |
| Re: Getting an index scan to be a parallel index scan | David Rowley | 11:30 |
| Re: Getting an index scan to be a parallel index scan | Alex Kaiser | 19:22 |
| Re: Getting an index scan to be a parallel index scan | Justin Pryzby | 20:02 |
| Re: Getting an index scan to be a parallel index scan | Thomas Munro | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Getting an index scan to be a parallel index scan | Alex Kaiser | 00:54 |
| Re: Getting an index scan to be a parallel index scan | Thomas Munro | 01:48 |
| Re: Getting an index scan to be a parallel index scan | David Rowley | 02:11 |
| Re: Getting an index scan to be a parallel index scan | Alex Kaiser | 05:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Database Stalls | Craig Jackson | 16:25 |
| Thread | Author | Time |
|---|---|---|
| Routing & Concurrency with trigger functions | chanukya SDS | 09:03 |
| Thread | Author | Time |
|---|---|---|
| Domain check taking place unnecessarily? | Mark Hills | 18:01 |
| Re: Domain check taking place unnecessarily? | David G. Johnston | 18:09 |
| Window Functions & Table Partitions | Benjamin Tingle | 19:45 |
| Re: Domain check taking place unnecessarily? | Laurenz Albe | 19:47 |
| Re: Window Functions & Table Partitions 📎 | David Rowley | 22:35 |
| max_wal_senders | Rick Otten | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: max_wal_senders | Laurenz Albe | 05:59 |
| Re: max_wal_senders | Andres Freund | 06:40 |
| Re: Domain check taking place unnecessarily? | Mark Hills | 10:56 |
| Re: Domain check taking place unnecessarily? | Mark Hills | 11:01 |
| Re: Domain check taking place unnecessarily? | Tom Lane | 15:10 |
| Re: Window Functions & Table Partitions | Benjamin Tingle | 17:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Domain check taking place unnecessarily? | Mark Hills | 10:49 |
| For loop execution times in PostgreSQL 12 vs 15 | Adithya Kumaranchath | 18:53 |
| Re: For loop execution times in PostgreSQL 12 vs 15 | Pavel Stehule | 19:35 |
| Re: For loop execution times in PostgreSQL 12 vs 15 | Pavel Stehule | 19:45 |
| Thread | Author | Time |
|---|---|---|
| Performance of UPDATE operation | Mkrtchyan, Tigran | 15:09 |
| Re: Performance of UPDATE operation | Laurenz Albe | 17:47 |
| Re: Performance of UPDATE operation | Oluwatobi Ogunsola | 20:52 |
| Re: For loop execution times in PostgreSQL 12 vs 15 | Andres Freund | 21:21 |
| Re: Performance of UPDATE operation | Jeff Janes | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: For loop execution times in PostgreSQL 12 vs 15 | Pavel Stehule | 05:53 |
| Thread | Author | Time |
|---|---|---|
| Connection forcibly closed remote server error. | aditya desai | 12:13 |
| Re: Connection forcibly closed remote server error. | aditya desai | 12:35 |
| Re: Connection forcibly closed remote server error. | Tom Lane | 14:58 |
| Re: Connection forcibly closed remote server error. | Jeff Janes | 18:36 |
| Re: Connection forcibly closed remote server error. | aditya desai | 18:55 |
| Re: Connection forcibly closed remote server error. | Ranier Vilela | 19:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Window Functions & Table Partitions | David Rowley | 03:18 |
| Thread | Author | Time |
|---|---|---|
| BRIN index worse than sequential scan for large search set | Mickael van der Beek | 16:40 |
| Re: BRIN index worse than sequential scan for large search set | Justin Pryzby | 17:19 |
| Re: BRIN index worse than sequential scan for large search set | Mickael van der Beek | 17:51 |
| Re: BRIN index worse than sequential scan for large search set | Justin Pryzby | 20:37 |
| Thread | Author | Time |
|---|---|---|
| Re: BRIN index worse than sequential scan for large search set | Tomas Vondra | 16:18 |
| Thread | Author | Time |
|---|---|---|
| INSERT statement going in IPC Wait_event | aditya desai | 20:40 |
| Re: INSERT statement going in IPC Wait_event | Andrew Dunstan | 21:36 |
| Thread | Author | Time |
|---|---|---|
| Planner choosing nested loop in place of Hashjoin | Praneel Devisetty | 12:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner choosing nested loop in place of Hashjoin | Samed YILDIRIM | 10:31 |
| Re: INSERT statement going in IPC Wait_event | Samed YILDIRIM | 10:37 |
| Huge Tables | André Rodrigues | 11:47 |
| Re: Planner choosing nested loop in place of Hashjoin | Jeff Janes | 22:13 |
| Thread | Author | Time |
|---|---|---|
| multicolumn partitioning help | James Robertson | 17:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Huge Tables | Rick Otten | 12:45 |
| Re: Huge Tables | André Rodrigues | 12:51 |
| Thread | Author | Time |
|---|---|---|
| Re: multicolumn partitioning help | Justin Pryzby | 17:54 |
| Re: multicolumn partitioning help | Laurenz Albe | 21:41 |
| Re: multicolumn partitioning help | James Robertson | 23:33 |
| Thread | Author | Time |
|---|---|---|
| Re: multicolumn partitioning help | Laurenz Albe | 07:37 |
| Re: multicolumn partitioning help | David Rowley | 20:46 |
| Re: multicolumn partitioning help | David Rowley | 21:20 |
| Thread | Author | Time |
|---|---|---|
| Explain plan shows fewer shared blocks when index+table compared to index alone? | Amin Jaffer | 06:21 |
| Re:Explain plan shows fewer shared blocks when index+table compared to index alone? | Sergei Kornilov | 07:51 |
| Why are commits consuming most of the database time? | Tim Slechta | 14:46 |
| Re: Why are commits consuming most of the database time? | Tom Lane | 14:57 |
| Re: Why are commits consuming most of the database time? | Tim Slechta | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Query unable to utilize index without typecast to fixed length character | ahi | 10:23 |
| Re: Query unable to utilize index without typecast to fixed length character | Tom Lane | 14:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Query unable to utilize index without typecast to fixed length character | ahi | 07:09 |
| Is there any tool which will help me run and explain analyze about 150 queries? | kunwar singh | 17:57 |
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | Achilleas Mantzios | 18:19 |
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | kyle Hailey | 18:40 |
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | kunwar singh | 20:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | Jerry Sievers | 04:40 |
| RE: Query unable to utilize index without typecast to fixed length character | msalais | 17:58 |
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | kyle Hailey | 21:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | kunwar singh | 22:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Replication lag due to lagging restart_lsn | milist ujang | 03:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Is there any tool which will help me run and explain analyze about 150 queries? | Michael Christofides | 09:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Replication lag due to lagging restart_lsn | milist ujang | 10:41 |
| Postgres Metrics | André Rodrigues | 11:04 |
| Re: Postgres Metrics | Joe Conway | 14:53 |
| Thread | Author | Time |
|---|---|---|
| speeding up grafana sensor-data query on raspberry pi 3 | Clemens Eisserer | 17:00 |
| Re: speeding up grafana sensor-data query on raspberry pi 3 | Justin Pryzby | 17:15 |
| Re: speeding up grafana sensor-data query on raspberry pi 3 | David Rowley | 20:50 |
| Re: speeding up grafana sensor-data query on raspberry pi 3 | Andres Freund | 22:10 |
| Thread | Author | Time |
|---|---|---|
| Re: speeding up grafana sensor-data query on raspberry pi 3 | Luiz Felipph | 19:06 |
| Thread | Author | Time |
|---|---|---|
| Re: time sorted UUIDs | peter plachta | 00:25 |
| High QPS, random index writes and vacuum | peter plachta | 00:35 |
| Re: High QPS, random index writes and vacuum | Peter Geoghegan | 00:38 |
| Re: High QPS, random index writes and vacuum | Tom Lane | 02:01 |
| Re: High QPS, random index writes and vacuum | David Rowley | 02:40 |