Re: slow query - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: slow query
Date
Msg-id dcc563d10901121654l17b034b6m8c70118d2cdc45f2@mail.gmail.com
Whole thread Raw
In response to Re: slow query  ("David Wilson" <david.t.wilson@gmail.com>)
List pgsql-performance
On Mon, Jan 12, 2009 at 4:55 PM, David Wilson <david.t.wilson@gmail.com> wrote:
> On Mon, Jan 12, 2009 at 5:59 PM, Scott Marlowe <scott.marlowe@gmail.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.

Exactly.  I keep forgetting to look at loops... sigh.  Thanks!

pgsql-performance by date:

Previous
From: "David Wilson"
Date:
Subject: Re: slow query
Next
From: Bill Preston
Date:
Subject: Slow insert performace, 8.3 Wal related?