Re: WAL write of full pages

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL write of full pages
Date: 2004-03-15 21:14:32
Message-ID: 8765d53j9j.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Marty Scholes <marty(at)outputservices(dot)com> writes:

> * The array is no slower on random writes then sequential ones, which means
> that the benefits of writing to WAL vs. the data files are lost.

The main benefit is that if the system crashes or loses power that your
database isn't lost.

--
greg

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2004-03-15 21:18:37 Re: WAL write of full pages
Previous Message Andrew Dunstan 2004-03-15 21:05:30 Re: listening addresses