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.
On Thu, Jul 28, 2011 at 10:50 AM, bubba postgres
<bubba.postgres@gmail.com>wrote:
Show quoted text
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?
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