webmaster <webmaster(at)tony(dot)cz> writes:
> Is there any way how to retrieve the information about file sizes with
> some SQL query? I know I can do something like SELECT * FROM
> pg_classes but I'm not sure if i can use the information from fields
> 'reltuples' and 'relpages' - I was experimenting with those values but
> without succes - trying to find the constant value of the page size -
> it seems not work.
I think relpages is accurate after a VACUUM, but it's not maintained
on-the-fly...
regards, tom lane