Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-05 Thread Jon Schewe
On 06/05/2010 07:02 PM, Scott Marlowe wrote: > On Sat, Jun 5, 2010 at 5:58 PM, Jon Schewe wrote: > >> On 06/05/2010 06:54 PM, Scott Marlowe wrote: >> >>> On Sat, Jun 5, 2010 at 5:03 PM, Jon Schewe wrote: >>> >>>

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-05 Thread Jon Schewe
On 06/05/2010 06:54 PM, Scott Marlowe wrote: > On Sat, Jun 5, 2010 at 5:03 PM, Jon Schewe wrote: > >> >> On 06/05/2010 05:52 PM, Greg Smith wrote: >> >>> Jon Schewe wrote: >>> >>>>> If that's the case, what you'v

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-05 Thread Jon Schewe
On 06/05/2010 05:52 PM, Greg Smith wrote: > Jon Schewe wrote: >>> If that's the case, what you've measured is which filesystems are >>> safe because they default to flushing drive cache (the ones that take >>> around 15 minutes) and which do not (the on

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-05 Thread Jon Schewe
On 06/05/2010 05:36 PM, Greg Smith wrote: > Jon Schewe wrote: >> The tests were all done on an opensuse 11.2 64-bit machine, >> on the same hard drive (just ran mkfs between each test) on the same >> input with the same code base. > > So no controller card, just the mo

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-04 Thread Jon Schewe
On 6/4/10 1:46 PM, Andres Freund wrote: > On Friday 04 June 2010 20:26:27 Jon Schewe wrote: > >> ext3 barrier=1: ~15 minutes >> ext4 nobarrier: ~15 minutes >> > Any message in the kernel log about barriers or similar? > > No. -- Jon Schewe | http:

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-04 Thread Jon Schewe
I just used standard mkfs for each filesystem and mounted them without options, unless otherwise specified. On 6/4/10 1:37 PM, Bryan Hinton wrote: > What types of journaling on each fs? > > > On Fri, Jun 4, 2010 at 1:26 PM, Jon Schewe <mailto:jpsch...@mtu.net>> wrote: >

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-04 Thread Jon Schewe
On 6/4/10 9:33 AM, Andres Freund wrote: > On Friday 04 June 2010 16:25:30 Tom Lane wrote: > >> Andres Freund writes: >> >>> On Friday 04 June 2010 14:17:35 Jon Schewe wrote: >>> >>>> XFS (logbufs=8): ~4 hours to finish >>>&

Re: [PERFORM] How filesystems matter with PostgreSQL

2010-06-04 Thread Jon Schewe
t;> wrote: > > On Friday 04 June 2010 16:25:30 Tom Lane wrote: > > Andres Freund mailto:and...@anarazel.de>> > writes: > > > On Friday 04 June 2010 14:17:35 Jon Schewe wrote: > > >> XFS (logbufs=8): ~4 hours to finish > &

[PERFORM] How filesystems matter with PostgreSQL

2010-06-04 Thread Jon Schewe
same input with the same code base. All filesystems were created with the default options. XFS (logbufs=8): ~4 hours to finish ext4: ~1 hour 50 minutes to finish ext3: 15 minutes to finish ext3 on LVM: 15 minutes to finish -- Jon Schewe | http://mtu.net/~jpschewe If you see an attachment named