Postgres Pro
Downloads
Home   >   mailing lists

Re: Can PostgreSQL create new WAL files instead of reusing old ones? - Mailing list pgsql-general

From Jerry Jelinek
Subject Re: Can PostgreSQL create new WAL files instead of reusing old ones?
Date
Msg-id CACPQ5FpEY9CfUF6XKs5sBBuaOoGEiO8KD4SuX06wa4ATsesaqg@mail.gmail.com
Whole thread Raw
In response to Can PostgreSQL create new WAL files instead of reusing old ones?  (David Pacheco <dap@joyent.com>)
Responses Re: Can PostgreSQL create new WAL files instead of reusing old ones?  (David Pacheco <dap@joyent.com>)
Re: Can PostgreSQL create new WAL files instead of reusing old ones?  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view
As Dave described in his original email on this topic, we'd like to avoid recycling WAL files since that can cause performance issues when we have a read-modify-write on a file that has dropped out of the cache.

I have implemented a small change to allow WAL recycling to be disabled. It is visible at:

I'd appreciate getting any feedback on this.

Thanks,
Jerry

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Is there a way to be notified on the CREATE TABLE execution?
Next
From: Melvin Davidson
Date:
Subject: Re: Is there a way to be notified on the CREATE TABLE execution?