| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | <nickf(at)ontko(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Cc: | <angch(at)bytecraft(dot)com(dot)my>, "Vincent van Leeuwen" <pgsql(dot)spam(at)vinz(dot)nl> |
| Subject: | Re: Sanity check requested |
| Date: | 2003-07-18 19:07:00 |
| Message-ID: | 200307181207.00746.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Nick,
> ...About one year ago I considered moving to a journaling file system, but
> opted not to because it seems like that's what WAL does for us already. How
> does putting a journaling file system under it add more reliability?
It lets you restart your server quickly after an unexpected power-out. Ext2
is notoriously bad about this.
Also, WAL cannot necessarily recover properly if the underlying filesystem is
corrupted.
> I also guessed that a journaling file system would add overhead because now
> a write to the WAL file could itself be deferred and logged elsewhere.
You are correct.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-07-18 19:12:47 | Re: Sanity check requested |
| Previous Message | Nick Fankhauser | 2003-07-18 19:01:57 | Re: Sanity check requested |