| From: | Keith Worthington <KeithW(at)NarrowPathInc(dot)com> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | PostgreSQL Perform <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 4 way JOIN using aliases |
| Date: | 2005-04-12 00:43:46 |
| Message-ID: | 425B19C2.1050703@NarrowPathInc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert lubaczewski | 2005-04-12 10:46:43 | profiling postgresql queries? |
| Previous Message | Joe Conway | 2005-04-11 20:17:34 | Re: [sfpug] DATA directory on network attached storage |