index speed and failed expectations?

Поиск
Список
Период
Сортировка
От rihad
Тема index speed and failed expectations?
Дата
Msg-id 489703C9.30307@mail.ru
обсуждение исходный текст
Ответы Re: index speed and failed expectations?
Список pgsql-general
sol=> \d stats;
                  Table "public.stats"
     Column    |              Type              | Modifiers
--------------+--------------------------------+-----------
  id           | integer                        | not null
  start_time   | timestamp(0) without time zone | not null
...
Indexes:
     "stats_start_time_idx" btree (start_time)
     "stats_id_key" btree (id)

There are roughly half a million rows.

This query from the console:

select * from stats order by start_time;

takes 8 seconds before starting its output. Am I wrong in assuming that
the index on start_time should make ORDER BY orders of magnitude faster?
Or is this already fast enough? Or should I max up some memory (buffer)
setting to achieve greater speeds? Not that the speed is crucial, just
curious.

TIA.

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

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: eliminating records not in (select id ... so SLOW?
Следующее
От: "Adam Rich"
Дата:
Сообщение: Re: index speed and failed expectations?