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

From Simon Riggs
Subject Re: Concurrent VACUUM and ANALYZE
Date
Msg-id 1216904794.3894.824.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
On Mon, 2008-07-21 at 17:50 -0400, Jonah H. Harris wrote:
> Currently, one cannot perform a concurrent VACUUM and ANALYZE.  This
> is a significant problem for tables which are not only large and have
> designated cost-delays, but which are also heavily inserted into and
> deleted from.

I suspect this is not the root problem, but one solution to it.

If the stats need such frequent updating, then the code that handles the
stats probably needs extension/improvement to avoid such sensitivities.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Uncopied parameters on CREATE TABLE LIKE
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Concurrent VACUUM and ANALYZE