Dirty reads on index scan,

2023-09-21 Thread Koen De Groote
gh memory? Something else? Any help would be appreciated. I'm using the analysis methods explained here to gather this data: https://github.com/dalibo/pev2 Regards, Koen De Groote

Re: Dirty reads on index scan,

2023-09-22 Thread Koen De Groote
. Is this just going to get slower and slower and there's nothing that can be done about it? Regards, Koen De Groote On Thu, Sep 21, 2023 at 9:30 PM Laurenz Albe wrote: > On Thu, 2023-09-21 at 17:05 +0200, Koen De Groote wrote: > > I'm doing the following query: > > sel

Re: Dirty reads on index scan,

2023-09-22 Thread Koen De Groote
plus tune for more frequent vacuuming of the table. I'll look into that. Thanks for the advice, both of you. Regards, Koen De Groote On Fri, Sep 22, 2023 at 3:22 PM Frits Hoogland wrote: > The actual thing that might be good to see is the query plan (explain). > It is commonly regarded an