From: | Johnes Castro <johnescm(at)hotmail(dot)com> |
---|---|
To: | Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <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 17:53:50 |
Message-ID: | RO1P15201MB24262B411A11CC04D6347DAED4020@RO1P15201MB2426.LAMP152.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
1 wal by default occupies 16MB.
The parameter in version 9.2 that controls this is: wal_keep_segments
By setting the parameter to 10, the maximum size of the US pg_xlog will be 160MB.
Best Regards,
Johnes Castro
________________________________
De: Johnes Castro <johnescm(at)hotmail(dot)com>
Enviado: quarta-feira, 5 de setembro de 2018 15:48
Para: Raghavendra Rao J S V; pgsql-general(at)lists(dot)postgresql(dot)org
Assunto: RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version
Hi,
This page in the documentation can help you.
https://www.postgresql.org/docs/9.2/static/wal-configuration.html
Best Regards,
Johnes Castro
PostgreSQL: Documentation: 9.2: WAL Configuration<https://www.postgresql.org/docs/9.2/static/wal-configuration.html>
29.4. WAL Configuration. There are several WAL-related configuration parameters that affect database performance.This section explains their use. Consult Chapter 18 for general information about setting server configuration parameters.. Checkpoints are points in the sequence of transactions at which it is guaranteed that the heap and index data files have been updated with all information ...
www.postgresql.org
________________________________
De: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
Enviado: quarta-feira, 5 de setembro de 2018 15:39
Para: pgsql-general(at)lists(dot)postgresql(dot)org
Assunto: Max number of WAL files in pg_xlog directory for Postgres 9.2 version
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?
--
Regards,
Raghavendra Rao J S V
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-09-05 18:02:24 | Re: Full table lock dropping a foreign key |
Previous Message | Johnes Castro | 2018-09-05 17:48:41 | RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version |