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 |