From: Tobias Brox <tobias@nordicbet.com>
To: Tobias Brox <tobias@nordicbet.com>
Cc: Arnaud Lesauvage <thewild@freesurf.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: Poor performance on very simple query ?
Date: Tue, 3 Oct 2006 14:11:09 +0200
Message-ID: <20061003121109.GD30211@oppetid.no> (raw)
In-Reply-To: <20061003121004.GC30211@oppetid.no>
References: <45224896.7040708@freesurf.fr>
<20061003121004.GC30211@oppetid.no>
[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! :-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tobias@nordicbet.com, thewild@freesurf.fr
Subject: Re: Poor performance on very simple query ?
In-Reply-To: <20061003121109.GD30211@oppetid.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox