RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version

[Johnes Castro <johnescm@xxxxxxxxxxx>]

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

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@xxxxxxxxx>
Enviado: quarta-feira, 5 de setembro de 2018 15:39
Para: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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