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.
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 |