Home > mailing lists

strange slow query - lost lot of time somewhere - Mailing list pgsql-hackers

From	Pavel Stehule
Subject	strange slow query - lost lot of time somewhere
Date	May 2, 2022 11:59:33
Msg-id	CAFj8pRAMp=QsMi6sPQJ4W3hczoFJRvyXHJV3AZAZaMyTVM312Q@mail.gmail.com Whole thread Raw
Responses	Re: strange slow query - lost lot of time somewhere Re: strange slow query - lost lot of time somewhere
List	pgsql-hackers

Tree view

I found a query that is significantly slower with more memory

plan 1 - fast https://explain.depesz.com/s/XM1f

plan 2 - slow https://explain.depesz.com/s/2rBw

Strange - the time of last row is +/- same, but execution time is 10x worse

It looks like slow environment cleaning

pgsql-hackers by date:

From: Peter Eisentraut
Date: 02 May 2022, 11:38:59
Subject: Refactor construct_array() and deconstruct_array() for built-in types

From: Amit Kapila
Date: 02 May 2022, 12:09:36
Subject: Re: Perform streaming logical transactions by background workers and parallel apply

strange slow query - lost lot of time somewhere - Mailing list pgsql-hackers

Previous

Next