Re: How to analyze a slowdown in 9.3.5?

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to analyze a slowdown in 9.3.5?
Date: 2015-01-11 16:07:38
Message-ID: CAOzAquK=0L94mHO-LbzmereTYGn9SC_1pXe_VCPaGc4+ViPBSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2015-01-11 17:01:23 Re: How to analyze a slowdown in 9.3.5?
Previous Message Ravi Kiran 2015-01-11 14:52:42 Hash Function