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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
