Re: Patch: add timing of buffer I/O requests - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: Patch: add timing of buffer I/O requests
Date
Msg-id m2aa7gue4y.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Patch: add timing of buffer I/O requests  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: Patch: add timing of buffer I/O requests  (Tomas Vondra <tv@fuzzy.cz>)
Re: Patch: add timing of buffer I/O requests  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Tomas Vondra" <tv@fuzzy.cz> writes:
> Another option would be to reimplement the vsyscall, even on platforms
> that don't provide it. The principle is actually quite simple - allocate a
> shared memory, store there a current time and update it whenever a clock
> interrupt happens. This is basically what Greg suggested in one of the
> previous posts, where "regularly" means "on every interrupt". Greg was
> worried about the precision, but this should be just fine I guess. It's
> the precision you get on Linux, anyway ...

That sounds good for other interesting things, which entails being able
to have timing information attached to the XID sequence.  If we go this
way, how far are we from having a ticker in PostgreSQL?

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Stefan Keller
Date:
Subject: Re: odbc_fdw
Next
From: Andrew Dunstan
Date:
Subject: Re: pg_upgrade automatic testing