> -----Original Message----- > From: Keith Worthington [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 12, 2005 1:14 PM > To: Dave Held; PostgreSQL Perform > Subject: Re: [PERFORM] 4 way JOIN using aliases > > > > I run vacuumdb with the analyze option every morning via a > > > cron job. In my ignorance I do not know if that is the same > > > thing. > > > > Pass it an --analyze option if you aren't already. > > Here is the command I have in the cron file. > > vacuumdb --full --analyze --verbose --username dbuser > --dbname ${IPA_DB} >> > ${IPA_LOG_DIR}/ipavcmdb.log 2>&1 > > If this performs the analyze as I thought it should I do not > know why the row > count is so badly off.
You may need to increase the statistics target for the relevant columns. Look at: http://www.postgresql.org/docs/7.4/static/sql-altertable.html In particular, the SET STATISTICS clause. __ David B. Held Software Engineer/Array Services Group 200 14th Ave. East, Sartell, MN 56377 320.534.3637 320.253.7800 800.752.8129 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
