Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Alexander PriemDate: 2003-07-21 11:45:06
Subject: Re: Tuning PostgreSQL
Previous:From: Ang Chin HanDate: 2003-07-21 11:27:54
Subject: Re: Tuning PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group