> 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
(I know that's an old version. We've been testing with 7.4 now and are
nearly ready to upgrade.)
Matthew Nuzum <matt(at)followers(dot)net>
www.followers.net - Makers of "Elite Content Management System"
View samples of Elite CMS in action by visiting
In response to
pgsql-performance by date
|Next:||From: Matthew Nuzum||Date: 2005-03-24 19:55:32|
|Subject: Re: Preventing query from hogging server |
|Previous:||From: Reid Thompson||Date: 2005-03-24 19:46:41|
|Subject: Configuration/Tuning of server/DB|