Re: Postgresql Hardware

On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk <gil.nunes.resende@gmail.com> 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.