On Mon, Jan 12, 2009 at 5:59 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> I can't figure out where my time's going to.
Looks like it's going to:
-> Index Scan using users_orgid_idx on users u (cost=0.00..129.52
rows=5 width=271) (actual time=843.825..860.638 rows=0 loops=35)
I'd guess the index/pages for users isn't in memory the first time around.
Next time is:
-> Index Scan using users_orgid_idx on users u (cost=0.00..129.52
rows=5 width=271) (actual time=3.126..3.305 rows=0 loops=35)
--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com