Re: Question on Opteron performance

From: "Steve Wolfe" <nw(at)codon(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question on Opteron performance
Date: 2004-03-09 17:14:12
Message-ID: 003701c405fa$11b36970$88693fd1@WEASEL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> And lets not forget one of the best things to do: Optimize the queries
> themselves!
>
> Nothing can beat good ol' fashion query optimization.
> Wether it be adding an index or trying something out like a
> materialized view.
>
> I have a PG machine here doing over 50 queries (both read/write) and it
> has plenty of idle cpu.

Like I said, whether 50 queries per second is any substantial load
depends on the queries. With some of our queries, we could probably issue
a thousand per second. However, much of our data model is very complex,
integrating data from a lot of different places, and some of the queries
can get rather intensive. Believe me, we've spent quite a bit of time
looking for ways to optimize our queries, but if you want to integrate
this much data, there's only so much optimization you can do.

(I suppose we could create lookup tables of every possible query result,
if we only had a couple of petabytes of storage to use....)

steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Hachmann 2004-03-09 17:14:26 Using a Storedprocedure as a View
Previous Message Stephan Szabo 2004-03-09 16:57:58 Re: Expression indexes and casts