On 6/5/13 3:49 PM, Robert Haas wrote:
Now, I did find a couple that I thought should probably stick with
SnapshotNow, specifically pgrowlocks and pgstattuple.
FWIW, I've often wished for a way to make all stat access transactional, across all the stats views. Perhaps that couldn't be done by default, but I'd love something like a function that would make a "snapshot" of all stats data as of one point. Even if that snapshot itself wasn't completely atomic, at least then you could query any stats views however you wanted and know that the info wasn't changing over time.

The reason I don't think this would work so well if done in userspace is how long it would take. Presumably making a complete backend-local copy of pg_proc etc and the stats file would be orders of magnitude faster than a bunch of CREATE TEMP TABLE's.
Jim C. Nasby, Data Architect jim@nasby.net
512.569.9461 (cell) http://jim.nasby.net

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 23 of 43 | next ›
Discussion Overview
grouppgsql-hackers @
postedMay 22, '13 at 2:18a
activeJul 6, '13 at 1:07p



site design / logo © 2021 Grokbase