index speed and failed expectations?

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: index speed and failed expectations?
Date: 2008-08-04 13:27:37
Message-ID: 489703C9.30307@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Rich 2008-08-04 13:35:28 Re: index speed and failed expectations?
Previous Message Ivan Sergio Borgonovo 2008-08-04 13:03:19 Re: eliminating records not in (select id ... so SLOW?