2009/2/5 David Wall <[email protected]> > > > > >> 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:[email protected] http://filip.rembialkowski.net/
