Re: How to improve db performance with $7K?

From: Cott Lang <cott(at)internetstaff(dot)com>
To: Steve Poe <spoe(at)sfnet(dot)cc>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to improve db performance with $7K?
Date: 2005-03-28 22:43:14
Message-ID: 1112049794.23284.29.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)postgresql(dot)org

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Held 2005-03-28 22:58:55 JDBC best practice
Previous Message Greg Stark 2005-03-28 21:36:06 Re: which dual-CPU hardware/OS is fastest for PostgreSQL?