Re: plan with result cache is very slow when work_mem is not enough - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: plan with result cache is very slow when work_mem is not enough
Date
Msg-id CAFj8pRBintst178s1NKdVtSAbkz+EKy2wWerOkNmM4ufT2UHRg@mail.gmail.com
Whole thread Raw
In response to Re: plan with result cache is very slow when work_mem is not enough  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers


ne 9. 5. 2021 v 3:01 odesílatel David Rowley <dgrowleyml@gmail.com> napsal:
On Sun, 9 May 2021 at 03:29, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Personally, I have not problem with too slow assertions, although it is not too practical. The main problem is some shock, and feeling so some is wrong. I spent 1 hour detecting if it is a bug or not.

Thanks for spending the time figuring out where the slowness came from.

> Can it be possible to identify this situation?
>
> Maybe use some specific name of this routine - like
>
> assert_only_check_xxxx
>
> Then I can see this warning in perf, and I don't need to do other or deeper checks

I don't think we need to go around leaving clues for people who run
perf on cassert builds. I think anyone doing that should just never
expect any meaningful results.

ok

Pavel

David

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: JSON doc example (matchiness)
Next
From: Amul Sul
Date:
Subject: Re: [Patch] ALTER SYSTEM READ ONLY