Re: Storing Snapshot Data

John Gibson <gib@edgate.com> writes:
> Unfortunately, I am stuck on how to get all three into the monitor table
> with the same timestamp.

Do all the work in a single SERIALIZABLE transaction.  That gives you a
static, consistent view of the database for as long as you need.

            regards, tom lane