Re: [GENERAL] array column and b-tree index allowing only 8191 bytes

2008-06-11 Thread Celso Pinto
ad to values such as 88 which is definately a no go. What, if any, would be the recommended options to improve this scenario? Not using intarray? :-) Cheers, Celso On Sáb, 2008-06-07 at 12:38 -0400, Alvaro Herrera wrote: > Celso Pinto wrote: > > > So my questions are: is this at all po

[GENERAL] array column and b-tree index allowing only 8191 bytes

2008-06-06 Thread Celso Pinto
Hi all, I'm checking out some features in pgsql and found out about an array datatype. As I'm curious to find out how well it performs, I've created a table that contains an integer[] column and a script to insert about 500K rows in it. The length for the integer[] column is random (can be 10, can