Re: 4 way JOIN using aliases - Mailing list pgsql-performance

From Keith Worthington
Subject Re: 4 way JOIN using aliases
Date
Msg-id 425B19C2.1050703@NarrowPathInc.com
Whole thread Raw
In response to Re: 4 way JOIN using aliases  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
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?
>
> -Neil
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>

Neil,

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.

--
Kind Regards,
Keith

pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: [sfpug] DATA directory on network attached storage
Next
From: Aditya
Date:
Subject: Re: [sfpug] DATA directory on network attached storage