Re: Index speeds up one row table (why)?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Index speeds up one row table (why)?
Дата
Msg-id 20030531132403.GB31995@wolff.to
обсуждение исходный текст
Ответ на Index speeds up one row table (why)?  (Dave E Martin XXIII <postgresql-to.dave@dave.to>)
Ответы Re: Index speeds up one row table (why)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Sat, May 31, 2003 at 00:14:18 -0600,
  Dave E Martin XXIII <postgresql-to.dave@dave.to> wrote:
> version: 7.3.2
>
> Currently this table has one row in it, where name is 15 unicode
> characters long. It would seem that there would be no need for an index
> on name. However, doing:

It probably has one visible row in it. If it can changed a lot, there
may be lots of deleted tuples in a row. That would explain why an
index scan speeds things up.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dave E Martin XXIII
Дата:
Сообщение: Index speeds up one row table (why)?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Index speeds up one row table (why)?