Re: Array, bytea and large objects - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: Array, bytea and large objects
Date
Msg-id 92869e660902051032v58b3f06dl281d442e487c1899@mail.gmail.com
Whole thread Raw
In response to Re: Array, bytea and large objects  (David Wall <d.wall@computer.org>)
List pgsql-general


2009/2/5 David Wall <d.wall@computer.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.rembialkowski@gmail.com
http://filip.rembialkowski.net/

pgsql-general by date:

Previous
From: David Wall
Date:
Subject: Re: Array, bytea and large objects
Next
From: Peter Eisentraut
Date:
Subject: Re: Pet Peeves?