Re: WAL directory size calculation - Mailing list pgsql-general

From Francisco Olarte
Subject Re: WAL directory size calculation
Date
Msg-id CA+bJJbwN260oC9Mj-sHsazUpQfh7uEu6FRSYhwPcDa9UyFAn+g@mail.gmail.com
Whole thread Raw
In response to WAL directory size calculation  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Responses Re: [SPAM] Re: WAL directory size calculation
List pgsql-general
On Thu, Jul 28, 2016 at 3:25 PM, Moreno Andreo <moreno.andreo@evolu-s.it> wrote:
> Obviously ramdisk will be times faster disk, but having a, say, 512 GB
> ramdisk will be a little too expensive :-)

Besides defeating the purpose of WAL, if you are going to use non
persistent storage for WAL you could as well use minimal level,
fsync=off and friends.

> Aside of this, I'm having 350 DBs that sum up a bit more than 1 TB, and plan
> to use wal_level=archive because I plan to have a backup server with barman.

Is this why you plan using RAM for WAL ( assuming fast copies to the
archive and relying on it for recovery ) ?

Francisco Olarte.


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Uber migrated from Postgres to MySQL