| From: | Andreas Kostyrka <andreas(at)mtg(dot)co(dot)at> |
|---|---|
| To: | eric soroos <eric-psql(at)soroos(dot)net> |
| Cc: | Shankar K <shan0075(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org, "Jeffrey D(dot)Brower" <jeff(at)pointhere(dot)net> |
| Subject: | Re: ext3 filesystem / linux 7.3 |
| Date: | 2003-04-02 15:13:19 |
| Message-ID: | 1049296398.20242.325.camel@andi-lap |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2003-04-01 at 19:53, eric soroos wrote:
> On Tue, 1 Apr 2003 09:39:17 -0800 (PST) in message <20030401173917(dot)19476(dot)qmail(at)web21101(dot)mail(dot)yahoo(dot)com>, Shankar K <shan0075(at)yahoo(dot)com> wrote:
> > hi jeff,
> >
> > go to
> > http://www.ca.postgresql.org/docs/momjian/hw_performance/
> > under 'filesystems' slide.
> >
>
> I suspect that is what he's seen.
>
> >From my experience, ext3 is only a percent or two slower than ext2 under pg_bench. It saves an amazing amount of time on startup after a failure by not having to fsck to confirm that the filesystem is in a consistent state.
>
> I believe that ext3 is a metadata journaling system, and not a data journaling system. This would indicate that the PG transactioning is complimentary to the filesystem journaling, not duplication.
It's both. See the -o data=journal|data=ordered|data=writeback mount
time option.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kostyrka | 2003-04-02 15:18:26 | Re: ext3 filesystem / linux 7.3 |
| Previous Message | Shridhar Daithankar | 2003-04-02 04:12:18 | Re: ext3 filesystem / linux 7.3 |