Re: Raw size

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Raw size
Date: 2005-03-11 01:27:03
Message-ID: 4230F3E7.9060003@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

  • Raw size at 2005-03-10 18:07:13 from Ioannis Theoharis

Responses

  • Re: Raw size at 2005-03-11 13:23:27 from Ioannis Theoharis

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2005-03-11 01:29:49 Re: [pgsql-hackers-win32] snprintf causes regression
Previous Message Thomas Hallgren 2005-03-11 00:36:31 Re: Runtime accepting build discrepancies