indexing longish string

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: indexing longish string
Date: 2010-11-30 17:42:47
Message-ID: 4CF53797.4040806@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Were we to create a table which included a text field for a small block
of xml (100-1000 chars worth), would an index on that field be useful
against exact match queries?

We're wondering if a criterion such as "where 'a string expected to be
of size range 100 to 500' = tabelWithStrings.stringSearched" would make
good use of an index on "stringSearched" column.

The key is that there will only be exact match queries.

Thanks for your thoughts.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jose 2010-11-30 17:50:05 Re: indexing longish string
Previous Message Florian Weimer 2010-11-30 14:16:23 Re: Is there a solution for "SELECT OR INSERT"