Thread: pg_largeobject vs pg_toast_XXXX

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?

No takers?
Some background I've changed my TOAST type from EXTENDED to MAIN.

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