> -----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

Reply via email to