Re: 4 way JOIN using aliases

> -----Original Message-----
> From: Keith Worthington [mailto:KeithW@narrowpathinc.com]
> 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