On Wed, Sep 14, 2022 at 05:02:07PM +0200, [email protected] wrote:
> What could be the reason of a query, which is sometimes fast
> and sometimes slow (factor >10x)?
> (running on a large table).
>
>
Lots of possible issues. Is it using a different query plan ?
Collect a good plan and a bad one and compare, or send both.
Perhaps use autoexplain to do so.
Turn on logging and send as much information as you can as described
here.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Please try to configure your mail client to send text mail (instead of
or in addition to the html one).
--
Justin
