Re: pg_largeobject vs pg_toast_XXXX

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: pg_largeobject vs pg_toast_XXXX
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C206B93593@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: pg_largeobject vs pg_toast_XXXX  (bubba postgres <bubba.postgres@gmail.com>)
Список pgsql-general
bubba postgres wrote:
> No takers?
> Some background I've changed my TOAST type from EXTENDED to MAIN.

> After some changes on my DB I notice that where I used to have a large
pg_toast_XXXXX table, I
> now have a large pg_largeobject table.
> Can't find an explanation of the difference between the two, could
someone enlighten me?

There is no connection between TOAST tables and pg_largeobject, which
holds large objects.

Changing TOAST strategy from EXTENDED to MAIN will give you a larger
main table and a smaller TOAST table.

See
http://www.postgresql.org/docs/current/static/storage-toast.html

Try \lo_list at your psql prompt to see why your large object table
is big.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Problem with selecting arrays in set-returning plpgsql function
Следующее
От: Michael Graham
Дата:
Сообщение: Vacuum as "easily obtained" locks