Re: ok you all win what is best opteron (I dont want a hosed system again)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
Cc: "'David Brown'" <time(at)bigpond(dot)net(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: ok you all win what is best opteron (I dont want a hosed system again)
Date: 2005-05-14 21:19:15
Message-ID: 200505141419.15810.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joel,

> The two worst queries (our case and audit applications) I created
> denormalized files and maintain them through code. All reporting comes off
> those and it is lightning fast.

This can often be called for. I'm working on a 400GB data warehouse right
now, and almost *all* of our queries run from materialized aggregate tables.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Nolan 2005-05-14 22:16:52 Re: ok you all win what is best opteron (I dont want a hosed system again)
Previous Message Joel Fradkin 2005-05-14 18:19:20 Re: ok you all win what is best opteron (I dont want a hosed system again)