Re: Why index used/not used - Mailing list pgsql-general

From Anton Maksimenkov
Subject Re: Why index used/not used
Date
Msg-id 40FE19D3.9020104@hlebprom.ru
Whole thread Raw
In response to Re: Why index used/not used  (Mike G <mike@thegodshalls.com>)
List pgsql-general
Mike G wrote:

> Try reading through the pgsql-performance mailing list.  Generally the database needs to be vacuumed and analyzed to
updatethe stats usually for the planner to make the correct choices. 

  Of course, I do VACUUM FULL ANALYZE some times, VACUUM ANALYZE
periodicaly.
  But I don't change "traf_raw" some hours, and imagine that ANALYZE may
be enough for this examle.

>>cnupm=> ANALYZE traf_raw;
>>ANALYZE
--
engineer


pgsql-general by date:

Previous
From: Mike G
Date:
Subject: Re: Insert images through ASP
Next
From: "Markus Wollny"
Date:
Subject: Re: tsearch2, ispell, utf-8 and german special characters