Re: Concurrent VACUUM and ANALYZE

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Postgres Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Concurrent VACUUM and ANALYZE
Date: 2008-07-22 11:28:59
Message-ID: 36e682920807220428v3f671e4dkb1d3eab73de6c2a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 22, 2008 at 12:31 AM, Matthew T. O'Connor <matthew(at)zeut(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2008-07-22 12:21:53 Re: pltcl_*mod commands are broken on Solaris 10
Previous Message Zdenek Kotala 2008-07-22 10:57:39 pltcl_*mod commands are broken on Solaris 10