| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Arjen van der Meijden" <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> |
| Cc: | "'Andrew McMillan'" <andrew(at)catalyst(dot)net(dot)nz>, "'Alexander Priem'" <ap(at)cict(dot)nl>, "'PgSQL Performance ML'" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Tuning PostgreSQL |
| Date: | 2003-07-26 14:12:35 |
| Message-ID: | 9304.1059228755@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Arjen van der Meijden" <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> writes:
> Well, reboting is not a problem with ext2, but crashing might be... And
> normally you don't plan a systemcrash ;)
> Ext3 and xfs handle that much better.
A journaling filesystem is good to use if you can set it to journal
metadata but not file contents. PG's WAL logic can recover lost file
contents, but we have no way to help out the filesystem if it's lost
metadata.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Balazs Wellisch | 2003-07-26 21:08:34 | Re: Tuning PostgreSQL |
| Previous Message | HansH | 2003-07-26 10:53:23 | Re: Wrong plan or what ? |