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