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

Re: hardware to get best performance

From: Vincent Chen <vctw(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: hardware to get best performance
Date: 2004-11-24 05:30:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
>> Hi, all
>> Does postgresql support thread? Or let me put it this way, will postgresql
>> better performance on multiple processor host than single processor? What's
>> 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



pgsql-admin by date

Next:From: Roderick A. AndersonDate: 2004-11-24 05:32:45
Subject: Re: joins INNER, OUTER, LEFT, RIGHT, FULL, ...
Previous:From: Jaime CasanovaDate: 2004-11-24 05:06:41
Subject: Re: joins INNER, OUTER, LEFT, RIGHT, FULL, ...

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