Re: Intermittent Query Performance Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Murthy Nunna <mnunna@xxxxxxxx>
Subject: Re: Intermittent Query Performance Issue
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Fri, 19 Apr 2024 21:10:22 -0600
Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <DM8PR09MB6677DA47FC6D842AEEF5D8EAB80C2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: <DM8PR09MB66772143CBEAD3538AB98906B80D2@DM8PR09MB6677.namprd09.prod.outlook.com> <CANzqJaCrc92PgnogA7o9qHuG3geAZjou8ZJyvYYE9c-nDGTYJQ@mail.gmail.com> <DM8PR09MB6677DA47FC6D842AEEF5D8EAB80C2@DM8PR09MB6677.namprd09.prod.outlook.com>

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.

References:
- Intermittent Query Performance Issue
  - From: Murthy Nunna
- Re: Intermittent Query Performance Issue
  - From: Ron Johnson
- RE: Intermittent Query Performance Issue
  - From: Murthy Nunna

Prev by Date: RE: Intermittent Query Performance Issue
Next by Date: Re: Bg_writer and checkpointer
Previous by thread: RE: Intermittent Query Performance Issue
Next by thread: Re: Intermittent Query Performance Issue
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux