Re: force the use of a particular index - Mailing list pgsql-performance

From Rod Taylor
Subject Re: force the use of a particular index
Date
Msg-id 1057947284.65544.129.camel@jester
Whole thread Raw
In response to Re: force the use of a particular index  (Scott Cain <cain@cshl.org>)
Responses Re: force the use of a particular index
List pgsql-performance
> > set enable_hashjoin = false;
>
> BINGO!

I'm not so sure about that.  Your dataset seems to have changed fairly
significantly since the last test.

> ->  Index Scan using feature_pkey on feature f  (cost=0.00..134592.43 rows=47912 width=39) (actual time=0.46..502.50
rows=431loops=1) 

Notice it only pulled out 431 rows where prior runs pulled out several
thousand (~13000).  I think what really happened was something came
along and deleted a bunch of stuff, then vacuum ran.

Attachment

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: pre-Vacuum statistics
Next
From: Martin Foster
Date:
Subject: Re: [NOVICE] Extreme high load averages