On Tuesday, February 25, 2014 12:31:01 PM CEST, Stephen R. van den Berg
wrote:
Why would it be a problem on 8.3?
I ask because I didn't have a particular postgresql version in mind
when I wrote it.
That that that's what I was running when Abhijit and I tried to do the same
thing, and failed. IIRC, the code ended up paying a substantial part of the
whole-vacuum cost for each chunk. At the end we gave up, ran the whole
thing, and made -a optional.
But maybe you just are better at SQL than I. (I'm better than I once was,
but translating Cobb's model into SQL syntax still challenges me
sometimes.)
Arnt