Re: Tuning PostgreSQL

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning PostgreSQL
Date: 2003-07-21 11:39:30
Message-ID: 3F1C1E4A.31965.14E5CFC2@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 21 Jul 2003 at 19:27, Ang Chin Han wrote:
> [1] That is, AFAIK, from our testing. Please, please correct me if I'm
> wrong: has anyone found that different filesystems produces wildly
> different performance for postgresql, FreeBSD's filesystems not included?

well, when postgresql starts splitting table files after a gig, filesystem sure
makes difference. IIRC, frommy last test XFS was at least 10-15% faster than
reiserfs for such databases. That was around an year back, with mandrake 8.0.

Bye
Shridhar

--
modesty, n.: Being comfortable that others will discover your greatness.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alexander Priem 2003-07-21 11:45:06 Re: Tuning PostgreSQL
Previous Message Ang Chin Han 2003-07-21 11:27:54 Re: Tuning PostgreSQL