pgsql-performance - November 2020

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.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

Nov. 2, 2020

Thread	Author	Time
Re: Understanding bad estimate (related to FKs?)	Philip Semanchuk	19:09
Re: Understanding bad estimate (related to FKs?)	Justin Pryzby	19:53
Re: Understanding bad estimate (related to FKs?)	Tom Lane	20:08
Re: Understanding bad estimate (related to FKs?)	Guillaume Lelarge	20:48
Re: Understanding bad estimate (related to FKs?)	Michael Lewis	23:09

Nov. 3, 2020

Thread	Author	Time
Re: Understanding bad estimate (related to FKs?)	Tomas Vondra	03:17
Partition pruning with joins	Ehrenreich, Sigrid	13:20
Re: Understanding bad estimate (related to FKs?)	Philip Semanchuk	15:07
Re: Understanding bad estimate (related to FKs?)	Philip Semanchuk	15:27
Re: Partition pruning with joins	Laurenz Albe	15:45

Nov. 4, 2020

Thread	Author	Time
RE: Partition pruning with joins	Ehrenreich, Sigrid	08:47
Adding nextval() to a select caused hang/very slow execution	Eric Raskin	17:10
RE: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	17:19
Re: Adding nextval() to a select caused hang/very slow execution	Tom Lane	18:04
Re: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	18:22
Re: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	18:25
Re: Adding nextval() to a select caused hang/very slow execution	Tom Lane	19:01
Re: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	19:12
Re: Adding nextval() to a select caused hang/very slow execution	Tom Lane	19:23
Re: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	19:25
Re: Adding nextval() to a select caused hang/very slow execution	Tom Lane	19:35
Re: Partition pruning with joins	David Rowley	20:13
Re: Adding nextval() to a select caused hang/very slow execution	Michael Lewis	20:19
Re: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	20:39
Re: Adding nextval() to a select caused hang/very slow execution	Tom Lane	21:16

Nov. 5, 2020

Thread	Author	Time
Low cost query - running longer	Koteswara Rao Daliparthi	02:58
Re: Low cost query - running longer	David G. Johnston	03:02
Re: Adding nextval() to a select caused hang/very slow execution	Eric Raskin	04:10
RE: Partition pruning with joins	Ehrenreich, Sigrid	06:23

Nov. 10, 2020

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	18:45

Nov. 13, 2020

Thread	Author	Time
How to prioritise walsender reading from pg_wal over WAL writes?	Alexey Bashtanov	10:12

Nov. 17, 2020

Thread	Author	Time
Postgres using nested loops despite setting enable_nestloop to false	Frits Jalvingh	13:47
Install clustered postgres	Nunzia Vairo	13:54
Re: Postgres using nested loops despite setting enable_nestloop to false	Justin Pryzby	14:20
Re: Postgres using nested loops despite setting enable_nestloop to false 📎	Frits Jalvingh	15:58
Re: Postgres using nested loops despite setting enable_nestloop to false	Justin Pryzby	16:06
Re: Postgres using nested loops despite setting enable_nestloop to false	Frits Jalvingh	16:08
Re: Postgres using nested loops despite setting enable_nestloop to false	Frits Jalvingh	16:14
Re: Postgres using nested loops despite setting enable_nestloop to false	Tom Lane	16:21
Re: Postgres using nested loops despite setting enable_nestloop to false 📎	Frits Jalvingh	16:42

Nov. 18, 2020

Thread	Author	Time
Re: How to prioritise walsender reading from pg_wal over WAL writes?	Alexey Bashtanov	11:54
Re: How to prioritise walsender reading from pg_wal over WAL writes?	Laurenz Albe	12:11
Re: How to prioritise walsender reading from pg_wal over WAL writes?	Alexey Bashtanov	12:15
Re: How to prioritise walsender reading from pg_wal over WAL writes?	Laurenz Albe	16:20

Nov. 19, 2020

Thread	Author	Time
Re: Postgres using nested loops despite setting enable_nestloop to false	Frits Jalvingh	11:52
Re: How to prioritise walsender reading from pg_wal over WAL writes?	Alexey Bashtanov	13:38

Nov. 21, 2020

Thread	Author	Time
Simple update query is slow	Nandakumar M	20:27
Re: Simple update query is slow	Nandakumar M	20:48

Nov. 22, 2020

Thread	Author	Time
Re: Simple update query is slow	Justin Pryzby	17:30

Browse Archives

Prev | Next