Re: Frequency of Analyze?

On Fri, Oct 28, 2005 at 01:47:49PM -0700, Benjamin Smith wrote:
> 1) Any problem with running "Analyze" hourly via cron?

Probably not. Analyze usually only reads a small portion of the table.

> 2) Does "Vacuum analyze" also do the actions performed by "Analyze"?

Yes, it does.

> 3) What's the best way to handle indexes when only 1 index is used per table
> in a query, but there are several due to the various constraints on it? Is
> there a way to benefit from all of these other indexes somehow? Is there a
> definitive, detailed book for optimizing PG queries?

8.1 can utilize multiple indexes per table.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461