JOUANIN Nicolas (44) wrote:
>
> The strange thing is that this morning explain analyze now gives a
> much better duration :
>
> There were no modification made on the database except a restart
> yesterday evening and a vacuumdb --analyse ran at night.
If the earlier bad query was run on a fresh imported database that was
not ANALYZEd, it would explain the different and likely bad plan. If you
want to know for sure this is the cause, instead of e.g. faulty
hardware, you could verify redoing the import + query without analyze.
regards,
Yeb Havinga