Re: Compressed Backup too big

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@Sheeky.Biz

Get Sheeky @ http://Sheeky.Biz