Compressed Backup too big

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Compressed Backup too big
Date: 2007-11-15 18:35:35
Message-ID: fhi3jc$18oq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"
Database size in disk returned by pg_database_size() is 210 MB

Database compressesed backup file size is now 125 MB.
This seems too much. I expect compression to decrease size 10 times, also
indexes are not backed up. A year ago compressed backup size was 9 MB only.

I created query returning biggest tables with and without indexes and found:

1 pg_toast_22185 95 MB 96 MB
2 rid 21 MB 27 MB
3 klient 13 MB 19 MB
4 mailbox 10 MB 11 MB
5 dok 7640 kB 12 MB
6 desktop 8080 kB 8200 kB
7 strings 5536 kB 6584 kB
8 pg_toast_22338 5232 kB 5368 kB

...

Questions:

1. Tables are relatively small and thus cannot create 125 MB compressed
backup file.
Why backup file sis so big ?

2. How to determine what data is containing in pg_toast_22185 ?
Why this is so big ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2007-11-15 18:36:39 Re: 8.3 vs 8.2 sql compatiblity issue
Previous Message Andrew Sullivan 2007-11-15 18:30:13 Re: Postgresql and resource isolation