--- "Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> wrote: > Phil, > > If you complete this patch, I'm very interested to see it. > > I think I'm the person Matthew is talking about who inserted a sleep > > value. Because of the sheer number of tables involved, even small > values of sleep caused pg_autovacuum to iterate too slowly over its > table lists to be of use in a production environment (where I still > find its behavior to be preferable to a complicated list of manual > vacuums performed in cron). > > -- > Thomas F. O'Connell > Co-Founder, Information Architect > Sitening, LLC > Were you sleeping every time through the loop? How about something like: if (j%500 == 1) usleep(100000) Regards, Shelby Cain __________________________________ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
