On Mon, May 2, 2022 at 10:02 PM Pavel Stehule <[email protected]> wrote:
> > > út 3. 5. 2022 v 6:57 odesílatel Tom Lane <[email protected]> napsal: > >> Pavel Stehule <[email protected]> writes: >> > there is really something strange (see attached file). Looks so this >> issue >> > is much more related to planning time than execution time >> >> You sure there's not something taking an exclusive lock on one of these >> tables every so often? >> > > I am almost sure, I can see this issue only every time when I set a higher > work mem. I don't see this issue in other cases. > >> >> What are the values of work_mem and hash_mem_multiplier for the two cases? David J.
