Skip site navigation (1) Skip section navigation (2)

Index row requires 9324 bytes maximum size is 8191

From: solAris23 <vikas(dot)kumar(at)dolcera(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Index row requires 9324 bytes maximum size is 8191
Date: 2009-09-18 16:06:44
Message-ID: 25511356.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-performance

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 ??

-- 
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.


Responses

pgsql-performance by date

Next:From: Robert HaasDate: 2009-09-18 17:50:37
Subject: Re: Different query plans for the same query
Previous:From: Tom LaneDate: 2009-09-18 15:42:31
Subject: Re: Different query plans for the same query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group