Re: how to get postgresql page size?

Поиск
Список
Период
Сортировка
Искать

Re: how to get postgresql page size?

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Freddy Mnjvr"  writes:
> - I need to know the (PAGESIZE) value without reading postgresql source 
> files...

pg_controldata is the only way I can think of offhand.

			regards, tom lane

how to get postgresql page size?

От:
"Freddy Mnjvr" <mmfreddy@hotmail.com>
Дата:
Hi...

SELECT sum(relpages)* (PAGESIZE) FROM pg_class
WHERE relkind='r' AND relname = 'table'

I want to know how many disk space is a database table using something
like above

where (PAGESIZE) is the postgresql page size value.

how can I get the ??? value...

- I now default value for (PAGESIZE) is 8k, but if it was changed (BLCKSZ, 
postgresql.h)?
- I need to know the (PAGESIZE) value without reading postgresql source 
files...

-----------------------
Freddy Menjívar M.
ITCR

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.yupimsn.com/
FAQ