Search Postgresql Archives

Re: Postgresql Hardware

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk <gil.nunes.resende@xxxxxxxxx> wrote:

> What HW is more important to postgresql performance?
> Assuming that the database will have some load, what hardware must i
> buy?


Generally, you put as much RAM as you can afford, and then buy the
fastest disks you can afford.

Any advice beyond that will depend on taking exact measurements of
your application load and finding the bottlenecks and then increasing
performance at those points.  Usually it is I/O that limits you, so
you can also optimize your application by adjusting your schema design
and your queries.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux