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

Hi John, As you said, I have gone through the document. Which one is correct [(2 + checkpoint_completion_target) * checkpoint_segments + 1 *or* checkpoint_segments + wal_keep_segments + 1 files] for

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

Am 05.09.2018 um 19:39 schrieb Raghavendra Rao J S V: Hi All, We are using postgres 9.2 verstion database. 9.2 is out of support. Please consider a upgrade. soon! Please let me know, how many max number of wal files in pg_xlog directory? depends on the workload and on several

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

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

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

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 Enviado: quarta-feira, 5 de

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 29.4. WAL Configuration. There are

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?