Re: Array, bytea and large objects

2009/2/5 David Wall <d(dot)wall(at)computer(dot)org>

>
>
>
>
>> Are the BYTEA fields stored in the same table as the rest of the data?
>
>
> yes - and the TOAST tables if it's larger than 1/3 of a page or so. search
> for TOAST details if you're interested.
>
> Hmm... So a page is 8192 bytes, and it leaves your regular table and goes
> to TOAST if the BYTEA is more than 2730 bytes. I thought it only went to
> TOAST when it exceed the page size, not just one-third of its size.
>

I wrote "or so" because I did not remember all details.
- check http://www.postgresql.org/docs/8.3/static/storage-toast.html
for 100% accurate explanation.

cheers
Filip

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/