Thread: Journaling file systems

Journaling file systems

From
"Peter Darley"
Date:
Friends,
    I'm wondering if a journaling file system, like ext3, will make much
difference with the speed or reliability of PostgreSQL?  Is it worth the
work to switch over?
Thanks,
Peter Darley


Re: Journaling file systems

From
Jeff Self
Date:
Journaled file systems will typically slow down a database somewhat.

On Tue, 2002-02-26 at 10:29, Peter Darley wrote:
> Friends,
>     I'm wondering if a journaling file system, like ext3, will make much
> difference with the speed or reliability of PostgreSQL?  Is it worth the
> work to switch over?
> Thanks,
> Peter Darley
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930


Re: Journaling file systems

From
Naomi Walker
Date:
At 11:22 AM 2/26/02 -0500, Jeff Self wrote:
>Journaled file systems will typically slow down a database somewhat.
Yes, but will make booting ALOT faster.....  Plus, the ability to grow a
filesystem is very nice, and that is sometimes bundled in the products
(like Veritas).
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242


Re: Journaling file systems

From
"Peter Darley"
Date:
Jeff (or anyone else),
    Is there some kind of file system (for Linux) that will provide better
performance than ext2? XFS or ReiserFS maybe?
Thanks,
Peter Darley

-----Original Message-----
From: Jeff Self [mailto:jself@nngov.com]
Sent: Tuesday, February 26, 2002 8:22 AM
To: Peter Darley
Cc: Pgsql-Admin
Subject: Re: [ADMIN] Journaling file systems


Journaled file systems will typically slow down a database somewhat.

On Tue, 2002-02-26 at 10:29, Peter Darley wrote:
> Friends,
>     I'm wondering if a journaling file system, like ext3, will make much
> difference with the speed or reliability of PostgreSQL?  Is it worth the
> work to switch over?
> Thanks,
> Peter Darley
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930


Re: Journaling file systems

From
Bruce Momjian
Date:
Peter Darley wrote:
> Friends,
>     I'm wondering if a journaling file system, like ext3, will make much
> difference with the speed or reliability of PostgreSQL?  Is it worth the
> work to switch over?

Reports are that ext3, with its journalling overhead, is slower that
ext2.  At least that's what I remember.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Journaling file systems

From
"Radu-Adrian Popescu"
Date:
IMHO SGI's XFS is your best bet, as is has *very* good scalability on file
size and file count.
Also the .2 release removes a deadlock when the FS in under extreme (and i
mean extreme) usage.

> Jeff (or anyone else),
> Is there some kind of file system (for Linux) that will provide better
> performance than ext2? XFS or ReiserFS maybe?
> Thanks,
> Peter Darley
>
> -----Original Message-----
> From: Jeff Self [mailto:jself@nngov.com]
> Sent: Tuesday, February 26, 2002 8:22 AM
> To: Peter Darley
> Cc: Pgsql-Admin
> Subject: Re: [ADMIN] Journaling file systems
>
>
> Journaled file systems will typically slow down a database somewhat.


Re: Journaling file systems

From
Ragnar Kjørstad
Date:
On Tue, Feb 26, 2002 at 08:47:05AM -0800, Peter Darley wrote:
> > Friends,
> >     I'm wondering if a journaling file system, like ext3, will make much
> > difference with the speed or reliability of PostgreSQL?  Is it worth the
> > work to switch over?

PostgreSQL does not depend on journaling to be reliable.

>     Is there some kind of file system (for Linux) that will provide better
> performance than ext2? XFS or ReiserFS maybe?

Both XFS and reiserfs are generally a little bit faster than ext2, put
primarely on file-operations (craete, delete, lookup). For raw data
transfer it's more a hardware issue than a filessytem issue (but XFS may
be a few percent faster).


Data-journaling could potentially improve performance a lot. By doing
writes to the journal istead of the actual file the number of seeks is
reduced and fsync can complete much faster. ext3 support data journaling
out of the box (mount-option) and there are experimental patches for
reiserfs.

I'm not sure how much seeking is going on without data-journaling? Maybe
writes are just appended to the log? could someone say more about this?




--
Ragnar Kjørstad
Big Storage

Re: Journaling file systems

From
Jeff Self
Date:
There are articles over at IBM about journaled file systems. One of them
talked about incredible performance from ext3 in busy environments.  The
article is here:

http://www-106.ibm.com/developerworks/linux/library/l-fs8.html

On Tue, 2002-02-26 at 11:47, Peter Darley wrote:
> Jeff (or anyone else),
>     Is there some kind of file system (for Linux) that will provide better
> performance than ext2? XFS or ReiserFS maybe?
> Thanks,
> Peter Darley
>
> -----Original Message-----
> From: Jeff Self [mailto:jself@nngov.com]
> Sent: Tuesday, February 26, 2002 8:22 AM
> To: Peter Darley
> Cc: Pgsql-Admin
> Subject: Re: [ADMIN] Journaling file systems
>
>
> Journaled file systems will typically slow down a database somewhat.
>
> On Tue, 2002-02-26 at 10:29, Peter Darley wrote:
> > Friends,
> >     I'm wondering if a journaling file system, like ext3, will make much
> > difference with the speed or reliability of PostgreSQL?  Is it worth the
> > work to switch over?
> > Thanks,
> > Peter Darley
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> --
> Jeff Self
> Information Technology Analyst
> Department of Personnel
> City of Newport News
> 2400 Washington Ave.
> Newport News, VA 23607
> 757-926-6930
>
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930