From: | Bricklen Anderson <BAnderson(at)PresiNET(dot)com> |
---|---|
To: | postgresql(at)bryden(dot)co(dot)za |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Statistics and Indexes |
Date: | 2005-07-05 14:30:29 |
Message-ID: | 42CA9985.6070103@PresiNET.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
_______________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2005-07-05 15:56:14 | Re: How can this be optimized, if possible? |
Previous Message | Per Lauvås | 2005-07-05 13:24:35 | PITR problems |