Re: Raw size

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Ioannis Theoharis <theohari@ics.forth.gr>
Cc: pgsql-hackers@postgresql.org
Date: 2005-03-11T01:27:03Z
Lists: pgsql-hackers
> BUT after clustering triples according to an index on att1:
> 
> 
> 
> select relname, relpages from pg_class ;
>              relname             | relpages
> ---------------------------------+----------
>  triples                         |      142  (8KB/buffer)
> 
> 142 * 8 * 1024 = 1,163,264 Bytes
> 
> 
> Is there any compression or what?

Yes, there is:

http://www.postgresql.org/docs/8.0/interactive/storage-toast.html

Chris