Re: Poor performance on very simple query ? - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Poor performance on very simple query ?
Date
Msg-id 20061003121109.GD30211@oppetid.no
Whole thread Raw
In response to Re: Poor performance on very simple query ?  (Tobias Brox <tobias@nordicbet.com>)
Responses Re: Poor performance on very simple query ?
List pgsql-performance
[Tobias Brox - Tue at 02:10:04PM +0200]
> Did you try "analyze" as well?  It's weird it's using seq scan, since
> you have a primary key it's supposed to have an index ... though 500
> rows is little.
>
> I just checked up our own production database, takes 0.08 ms to fetch a
> row by ID from one of our tables containing 176k with rows.

Oh, the gid is not primary key.  I guess I should also apologize for
adding noise here :-)

Make an index here! :-)

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: Poor performance on very simple query ?
Next
From: Arnaud Lesauvage
Date:
Subject: Re: Poor performance on very simple query ?