Re: Streaming Replication: Observations, Questions and Comments - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Streaming Replication: Observations, Questions and Comments
Date
Msg-id 201108241033.59785.ahodgson@simkin.ca
Whole thread Raw
In response to Streaming Replication: Observations, Questions and Comments  (Samba <saasira@gmail.com>)
Responses Re: Streaming Replication: Observations, Questions and Comments  (Samba <saasira@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: c k
Date:
Subject: Re: postgresql server crash on windows 7 when using plpython
Next
From: John R Pierce
Date:
Subject: Re: postgresql server crash on windows 7 when using plpython