| Lists: | pgsql-performance |
|---|
| From: | Laszlo Nagy <gandalf(at)shopzeus(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) |
| Date: | 2008-09-24 10:18:23 |
| Message-ID: | 48DA13EF.3060103@shopzeus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
| From: | "Claus Guttesen" <kometen(at)gmail(dot)com> |
|---|---|
| To: | "Laszlo Nagy" <gandalf(at)shopzeus(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) |
| Date: | 2008-09-24 10:39:23 |
| Message-ID: | b41c75520809240339t7f74278eu4d314b5f4b21b7f5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
| From: | "Artis Caune" <artis(dot)caune(at)gmail(dot)com> |
|---|---|
| To: | "Laszlo Nagy" <gandalf(at)shopzeus(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) |
| Date: | 2008-09-24 10:52:44 |
| Message-ID: | 9e20d71e0809240352q3c7f1478qfa2a78aac95eb6f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
On Wed, Sep 24, 2008 at 1:18 PM, Laszlo Nagy <gandalf(at)shopzeus(dot)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
| From: | Axel Rau <Axel(dot)Rau(at)chaos1(dot)de> |
|---|---|
| To: | Laszlo Nagy <gandalf(at)shopzeus(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: UFS 2: soft updates vs. gjournal (AKA: Choosing a filesystem 2.) |
| Date: | 2008-09-24 15:05:34 |
| Message-ID: | 3936C50C-0D27-4D22-9782-9EA2BCC0385D@Chaos1.DE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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