> -----Original Message-----
> From: Keith Worthington [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 11, 2005 7:44 PM
> To: Neil Conway
> Cc: PostgreSQL Perform
> Subject: Re: [PERFORM] 4 way JOIN using aliases
> 
> Neil Conway wrote:
> > Keith Worthington wrote:
> > 
> >>               ->  Seq Scan on tbl_current  
> (cost=0.00..1775.57 rows=76457
> >> width=31) (actual time=22.870..25.024 rows=605 loops=1)
> > 
> > 
> > This rowcount is way off -- have you run ANALYZE recently?
> > [...]
> 
> 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.

__
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 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to