On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson <melvin6...@gmail.com>
wrote:

> Just curious. Have you checked that the tables are being vacuum/analyzed
> periodically and that the statistics are up to date? Try running the
> following query to verify:
>
>
A vacuum analyze runs every night and there would not have been many
inserts or updates to the tables used by the lookup function since the
latest vacuum analyze.  I think I may have even done a vacuum analyze on
the two largest tables after the first DB shutdown.
--
Mike Nolan

Reply via email to