postgresql@xxxxxxxxxxxx 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.
_______________________________
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
