Re: Best practice

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: geustace(at)godzone(dot)net(dot)nz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best practice
Date: 2001-04-19 23:21:31
Message-ID: 23276.987722491@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

geustace(at)godzone(dot)net(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2001-04-19 23:29:15 Re: Cursors in plpgsql
Previous Message Tom Lane 2001-04-19 23:14:12 Re: Delete w/ regexp