Re: Raw size - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Raw size
Date
Msg-id 4230F3E7.9060003@familyhealth.com.au
Whole thread Raw
In response to Raw size  (Ioannis Theoharis <theohari@ics.forth.gr>)
Responses Re: Raw size
List 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


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Runtime accepting build discrepancies
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: [pgsql-hackers-win32] snprintf causes regression