Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd error message (" hash indexes do not support whole-index - Mailing list pgsql-sql

From Marinos Yannikos
Subject Re: Odd error message (" hash indexes do not support whole-index
Date
Msg-id 42685C98.3000404@geizhals.at
Whole thread Raw
In response to Re: Odd error message (" hash indexes do not support whole-index scans")  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Enrico Weigelt
Date:
Subject: RULE for mtime recording
Next
From: "Dinesh Pandey"
Date:
Subject: How to install Postgres that supports 64-bit integer/date-time.