Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] pg_xlog keeps growing - Mailing list pgsql-general

From dhanuj hippie
Subject [GENERAL] pg_xlog keeps growing
Date
Msg-id CAGqAkKc+PfqgTTubaTDzw2XKMF-AXdDs9PS--ymOLMbRp-uJ5Q@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] pg_xlog keeps growing  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view
Hi,

I have a postgres cluster running in hot_standby. I see the pg_xlog is growing over time (may files of size 16 MB each). The replication lag is very less ~2kB, and never goes into a bad state.
I'm manually resetting this once a while using pg_resetxlog command.
Is there a way to understand why my system keeps running into this problem ?

Thanks

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Shared WAL archive between master and standby: WALs notalways identical
Next
From: Rob Sargent
Date:
Subject: Re: [GENERAL] pg_xlog keeps growing