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
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
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