Mailing lists [pgsql-performance]

1 December 2022

• 20:05   Re: Catching up with performance & PostgreSQL 15 Andrew Dunstan

2 December 2022

• 03:52   Odd Choice of seq scan Paul McGarry
• 04:21   Re: Odd Choice of seq scan Justin Pryzby
• 08:37   Re: Odd Choice of seq scan Ronuk Raval
• 09:16   Re: Odd Choice of seq scan Tom Lane
• 11:04   Re: Odd Choice of seq scan Paul McGarry
• 22:35   Re: Odd Choice of seq scan Chris Hoover

4 December 2022

• 06:50   Re: Catching up with performance & PostgreSQL 15 Jeff Janes

6 December 2022

• 05:28   wrong rows and cost estimation when generic plan James Pang
• 08:28   RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• 08:29   RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• 08:59   Re: wrong rows and cost estimation when generic plan David Rowley
• 10:16   RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• 12:04   Re: wrong rows and cost estimation when generic plan David Rowley

13 December 2022

• 03:29   Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich

14 December 2022

• 15:38   Re: Increased iowait and blk_read_time with higher shared_buffers Samed YILDIRIM
• 21:12   Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• 21:27   Re: Increased iowait and blk_read_time with higher shared_buffers Tom Lane
• 21:32   Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• 21:41   Re: Increased iowait and blk_read_time with higher shared_buffers Samed YILDIRIM
• 21:43   Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• 23:03   creating hash indexes Rick Otten
• 23:28   Re: creating hash indexes Peter Geoghegan

15 December 2022

• 00:56   time sorted UUIDs Tim Jones
• 11:12   DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 11:22   DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 11:38   Re: DML sql execution time slow down PGv14 compared with PGv13 Samed YILDIRIM
• 11:44   RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 11:46   RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 13:42   Re: DML sql execution time slow down PGv14 compared with PGv13 David Rowley
• 14:34   RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 14:59   Re: time sorted UUIDs Laurenz Albe
• 15:05   Re: time sorted UUIDs Adrien Nayrat
• 15:19   RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)

16 December 2022

• 16:30   JSON down performacen when id:1 Render Comunicacion S.L.
• 18:06   Re: JSON down performacen when id:1 Tom Lane
• 18:24   Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
• 19:06   Re: Postgres12 looking for possible HashAggregate issue workarounds? Justin Pryzby
• 20:01   Re: JSON down performacen when id:1 Render Comunicacion S.L.
• 20:47   RE: Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís

18 December 2022

• 14:06   Re: Postgres12 looking for possible HashAggregate issue workarounds? David Rowley
• 14:48   temp_file_limit? Frits Jalvingh
• 18:57   Re: temp_file_limit? Justin Pryzby
• 20:29   Fwd: temp_file_limit? Frits Jalvingh
• 22:28   Re: Fwd: temp_file_limit? Tom Lane
• 23:10   Re: Fwd: temp_file_limit? Justin Pryzby

19 December 2022

• 03:51   Re: Fwd: temp_file_limit? Thomas Munro
• 03:53   Re: Fwd: temp_file_limit? Thomas Munro
• 12:47   Re: Fwd: temp_file_limit? Frits Jalvingh
• 15:15   Re: Fwd: temp_file_limit? Ranier Vilela
• 17:45   Re: Fwd: temp_file_limit? Frits Jalvingh
• 17:52   Re: Fwd: temp_file_limit? Ranier Vilela
• 18:01   Re: Fwd: temp_file_limit? Frits Jalvingh
• 19:50   RE: Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
• 19:57   Re: Fwd: temp_file_limit? Frits Jalvingh
• 20:15   Re: Fwd: temp_file_limit? Justin Pryzby
• 20:27   Re: Fwd: temp_file_limit? Frits Jalvingh
• 20:46   Re: Fwd: temp_file_limit? Justin Pryzby
• 22:29   Re: Fwd: temp_file_limit? Frits Jalvingh
• 22:42   Re: Fwd: temp_file_limit? Ranier Vilela
• 22:50   Re: Fwd: temp_file_limit? Justin Pryzby
• 22:59   Re: Fwd: temp_file_limit? Frits Jalvingh
• 23:07   Re: Fwd: temp_file_limit? Thomas Munro
• 23:10   Re: Fwd: temp_file_limit? Frits Jalvingh
• 23:32   Re: Fwd: temp_file_limit? Frits Jalvingh

21 December 2022

• 00:11   Re: Fwd: temp_file_limit? Justin Pryzby

23 December 2022

• 11:12   Re: Fwd: temp_file_limit? Frits Jalvingh

28 December 2022

• 18:39   When you really want to force a certain join type? Gunther Schadow
• 18:48   Re: When you really want to force a certain join type? Justin Pryzby

29 December 2022

• 10:31   Re: When you really want to force a certain join type? Gunther Schadow
• 10:52   Re: When you really want to force a certain join type? Tom Lane

31 December 2022

• 15:26   How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 17:32   Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Justin Pryzby