filesystem performance

[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 à strong relation between fio benchmark result and
PostgreSQL performance?

Tuesday, May 05, 2009, 9:30:47 AM, you wrote:

MW> Hi everyone,

MW> We (PostgreSQL community) have a HP DL380 G5 that we were using to do
MW> some very basic filesystem characterizations as part of a database
MW> performance tuning project, so we wanted to give FreeBSD a try out of
MW> the box.  For this set of data we used 7.1.  We're (us few that are
MW> running the tests) are fairly unfamiliar with the community here, so
MW> I'll be as brief as I can.  We're basically wondering if the data
MW> we're getting out of the box is expected, and any tuning guidelines
MW> including what changes we should expect to see in the performance.



-- 
Best regards,
 Anthony                            mailto:ap00 at mail.ru