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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
