On Mon, 2003-10-27 at 10:15, Tarhon-Onu Victor wrote:
> select count(*) from items where channel <
> 5000; will never use any of the current indexes because none matches
> your WHERE clause (channel appears now only in multicolumn indexes).
No -- a multi-column index can be used to answer queries on a prefix of
the index's column list. So an index on (channel, xyz) can be used to
answer queries on (just) "channel".
In response to
pgsql-performance by date
|Next:||From: Neil Conway||Date: 2003-10-27 15:41:49|
|Subject: Re: Various performance questions|
|Previous:||From: Christopher Kings-Lynne||Date: 2003-10-27 15:16:05|
|Subject: Linux Filesystem Shootout|