Re: filesystem performance

2009-05-06 Thread Mark Wong
On Wed, May 6, 2009 at 7:18 AM, Florian Smeets wrote: > On 05.05.09 07:30, Mark Wong wrote: >> >> Hi everyone, >> >> We (PostgreSQL community) have a HP DL380 G5 that we were using to do >> some very basic filesystem characterizations as part of a database >> performance tuning project, so we want

Re: filesystem performance

2009-05-06 Thread Mark Wong
On Wed, May 6, 2009 at 2:25 AM, Anthony Pankov wrote: > Hello Mark, > > May i ask a question while more expierenced people is waking up? > > I don't fully understand the target. For what filesystem should be > optimized? > > I expect a patterns of recorded IO calls when pgsql perform typical > ope

Re: filesystem performance

2009-05-06 Thread Florian Smeets
On 05.05.09 07:30, Mark Wong wrote: Hi everyone, We (PostgreSQL community) have a HP DL380 G5 that we were using to do some very basic filesystem characterizations as part of a database performance tuning project, so we wanted to give FreeBSD a try out of the box. For this set of data we used 7

Re: filesystem performance

2009-05-06 Thread Anthony Pankov
Hello Mark, May i ask a question while more expierenced people is waking up? I don't fully understand the target. For what filesystem should be optimized? I expect a patterns of recorded IO calls when pgsql perform typical operations with statistics and in-depth analysis. Are you sure there is

filesystem performance

2009-05-04 Thread Mark Wong
Hi everyone, We (PostgreSQL community) have a HP DL380 G5 that we were using to do some very basic filesystem characterizations as part of a database performance tuning project, so we wanted to give FreeBSD a try out of the box. For this set of data we used 7.1. We're (us few that are running th