general table stats, ideas ?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: general table stats, ideas ?
Date: 2008-10-07 16:47:01
Message-ID: 2f4958ff0810070947n24b9805y67d30679bd4c78d2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey folks,
I want to do a fairly simple thing, but so far I see no way in which this
could be implemented with postgresql. So I decided to ask folks here.
My problem is, I need to benchmark set of tables, where - we can assume -
schema of each table is unknown, and we have no assumption on any fields
being present there. (altho, if there is no other way to do it, we could
assume id bigint not null default nextval('someseq'));

basically, I need to know when certain row was selected (read), and when it
was updated/created (insert). For that I need two fields.
And although former could be done, and I more or less know how to do it (I
think it can be done with rule, and default = now()) - I have yet to find a
way on how to do the same thing for select.

If someone loves a challenge, and is able to provide me with an answer to my
problem - please do so. Also, if this can be done, but with slightly
different requirements - please let me know too.

Thanks, this is my first post here - so welcome you guys

--
GJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2008-10-07 16:55:09 Re: general table stats, ideas ?
Previous Message johnf 2008-10-07 16:18:16 Re: localhost (windows) performance