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

Re: Index row requires 9324 bytes maximum size is 8191

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: solAris23 <vikas(dot)kumar(at)dolcera(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index row requires 9324 bytes maximum size is 8191
Date: 2009-09-20 05:47:08
Message-ID: 162867790909192247o2d883011wc63a4dbcb99402d3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello

2009/9/18 solAris23 <vikas(dot)kumar(at)dolcera(dot)com>:
>
>
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

pgsql-performance by date

Next:From: Grzegorz JaśkiewiczDate: 2009-09-21 08:38:38
Subject: Re: Index row requires 9324 bytes maximum size is 8191
Previous:From: Euler Taveira de OliveiraDate: 2009-09-20 02:58:43
Subject: Re: Index row requires 9324 bytes maximum size is 8191

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