Re: Concurrent VACUUM and ANALYZE - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Concurrent VACUUM and ANALYZE
Date
Msg-id 36e682920807220428v3f671e4dkb1d3eab73de6c2a@mail.gmail.com
Whole thread Raw
In response to Re: Concurrent VACUUM and ANALYZE  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
On Tue, Jul 22, 2008 at 12:31 AM, Matthew T. O'Connor <matthew@zeut.net> wrote:
>> Is DSM going to be in 8.4?  The last I had heard, DSM+related
>> improvements weren't close to being guaranteed for this release.  If
>> it doesn't make it, waiting another year and a half for something
>> easily fixed would be fairly unacceptable.  Should I provide a patch
>> in the event that DSM doesn't make it?
>
> Can't hurt to submit a patch.  Also, could you do something to help mitigate
> the worse case, something like don't update the stats in pg_class if the
> analyze finishes after a vacuum has finished since the current analyze
> started?

Yeah, I was thinking about that.  It should actually be very easy to do that.

-Jonah


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: pltcl_*mod commands are broken on Solaris 10
Next
From: Zdenek Kotala
Date:
Subject: Re: pltcl_*mod commands are broken on Solaris 10