FAQ
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/

Search Discussions

  • Tom Lane at Jul 29, 2003 at 9:42 pm

    "Freddy Mnjvr" <mmfreddy@hotmail.com> 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJul 29, '03 at 5:00p
activeJul 29, '03 at 9:42p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Freddy Mnjvr: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2021 Grokbase