On Tue, Nov 22, 2005 at 09:33:34PM +0200, Andrus wrote:
> Jim,
>
> > Upsizes? Are you adding more data? If so then yes, analyze would be
> > good, though autovacuum should handle it for you.
>
> I create new Postgres database, upsize a lot of data into it. After that
FWIW, people generally refer to that as 'loading data'; I've never heard
of 'upsizing' before, which is why I was somewhat confused.
> this database goes online and will receive a lot of transactions daily.
> I'm using PG 8.1 default postgres.conf file.
Well, by default autovacuum is turned off. Aside from that there's other
things you'll want to tune. Take a look at the annotated postgresql.conf
that's in techdocs.
> I read than autovacuum may skip some tables which can cause wrong guru
> hints.
>
> So it seems that I should run manually VACUUM ANALYZE for the whole database
> once for initial statistics colection of those tables, isn't it?
No real need to vacuum, just running analyze on the entire database
would suffice.
--
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