On August 24, 2011 08:33:17 AM Samba wrote: > One strange thing I noticed is that the pg_xlogs on the master have > outsized the actual data stored in the database by at least 3-4 times, > which was quite surprising. I'm not sure if 'restore_command' has anything > to do with it. I did not understand why transaction logs would need to be > so many times larger than the actual size of the database, have I done > something wrong somewhere?
If you archive them instead of keeping them in pg_xlog, you can gzip them. They compress reasonably well. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
