From: | solAris23 <vikas(dot)kumar(at)dolcera(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Index row requires 9324 bytes maximum size is 8191 |
Date: | 2009-09-24 09:49:17 |
Message-ID: | 25549641.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | tv | 2009-09-24 09:56:12 | Re: Slow query after upgrade to 8.4 |
Previous Message | Scott Marlowe | 2009-09-24 09:07:24 | Re: Speed while runnning large transactions. |