Alvaro Herrera <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to