Thread: Journaling file systems
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
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
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
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
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
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.
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
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