Re: How to analyze a slowdown in 9.3.5? - Mailing list pgsql-general

From Michael Nolan
Subject Re: How to analyze a slowdown in 9.3.5?
Date
Msg-id CAOzAquK=0L94mHO-LbzmereTYGn9SC_1pXe_VCPaGc4+ViPBSg@mail.gmail.com
Whole thread Raw
In response to Re: How to analyze a slowdown in 9.3.5?  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: How to analyze a slowdown in 9.3.5?  (Melvin Davidson <melvin6925@gmail.com>)
Re: How to analyze a slowdown in 9.3.5?  (Joe Van Dyk <joe@tanga.com>)
List pgsql-general


On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson <melvin6925@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

pgsql-general by date:

Previous
From: Ravi Kiran
Date:
Subject: Hash Function
Next
From: Melvin Davidson
Date:
Subject: Re: How to analyze a slowdown in 9.3.5?