Re: strange buildfarm failure on lionfish - Mailing list pgsql-hackers

From Tom Lane
Subject Re: strange buildfarm failure on lionfish
Date
Msg-id 12749.1185297372@sss.pgh.pa.us
Whole thread Raw
In response to Re: strange buildfarm failure on lionfish  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: strange buildfarm failure on lionfish  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Gregory Stark wrote:
>> What really has to happen is it should run analyze on all tables
>> together in a single transaction and commit all the new stats together.
>> Out-of-sync stats can be worse than out-of-date stats.

> One problem with that is that it will keep the locks on each table until
> the end of all analyzes.

Yeah, that seems entirely infeasible, even if I agreed with the premise
which I don't think I do.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: strange buildfarm failure on lionfish
Next
From: Tom Lane
Date:
Subject: Re: strange buildfarm failure on lionfish