Postgres Pro
Downloads
Home   >   mailing lists

Re: Max number of WAL files in pg_xlog directory for Postgres 9.2version - Mailing list pgsql-general

From Ron
Subject Re: Max number of WAL files in pg_xlog directory for Postgres 9.2version
Date
Msg-id 49d01b56-1551-cec2-2db1-e2b5111c72ff@gmail.com
Whole thread Raw
In response to Max number of WAL files in pg_xlog directory for Postgres 9.2 version  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view
On 09/05/2018 12:39 PM, Raghavendra Rao J S V wrote:
Hi All,

We are using postgres 9.2 verstion database.

Please let me know, how many max number of wal files in pg_xlog directory?

What is the formul. I am seeing different formulas. Could you provide me which decides number of max WAL files in PG_XLOG directory for Postgres 9.2 Database,please?

If you're doing WAL file replication, and -- for whatever reason -- the standby system isn't applying them fast enough, there could be tens of thousands of files in pg_xlog.  (It would drain pretty quickly when you resolve the problem, though.)


--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist)
Next
From: Andreas Kretschmer
Date:
Subject: Re: Max number of WAL files in pg_xlog directory for Postgres 9.2version