I was usleeping in tiny increments in each iteration of the loop. I
didn't try break it into iterative groups like this.
Honestly, I'd prefer to see pg_autovacuum improved to do O(n) rather
than O(n^2) table activity. At this point, though, I'm probably not
too likely to have much time to hack pg_autovacuum before 8.1 is
released, although if it doesn't become integrated by beta feature
freeze, I might give it a shot.
But I hope if anyone completes the linear improvement, they'll post
to the lists.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jun 10, 2005, at 9:12 AM, Shelby Cain wrote:
--- "Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> wrote:
Were you sleeping every time through the loop? How about something
like:
if (j%500 == 1) usleep(100000)
Regards,
Shelby Cain
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
