Thanks - On Sun, Jan 27, 2013 at 8:41 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: > Once the week is over, materialize the medals for that week. Then the > live part of the query only needs to specify the currently live week, > not the entire history. And in that case, the query should be quite > efficient if you have in index on both week and money. I will try that! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general