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