On Mon, Jan 12, 2009 at 4:55 PM, David Wilson <[email protected]> wrote: > On Mon, Jan 12, 2009 at 5:59 PM, Scott Marlowe <[email protected]> > 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.
Exactly. I keep forgetting to look at loops... sigh. Thanks! -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
