Re: [BUGS] Re: BUG #5480: Autovacuum interferes with operations (e.g. truncate) on very large databases

2010-05-29 Thread Robert Haas
On Sat, May 29, 2010 at 5:44 PM, Sakari A. Maaranen wrote: > For now, I can work around this on the client side by splitting the > updates into a million separate transactions instead of a single big > one. Will be slow, but it should work. In general, it's better to group things into larger tran

[BUGS] Re: BUG #5480: Autovacuum interferes with operations (e.g. truncate) on very large databases

2010-05-29 Thread Sakari A. Maaranen
2010/5/29 Greg Stark : > On Fri, May 28, 2010 at 2:02 PM, Sakari Maaranen wrote: >> The documentation says that the best way to use autovacuum is to let the >> database vacuum often. However when the tables are very large, this can take >> a very long time. > > In addition to Tom's comments, as of

[BUGS] Re: BUG #5480: Autovacuum interferes with operations (e.g. truncate) on very large databases

2010-05-29 Thread Greg Stark
On Fri, May 28, 2010 at 2:02 PM, Sakari Maaranen wrote: > The documentation says that the best way to use autovacuum is to let the > database vacuum often. However when the tables are very large, this can take > a very long time. > In addition to Tom's comments, as of 8.4 this is no longer true a