Re: Postgresql Hardware

On 11 Set, 17:59, vi...@khera.org (Vick Khera) wrote:
> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk <gil.nunes.rese...@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.
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general



How can i take some measurements to understand what bottlenecks will
appear?

This application will be always writing to database. How can i measure
the load at the database?
Can i tune the database depending on the hardware that i will buy?

Thanks for your help.
Best regards.