> How many rows in usage_access?  How many groups do you expect?
> (Approximate answers are fine.)  What PG version is this, and
> what's your sort_mem setting?
>                       regards, tom lane

I believe there are about 40,000,000 rows, I expect there to be about
10,000,000 groups. PostgreSQL version is 7.3.2 and the sort_mem is at the
default setting.

(I know that's an old version. We've been testing with 7.4 now and are
nearly ready to upgrade.)

Matthew Nuzum <[EMAIL PROTECTED]>
www.followers.net - Makers of "Elite Content Management System"
View samples of Elite CMS in action by visiting

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to