table names

From: "K(dot) Ari Krupnikov" <ari(at)cogsci(dot)ed(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: table names
Date: 2001-11-16 16:08:04
Message-ID: 3BF539E4.4F965A4E@cogsci.ed.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

from 7.1 release notes:

> Store tables as files named by OID (Vadim)

until i upgraded to 7.1(.3), i used to track table sizes simply with ls
-l. is there a simple way to see how much space a table takes on disk,
short of

select 'ln -s ' || oid || ' ' || relname from pg_class
where relname not like 'pg%';

ari.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel Fernandez 2001-11-16 16:31:49 Re: Precision problems with float8
Previous Message Tom Lane 2001-11-16 16:06:16 Re: Poor performance on SCSI machines, good on IDE?