Re: Poor performance on very simple query ?

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Tobias Brox <tobias(at)nordicbet(dot)com>
Cc: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance on very simple query ?
Date: 2006-10-03 12:11:09
Message-ID: 20061003121109.GD30211@oppetid.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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! :-)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Arnaud Lesauvage 2006-10-03 12:13:59 Re: Poor performance on very simple query ?
Previous Message Tobias Brox 2006-10-03 12:10:04 Re: Poor performance on very simple query ?