Re: Statistics

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Ezequias R(dot) da Rocha" <ezequias(at)fastcon(dot)com(dot)br>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Statistics
Date: 2007-03-23 21:16:53
Message-ID: 460443C5.3040607@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Ezequias R. da Rocha wrote:
> Now it is ok with analyse.
>
> I must do it everytime ?

No - but your maintenance procedures should include regular ANALYZE's
(or autovacuum should be running with appropriate settings) otherwise
your performance will be far from optimal.

Regards, Dave.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2007-03-26 09:06:56 pgAdmin III v1.6.3 released
Previous Message Ezequias R. da Rocha 2007-03-23 20:40:47 Re: Statistics