From: Cott Lang <cott@internetstaff.com>
To: Steve Poe <spoe@sfnet.cc>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: Mon, 28 Mar 2005 15:43:14 -0700
Message-ID: <1112049794.23284.29.camel@localhost.localdomain> (raw)
In-Reply-To: <42455DEC.2080301@sfnet.cc>
References: <42443863.4040302@sfnet.cc>
<4244A90B.2030200@sfnet.cc>
<42453273.2060509@turtle-entertainment.de>
<200503261255.59007.josh@agliodbs.com>
<42455DEC.2080301@sfnet.cc>
Have you already considered application/database tuning? Adding
indexes? shared_buffers large enough? etc.
Your database doesn't seem that large for the hardware you've already
got. I'd hate to spend $7k and end up back in the same boat. :)
On Sat, 2005-03-26 at 13:04 +0000, Steve Poe wrote:
> >Steve, can we clarify that you are not currently having any performance
> >issues, you're just worried about failure? Recommendations should be based
> >on whether improving applicaiton speed is a requirement ...
>
> Josh,
>
> The priorities are: 1)improve safety/failure-prevention, 2) improve
> performance.
>
> The owner of the company wants greater performance (and, I concure to
> certain degree), but the owner's vote is only 1/7 of the managment team.
> And, the rest of the management team is not as focused on performance.
> They all agree in safety/failure-prevention.
>
> Steve
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cott@internetstaff.com, spoe@sfnet.cc
Subject: Re: How to improve db performance with $7K?
In-Reply-To: <1112049794.23284.29.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox