Search Postgresql Archives

index type for indexing long texts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



(I'm reposting this because the original message didn't make it through in the last ~20 hours)

Hi,

I'm looking for a solution for indexing long TEXT columns. We're currently using a HASH index, which can handle most situations, but every now and then we need support for even longer texts.

One solution would be to create a functional index which would only use the first N chars of mycol, but then we'd have to change several hundred occurences of "mycol = someval" with "(mycol = someval AND firstN(mycol) = firstN(someval))", as well as update some SQL generators...

That's why I'd be interested to know if there are any index types available which store only the first N chars or use some highly compressed form for storing index data, and then recheck any potential hits against the main table. And if something like that does not exist yet, how difficult would it be to construct such a solution out of many "spare parts" that come with PG?

All we really need is index support for the "=" operator; everything else is optional.
We're currently using PG 8.1.

I'd be grateful for any suggestions.

Regards,
Aleksander


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux