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@xxxxxxxxxxxxxx) > 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
