Re: slow update & index question

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: slow update & index question
Date: 2002-10-21 18:58:41
Message-ID: 20021021115534.G73781-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mon, 21 Oct 2002, Williams, Travis L, NPONS wrote:

> I did do a vacuum.. but I don't know what analyze does..

Analyze will update the statistics on the table that are used
for planning purposes. If for example explain shows that it's doing
a sequential scan, it may not for example realize that the index is
useful in limiting the number of rows sufficiently to beat the
sequential scan.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff MacDonald 2002-10-21 19:04:26 pgxml_xpath - solution.
Previous Message Roj Niyogi 2002-10-21 18:56:49 Re: client side software for windows, where?