Re: Tuning PostgreSQL - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: Tuning PostgreSQL
Date
Msg-id 3F1C1E4A.31965.14E5CFC2@localhost
Whole thread Raw
In response to Re: Tuning PostgreSQL  (Ang Chin Han <angch@bytecraft.com.my>)
List 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.


pgsql-performance by date:

Previous
From: Ang Chin Han
Date:
Subject: Re: Tuning PostgreSQL
Next
From: "Alexander Priem"
Date:
Subject: Re: Tuning PostgreSQL