Re: [GENERAL] Filesystem options for storing pg_data

2005-04-21 Thread Scott Marlowe
Whoa, hold on. My original post was this: QUOTE: Generally XFS and JFS are considered superior to ext2/3. ext3, in my experience, isn't much slower than ext2. Plus the decreased time required to bring up a server after a power outage is worth something too. Having used ext3 quite a bit, I'd s

Re: [GENERAL] Filesystem options for storing pg_data

2005-04-21 Thread Marco Colombo
On Thu, 21 Apr 2005, Scott Marlowe wrote: References: http://archives.postgresql.org/pgsql-performance/2005-01/msg00131.php http://archives.postgresql.org/pgsql-performance/2004-05/msg00130.php http://archives.postgresql.org/pgsql-performance/2003-08/msg00191.php http://groups-beta.google.com/group

Re: [GENERAL] Filesystem options for storing pg_data

2005-04-21 Thread Scott Marlowe
References: http://archives.postgresql.org/pgsql-performance/2005-01/msg00131.php http://archives.postgresql.org/pgsql-performance/2004-05/msg00130.php http://archives.postgresql.org/pgsql-performance/2003-08/msg00191.php http://groups-beta.google.com/group/comp.os.linux.misc/msg/b299a71fd540c2b8?

Re: [GENERAL] Filesystem options for storing pg_data

2005-04-21 Thread Dawid Kuroczko
On 4/21/05, Marco Colombo <[EMAIL PROTECTED]> wrote: > > > > Generally XFS and JFS are considered superior to ext2/3. > > > Do you mind posting a reference? I'm really interested in the comparison > > > but everytime I asked for a pointer, I got no valid resource, so far. > Well, my point being the

Re: [GENERAL] Filesystem options for storing pg_data

2005-04-21 Thread Marco Colombo
[I've got a private reply from Scott, which I won't quote here, which can be fairly (I hope) summarized as "search the pgsql-performance list". Well, I've done it, and I feel it's due to bring the issue back in public. So if I seems I'm replying to myself, it's not, I'm replying to Scott. I've real

Re: [GENERAL] Filesystem options for storing pg_data

2005-04-20 Thread Scott Marlowe
On Wed, 2005-04-20 at 11:18, Scott Marlowe wrote: > On Wed, 2005-04-20 at 11:07, Joe Maldonado wrote: > > Hello all, > > > > I am in a position where I'm torn between using ext2 vs ext3 to keep the > > pg_data, pg_xlog, and pg_clog contents. > > > > The main concern is that switching to ext2 will

Re: [GENERAL] Filesystem options for storing pg_data

2005-04-20 Thread Scott Marlowe
On Wed, 2005-04-20 at 11:07, Joe Maldonado wrote: > Hello all, > > I am in a position where I'm torn between using ext2 vs ext3 to keep the > pg_data, pg_xlog, and pg_clog contents. > > The main concern is that switching to ext2 will not respond well to an > improper shutdown, power loss. > > My

[GENERAL] Filesystem options for storing pg_data

2005-04-20 Thread Joe Maldonado
Hello all, I am in a position where I'm torn between using ext2 vs ext3 to keep the pg_data, pg_xlog, and pg_clog contents. The main concern is that switching to ext2 will not respond well to an improper shutdown, power loss. My question is what is the prefered filesystem to keep this data to be