Re: Clock sweep not caching enough B-Tree leaf pages? - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: Clock sweep not caching enough B-Tree leaf pages?
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17CF2458@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: Clock sweep not caching enough B-Tree leaf pages?  (Jason Petersen <jason@citusdata.com>)
Responses Re: Clock sweep not caching enough B-Tree leaf pages?  (Atri Sharma <atri.jiit@gmail.com>)
List pgsql-hackers
Jason Petersen wrote:
> Yes, we obviously want a virtual clock. Focusing on the use of gettimeofday seems silly to me: it was
> something quick for the prototype.
> 
> The problem with the clocksweeps is they don’t actually track the progression of “time” within the
> PostgreSQL system.

Would it make sense to just cache the result of the latest gettimeofday() call
and use that as an approximation for wall time?
The busier the system is, the more accurate that should be.

Yours,
Laurenz Albe

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Clock sweep not caching enough B-Tree leaf pages?
Next
From: Atri Sharma
Date:
Subject: Re: Clock sweep not caching enough B-Tree leaf pages?