Re: Best practice - Mailing list pgsql-general

From Tom Lane
Subject Re: Best practice
Date
Msg-id 23276.987722491@sss.pgh.pa.us
Whole thread Raw
In response to Best practice  (geustace@godzone.net.nz)
List pgsql-general
geustace@godzone.net.nz writes:
> We use Ingres where I work and when setting up a server we always
> try to ensure that the log and data files are on different spindles.

This would be good practice in PG simply for performance reasons.
Ideally the WAL log should be on a disk that has nothing else to do,
so that you never have to seek somewhere else than the current WAL
segment.

I'm not sure that we can yet guarantee very much about recovery from
disk hardware failures.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Delete w/ regexp
Next
From: Phuong Ma
Date:
Subject: password authentication