Skip site navigation (1) Skip section navigation (2)

Re: Performance Anomalies in 7.4.5

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 (view raw or flat)
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


In response to

Responses

pgsql-performance by date

Next:From: Thomas F.O'ConnellDate: 2004-10-21 21:11:39
Subject: Re: Performance Anomalies in 7.4.5
Previous:From: BricklenDate: 2004-10-21 21:04:58
Subject: Re: Performance Anomalies in 7.4.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group