Horton

Re: Raw size

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

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Ioannis Theoharis <theohari@ics.forth.gr>
Cc: pgsql-hackers@postgresql.org
Date: 2005-03-12T02:30:57Z
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