Re: Raw size - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Raw size
Date
Msg-id 20050312103019.F88174@houston.internal
Whole thread Raw
In response to Re: Raw size  (Ioannis Theoharis <theohari@ics.forth.gr>)
List 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



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: partial vacuum
Next
From: Neil Conway
Date:
Subject: cvsup binaries?