Re: Index row requires 9324 bytes maximum size is 8191

Euler Taveira de Oliveira-2 wrote:
>
> solAris23 escreveu:
>> I am trying to index a field in my database of size about 16K rows, but i
>> m
>> getting this error.
>>
> Why are you want to index such a big field? BTW, it'll be worthless.
>
>> " Index row requires 9324 bytes maximum size is 8191  "
>>
> That is a known limitation; but even if it would be possible I don't think
> it
> would be a good idea. Why on Earth would I search using a big field?
>
> What kind of content are you trying to index?
>
> Thanks for the feed back... Actually I want to index text field which is
> substantially big.
> As I already told in the post.. the searching takes too long.. so I want
> to index it....
>
> I went through gist and gin indexes but they are applicable for tsvector
> and tsquery i think...
>
> For me any option is fine... if i am able to get result within a
> second....
>
> Thanks.
>
>
> --
>   Euler Taveira de Oliveira
>   http://www.timbira.com/
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>

--
View this message in context:
http://www.nabble.com/Index-row-requires-9324-bytes-maximum-size-is-8191-tp25511356p25549641.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.