indexing longish string - Mailing list pgsql-sql

From Rob Sargent
Subject indexing longish string
Date
Msg-id 4CF53797.4040806@gmail.com
Whole thread Raw
Responses Re: indexing longish string  (jose <jojapasa@gmail.com>)
List 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.




pgsql-sql by date:

Previous
From: manidegr8
Date:
Subject: Re: Deleting entries from multiple tables
Next
From: jose
Date:
Subject: Re: indexing longish string