Re: Statistics and Indexes

postgresql(at)bryden(dot)co(dot)za wrote:
> Hi
>
> I am from a MSSQL background and am trying to understand something about
> statistics in PostgreSQL.
>
> Question 1:
> In MSSQL, if you create an index (and you are using MSSQL's default
> settings) the Server will automatically create appropriate statistics for
> you. Does this happen in PostgreSQL? Or should I explicitly create
> statistics for every one of my indexes?
>

Q2 sort of answers Q1.

> Question 2:
> I believe ANALYZE keeps indexes and statistics up to date. How often
> should this be run (assume that my DB has 200,000 new records daily)?

Try out a VACUUM ANALYZE every hour or three.

--
_______________________________

This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________