From: | Nick Burrett <nick(at)dsvr(dot)net> |
---|---|
To: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il> |
Cc: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Recomended FS |
Date: | 2003-10-20 12:54:00 |
Message-ID: | 3F93DAE8.5060008@dsvr.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ben-Nes Michael wrote:
> ----- Original Message -----
> From: "Nick Burrett" <nick(at)dsvr(dot)net>
>>Ben-Nes Michael wrote:
>>
>>
>>>But still the greatest question is what FS to put on ?
>>>
>>>I heard Reiesref can handle small files very quickly.
>>
>>Switching from ext3 to reiserfs for our name servers reduced the time
>>taken to load 110,000 zones from 45 minutes to 5 minutes.
>>
>>However for a database, I don't think you can really factor this type of
>>stuff into the equation. The performance benefits you get from
>>different filesystem types are going to be small compared to the
>>modifications that you can make to your database structure, queries and
>>applications. The actual algorithms used in processing the data will be
>>much slower than the time taken to fetch the data off disk.
>
>
> So you say the FS has no real speed impact on the SB ?
>
> In my pg data folder i have 2367 files, some big some small.
I'm saying: don't expect your DB performance to come on leaps and bounds
just because you changed to a different filesystem format. If you've
got speed problems then it might help to look elsewhere first.
--
Nick Burrett
Network Engineer, Designer Servers Ltd. http://www.dsvr.co.uk
From | Date | Subject | |
---|---|---|---|
Next Message | Ben-Nes Michael | 2003-10-20 12:58:29 | Re: Recomended FS |
Previous Message | Ben-Nes Michael | 2003-10-20 12:48:01 | Re: Recomended FS |