Postgres Pro
Downloads
Home   >   mailing lists

Index row requires 9324 bytes maximum size is 8191 - Mailing list pgsql-performance

From solAris23
Subject Index row requires 9324 bytes maximum size is 8191
Date
Msg-id 25511356.post@talk.nabble.com
Whole thread Raw
Responses Re: Index row requires 9324 bytes maximum size is 8191  (Euler Taveira de Oliveira <euler@timbira.com>)
Re: Index row requires 9324 bytes maximum size is 8191  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Index row requires 9324 bytes maximum size is 8191  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: Index row requires 9324 bytes maximum size is 8191  (Florian Weimer <fweimer@bfk.de>)
List pgsql-performance
Tree view 

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.

pgsql-performance by date:

Previous
From: Michael Korbakov
Date:
Subject: Planner question - wrong row count estimation
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Index row requires 9324 bytes maximum size is 8191