Re: Array, bytea and large objects

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема Re: Array, bytea and large objects
Дата
Msg-id 92869e660902051032v58b3f06dl281d442e487c1899@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Array, bytea and large objects  (David Wall <d.wall@computer.org>)
Список 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 по дате отправления:

Предыдущее
От: David Wall
Дата:
Сообщение: Re: Array, bytea and large objects
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Pet Peeves?