| 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: | Whole Thread | Raw Message | 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 |