Re: Query is sometimes fast and sometimes slow: what could be the reason?

2022-09-14 Thread Justin Pryzby
On Wed, Sep 14, 2022 at 05:02:07PM +0200, tias...@gmx.de 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

Query is sometimes fast and sometimes slow: what could be the reason?

2022-09-14 Thread tiaswin
What could be the reason of a query, which is sometimes fast and sometimes slow (factor >10x)? (running on a large table).