Re: hardware to get best performance - Mailing list pgsql-admin

From Vincent Chen
Subject Re: hardware to get best performance
Date
Msg-id 20041124053006.79880.qmail@web54401.mail.yahoo.com
Whole thread Raw
In response to hardware to get best performance  (Vincent Chen <vctw@yahoo.com>)
Responses Re: hardware to get best performance  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-admin
>> Hi, all
>>
>> Does postgresql support thread? Or let me put it this way, will postgresql
get
>> better performance on multiple processor host than single processor? What's
the
>> best platform, freebsd? linux?
>
>If you have multiple connections to the database server making simultaneous
>queries, multiple processors will be used. This is the normal case for
>real database use.
>
>The best platform for you is probably the one you are most familiar with.
>

About platform, linux has much more filesystem choice than freebsd. If I put
postgresql data file on new filesystem like xfs or reiserfs, is it possible
that overall performance will be better than old filesystem like ufs?


Thanks for your response,


Vincent Chen


-----------------------------------------------------------------
Yahoo!奇摩造型精靈
最新的造型精靈簽名檔,讓信件獨具個人色彩!
http://tw.avatar.yahoo.com/

pgsql-admin by date:

Previous
From: mariabreis@ono.com
Date:
Subject: pgdump in jsp
Next
From: "Jim C. Nasby"
Date:
Subject: Re: hardware to get best performance