2007/11/15, Andrus <kobruleht2@xxxxxx>:> "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.
How do you produce this dump? pg_dump -Fc ?
If you create plain dump ( pg_dump DBNAME > dump.file ) and zip it(normal deflate, like winzip or sth like that), what's the size?
If this is much smaller than 125MB, maybe you got some corner casewith postgres builtin compression.
You cannot *always* expect 10x ratio... it depends on data. Maybeusage patterns of your database changed and now the data is lesscompressable?
-- Filip Rembiałkowski
---------------------------(end of broadcast)---------------------------TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
