| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com> |
| Cc: | PgSQL - Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance Anomalies in 7.4.5 |
| Date: | 2004-10-21 21:05:20 |
| Message-ID: | Pine.LNX.4.44.0410212303161.2015-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, 21 Oct 2004, Thomas F.O'Connell wrote:
> Aggregate (cost=0.02..0.02 rows=1 width=8) (actual
> time=298321.421..298321.422 rows=1 loops=1)
> -> Nested Loop (cost=0.00..0.01 rows=1 width=8) (actual
> time=1.771..298305.531 rows=2452 loops=1)
> Join Filter: ("inner".id = "outer".id)
> -> Seq Scan on userdata u (cost=0.00..0.00 rows=1 width=8)
> (actual time=0.026..11.869 rows=2452 loops=1)
> -> Seq Scan on userdata_history h (cost=0.00..0.00 rows=1
> width=8) (actual time=0.005..70.519 rows=41631 loops=2452)
> Filter: (id = 18181::bigint)
It looks like you have not run ANALYZE recently. Most people run VACUUM
ANALYZE every night (or similar) in a cron job.
--
/Dennis Björklund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F.O'Connell | 2004-10-21 21:11:39 | Re: Performance Anomalies in 7.4.5 |
| Previous Message | Bricklen | 2004-10-21 21:04:58 | Re: Performance Anomalies in 7.4.5 |