Hello 2009/9/18 solAris23 <vikas.kumar@xxxxxxxxxxx>: > > > Hello, > > I am trying to index a field in my database of size about 16K rows, but i m > getting this error. > > " Index row requires 9324 bytes maximum size is 8191 " > > Can anyone please guide me how to remove this error.... > > Also, average time to search for a query in a table is taking about 15 > seconds. I have done indexing but the time is not reducing..... > Is there any way to reduce the time to less than 1 sec ??? > The type of indexing which I am performing on the field is btree... My field > contains large text. Is there any more suitable indexing type ?? > you can use hashing functions http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Using_hash_functions_for_ensuring_uniqueness_of_texts regards Pavel Stehule > -- > View this message in context: http://www.nabble.com/Index-row-requires-9324-bytes-maximum-size-is-8191-tp25511356p25511356.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 > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
