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
not only that's slow, but limited as you can see. Use something like:
http://gjsql.wordpress.com/2009/04/19/how-to-speed-up-index-on-bytea-text-etc/
instead.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
* solAris:
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 ???
How are your queries structured? Do you just compare values? Do you
perform range
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.
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
Hello
2009/9/18 solAris23 vikas.ku...@dolcera.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