Re: Intermittent Query Performance Issue

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Intermittent Query Performance Issue
Date: 2024-04-20 03:10:22
Message-ID: 0573591A-B0F2-461D-9F3E-6DF303D9DB62@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I wonder if it could be cache eviction? You query runs fast when relevant parts of the table are in cache, and other times, other queries (or system activity) have forced that data out of cache.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2024-04-20 09:40:57 Re: Bg_writer and checkpointer
Previous Message Murthy Nunna 2024-04-20 02:44:57 RE: Intermittent Query Performance Issue