pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.)
4+ messages / 4 participants
[nested] [flat]
* UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.)
@ 2008-09-24 10:18 Laszlo Nagy <gandalf@shopzeus.com>
0 siblings, 3 replies; 4+ messages in thread
From: Laszlo Nagy @ 2008-09-24 10:18 UTC (permalink / raw)
To: pgsql-performance
Hi again,
Should I use gjournal on FreeBSD 7? Or just soft updates?
Here is my opinion: I suspect that gjournal would be much slower than
soft updates. Also gjournal is relatively new code, not very well
tested. But gjournal is better when the system crashes. Although I have
heard that sometimes gjournal will crash the system itself. There are
more pros for soft updates I would pefer that. But please let me
know if I'm wrong.
Thanks,
Laszlo
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.)
@ 2008-09-24 10:39 Claus Guttesen <kometen@gmail.com>
parent: Laszlo Nagy <gandalf@shopzeus.com>
2 siblings, 0 replies; 4+ messages in thread
From: Claus Guttesen @ 2008-09-24 10:39 UTC (permalink / raw)
To: Laszlo Nagy <gandalf@shopzeus.com>; +Cc: pgsql-performance
> Should I use gjournal on FreeBSD 7? Or just soft updates?
>
> Here is my opinion: I suspect that gjournal would be much slower than
> soft updates. Also gjournal is relatively new code, not very well
> tested. But gjournal is better when the system crashes. Although I have
> heard that sometimes gjournal will crash the system itself. There are
> more pros for soft updates I would pefer that. But please let me
> know if I'm wrong.
If softupdates suites your needs why not just use that? :-) Is
performance adequate with softupdates? I have a 103 GB db on FreeBSD
7.0 and softupdates and it has survived one unplanned stop when we had
a power-outage lasting some hours.
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.
Shakespeare
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.)
@ 2008-09-24 10:52 Artis Caune <artis.caune@gmail.com>
parent: Laszlo Nagy <gandalf@shopzeus.com>
2 siblings, 0 replies; 4+ messages in thread
From: Artis Caune @ 2008-09-24 10:52 UTC (permalink / raw)
To: Laszlo Nagy <gandalf@shopzeus.com>; +Cc: pgsql-performance
On Wed, Sep 24, 2008 at 1:18 PM, Laszlo Nagy <gandalf@shopzeus.com> wrote:
> Here is my opinion: I suspect that gjournal would be much slower than
> soft updates. Also gjournal is relatively new code, not very well
> tested.
In some cases it's much faster than SU, in other a bit slower. :)
gjournal is quiet "old" code, it's already more than two years around,
and very stable. Haven't seen any gjournal related crash.
--
regards,
Artis Caune
<----. CCNA
<----|====================
<----' didii FreeBSD
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.)
@ 2008-09-24 15:05 Axel Rau <Axel.Rau@chaos1.de>
parent: Laszlo Nagy <gandalf@shopzeus.com>
2 siblings, 0 replies; 4+ messages in thread
From: Axel Rau @ 2008-09-24 15:05 UTC (permalink / raw)
To: Laszlo Nagy <gandalf@shopzeus.com>; +Cc: pgsql-performance
Am 24.09.2008 um 12:18 schrieb Laszlo Nagy:
> Should I use gjournal on FreeBSD 7? Or just soft updates?
I'm using gjournal for 5 weeks now on my production server.
There are 4 journaled filesystems on a raid controller with
BBU. pg uses 23GB out of 1.6TB. I can't see any performance impact or
other issue.
Recovery from an unclean shutdown took less than a minute as compared
to half an hour with ufs2/softupdates/fsck.
However I'm still unsure if I should enable async mounts of rhe fs
with tablespaces/WAL.
Anybody giving me advice?
Axel
--- ar3
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-09-24 15:05 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-24 10:18 UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) Laszlo Nagy <gandalf@shopzeus.com>
2008-09-24 10:39 ` Claus Guttesen <kometen@gmail.com>
2008-09-24 10:52 ` Artis Caune <artis.caune@gmail.com>
2008-09-24 15:05 ` Axel Rau <Axel.Rau@chaos1.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox