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-12 02:30:57
Message-ID: 20050312103019.F88174@houston.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> Is there any compression or what?
>>
>> Yes, there is:
>>
>> http://www.postgresql.org/docs/8.0/interactive/storage-toast.html
>
> thanks, is there any way to increase the limit, upper wich toast strategy
> is selected? By defaullt is Block_size/4 = about 2000 Bytes.

Dunno, but you can alter the column and go 'set storage' to control the
storage strategy for TOAST on the column...

Chris

In response to

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-03-12 02:45:31 Re: BUG #1466: syslogger issues
Previous Message Tatsuo Ishii 2005-03-12 02:26:19 Re: partial vacuum