| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Max number of WAL files in pg_xlog directory for Postgres 9.2 version |
| Date: | 2018-09-05 19:04:25 |
| Message-ID: | 49d01b56-1551-cec2-2db1-e2b5111c72ff@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2018-09-05 19:18:40 | Re: Max number of WAL files in pg_xlog directory for Postgres 9.2 version |
| Previous Message | Tom Lane | 2018-09-05 19:03:33 | Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) |