Re: Odd error message (" hash indexes do not support whole-index

From: Marinos Yannikos <mjy(at)geizhals(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Odd error message (" hash indexes do not support whole-index
Date: 2005-04-22 02:08:24
Message-ID: 42685C98.3000404@geizhals.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
> Good catch. But why are you using a hash index for this?

Just experimenting - I was trying to determine whether a hash index
would give better performance - the values are always unique except when
they're 0 and < > relations are never needed. That particular query
would have been needed only once for maintainance work.

Regards,
Marinos

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Igor Kryltsov 2005-04-22 05:24:10 Help to drop table
Previous Message Enrico Weigelt 2005-04-22 01:58:52 RULE for mtime recording