Andrus wrote:
> 2. How to determine what data is containing in pg_toast_22185 ?
> Why this is so big ?
>
That will be determined by the columns you define and the data you insert.
Read http://www.postgresql.org/docs/8.2/interactive/storage-toast.html
to get an explanation of TOAST and how you can change the settings if
you wish.
This is most likely the reason for your "lack of compression" - the data
in the toast tables is most likely already compressed data so will be
close to a 1-1 export size.
--
Shane Ambler
pgSQL(at)Sheeky(dot)Biz
Get Sheeky @ http://Sheeky.Biz