Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA33724 for ; Wed, 14 Jul 1999 09:36:37 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id JAA25331; Wed, 14 Jul 1999 09:35:14 -0400 (EDT) To: webmaster@tony.cz cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] SQL query to check size of database In-reply-to: Your message of Wed, 14 Jul 1999 14:52:46 +0200 <99071415050002.01288@localhost.localdomain> Date: Wed, 14 Jul 1999 09:35:14 -0400 Message-ID: <25329.931959314@sss.pgh.pa.us> From: Tom Lane webmaster 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