Re: [SQL] "Group by" and "index".

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vlad Marchenko" <vlad(at)infonet(dot)com(dot)ua>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] "Group by" and "index".
Date: 2000-01-30 22:29:41
Message-ID: 497.949271381@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Vlad Marchenko" <vlad(at)infonet(dot)com(dot)ua> writes:
>> explain select field1 from test group by field1;
> It don't use this index :-(.

That's a deficiency of the 6.5 planner; it won't consider an indexscan
unless there's a WHERE clause that matches the index. This is fixed for
7.0.

However, the 6.5 planner is not necessarily doing the wrong thing here!
Replacing the explicit sort with an index scan could easily produce a
slower query. Index scans are good for pulling out a few items,
but when you are going to end up fetching the whole table, they are
pretty slow because of the nonsequential disk accesses they cause.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-01-31 09:49:52 Re: [HACKERS] Help with pl/pgsql, triggers, and foreign keys
Previous Message Vlad Marchenko 2000-01-30 21:23:45 "Group by" and "index".