On Mon, Sep 14, 2009 at 9:30 AM, Greg Smith wrote:
> On Mon, 14 Sep 2009, Psicopunk wrote:
>
>> I will take some measurements and analyze this graphs.
>
> A snapshot of "vmstat 1" data from when something like your real app is
> running is far more useful at figuring out where you should allocate
On Mon, 14 Sep 2009, Psicopunk wrote:
I will take some measurements and analyze this graphs.
A snapshot of "vmstat 1" data from when something like your real app is
running is far more useful at figuring out where you should allocate your
hardware resources for than any theoretical planning
Thanks,Greg!
I will read your articles.
This is a great help to understand what HW and how to tune my
postgresql.
Best regards.
On 14 Set, 16:46, scott.marl...@gmail.com (Scott Marlowe) wrote:
> On Mon, Sep 14, 2009 at 9:30 AM, Greg Smith wrote:
> > On Mon, 14 Sep 2009, Psicopunk wrote:
>
>
Hi,
Thanks for your help.
I will take some measurements and analyze this graphs.
Does anyone know where i can get a book about Postgresql Tuning and
hardware impact on performance?
Thanks
Best regards.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On Fri, Sep 11, 2009 at 3:53 PM, Scott Marlowe wrote:
> For about $8000 more you can get a 16 drive machine with 146G drives
> and same basic setup, which I would recommend over the 8 drive
> machine. With 2 hot spares, and 2 in a mirror for the OS/xlog you
> still have 12 drives for a RAID-10 of
On Fri, Sep 11, 2009 at 12:35 PM, Chris Barnes
wrote:
>
>
> Purchase solid equipment and fairly current machines.
> We buy referbished system at a fraction of the cost of new.
>
> For example;
> IBM 3650 with 8 x 300g SAS drives and controller, 4 slot dual with the
> following specs. 16 gb memory.
t; From: gil.nunes.rese...@gmail.com
> Subject: [GENERAL] Postgresql Hardware
> Date: Fri, 11 Sep 2009 03:01:29 -0700
> To: pgsql-general@postgresql.org
>
> Hi,
>
> We are developing a web application that will work on Postgresql. My
> doubt is about the hardware that I can u
> How can i take some measurements to understand what bottlenecks will
> appear?
For long-term / ongoing I'm very happy so far with a package called
munin. Google it and join their mailing list for help setting it up.
But it takes snapshots at 5 minute intervals and this is not configurable.
Fo
On 11 Set, 17:59, vi...@khera.org (Vick Khera) wrote:
> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk
> 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 affo
How much reading? Writing? Concurrent transactions? How much data will
you have? These are some of the things you need to provide to get a
reasonable answer.
Psicopunk wrote:
Hi,
We are developing a web application that will work on Postgresql. My
doubt is about the hardware that I can use fo
In response to Vick Khera :
> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk
> 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 t
On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk 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 bey
Hi,
We are developing a web application that will work on Postgresql. My
doubt is about the hardware that I can use for postgresql.
What HW is more important to postgresql performance?
Assuming that the database will have some load, what hardware must i
buy?
Thanks
Best regards
--
Sent via pg
13 matches
Mail list logo
