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 am very 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 to the 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
