Michel SALAIS
De : David G. Johnston
Envoyé : mercredi 19 janvier 2022 16:11
À : Ludwig Isaac Lim
Cc : pgsql-performa...@postgresql.org
Objet : Re: PostgreSQL 12.8 Same Query Same Execution Plan Different Time
On Wed, Jan 19, 2022 at 7:59 AM Ludwig Isaac Lim mailto:ludz_...@yahoo.com
On Wed, Jan 19, 2022 at 7:59 AM Ludwig Isaac Lim wrote:
>
> I noticed that different is actually in Nested Loop join. One is taking 2
> minutes, other is taking 12 seconds. I find this puzzling as I assume the
> nested loop should be done in memory.
>
Everything is done in memory, but the data h
