From: | Psicopunk <gil(dot)nunes(dot)resende(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql Hardware |
Date: | 2009-09-11 17:09:27 |
Message-ID: | ca397743-6e21-4a61-880b-1072ccd69616@w10g2000yqf.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11 Set, 17:59, vi(dot)(dot)(dot)(at)khera(dot)org (Vick Khera) wrote:
> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk <gil(dot)nunes(dot)rese(dot)(dot)(dot)(at)gmail(dot)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(dot)(dot)(dot)(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alan McKay | 2009-09-11 18:08:49 | Re: Postgresql Hardware |
Previous Message | Bill Moran | 2009-09-11 17:06:27 | Re: Postgresql Hardware |