Re: lazy vacuum blocks analyze

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: lazy vacuum blocks analyze
Date: 2009-05-06 19:11:56
Message-ID: 20090506191155.GI4476@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zdenek Kotala wrote:

> If there is not another problem I suggest to use two different locks for
> vacuum and analyze.

By itself that won't work -- see vac_update_relstats.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-05-06 19:13:05 Re: Patch to fix search_path defencies with pg_bench
Previous Message Zdenek Kotala 2009-05-06 18:58:57 lazy vacuum blocks analyze