On 5/03/2010 10:09 PM, Ogden wrote:
> Would searching a huge table be as fast as calculating or about the same? I'll have to run some tests on my end but I
amvery impressed by the speed of which PostgreSQL executes aggregate functions.
I'm not sure what you're asking.
> Do you suggest looking at this option when we see the reporting to slow down? At that point do you suggest we go back
tothe drawing board?
If it ain't broke, don't fix it. However, it's a good idea to make it
easy to fix later - for example, wrap your score calculations up into a
view (see CREATE VIEW) so that you can replace it with a materialized
view later if you start seeing performance issues.
--
Craig Ringer