Re: Postgres hash tables

Поиск
Список
Период
Сортировка
От Nailah Ogeer
Тема Re: Postgres hash tables
Дата
Msg-id Pine.SOL.4.33.0307241514060.9356-100000@innovate
обсуждение исходный текст
Ответы File Cache  (Nailah Ogeer <ogeer@cs.queensu.ca>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Adam Haberlach
Дата:
Сообщение: Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: odd behavior/possible bug