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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
