Re: Postgres hash tables

From: Nailah Ogeer <ogeer(at)cs(dot)queensu(dot)ca>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres hash tables
Date: 2003-07-24 19:21:41
Message-ID: Pine.SOL.4.33.0307241514060.9356-100000@innovate
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Sorry to bother you again but i am having a real hard time getting stats
from the relation. What i have is a shared memory linked list of
relfilenodes. I simply want to get the stats of all these relations and
add them up. I was using pgstat_fetch_stat_tabentry(relid) as an sql
statement and this worked beautifully.
Now i am trying to do it at every
checkpoint before flushing all relations. BUt the above fetch
function does not work. So then i tried getting the stat info from the
relation itself but am having problems with the
RelationNodeCacheGetRelation function which always seems to give me null.
Can you tell me how i can get this info in the backend???
I can see the relation in my list and there is a matching relation in
pg_class. I just need to get the relationdesc back

Responses

  • File Cache at 2003-07-30 21:03:57 from Nailah Ogeer

Browse pgsql-general by date

  From Date Subject
Next Message greg 2003-07-24 19:32:27 Re: List last value of all sequences
Previous Message R C 2003-07-24 19:17:17 Problem install DBD-pg in Redhat Linux 7.2

Browse pgsql-hackers by date

  From Date Subject
Next Message ivan 2003-07-24 20:22:05 Re: perm bug ?
Previous Message Tom Lane 2003-07-24 19:04:59 Re: odd behavior/possible bug