Karl Wright wrote:
> Alvaro Herrera wrote:
> >Karl Wright wrote:

> >>I am afraid that I did answer this.  My largest tables are the ones 
> >>continually being updated.  The smaller ones are updated only 
> >>infrequently.
> >
> >Can you afford to vacuum them in parallel?
> 
> Hmm, interesting question.  If VACUUM is disk limited then it wouldn't 
> help, probably, unless I moved various tables to different disks 
> somehow.  Let me think about whether that might be possible.

Well, is it disk limited?  Do you have the vacuum_delay stuff enabled?

-- 
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
"I would rather have GNU than GNOT."  (ccchips, lwn.net/Articles/37595/)

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Reply via email to