Re: Poor performance on very simple query ?

Поиск
Список
Период
Сортировка
От Tobias Brox
Тема Re: Poor performance on very simple query ?
Дата
Msg-id 20061003121109.GD30211@oppetid.no
обсуждение исходный текст
Ответ на Re: Poor performance on very simple query ?  (Tobias Brox <tobias@nordicbet.com>)
Ответы Re: Poor performance on very simple query ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
Список 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 по дате отправления:

Предыдущее
От: Tobias Brox
Дата:
Сообщение: Re: Poor performance on very simple query ?
Следующее
От: Arnaud Lesauvage
Дата:
Сообщение: Re: Poor performance on very simple query ?