Hello,
I'm testing 8.3beta and I think that there is a problem with gist/gin
indexes. The performance of 8.3 is very bad comparing to 8.2. I have a
table with an int[] column indexed using gin (or gist with intarray
module). Table contains about 1.5m rows, int[] length is from 2 to 6
elements. Now, on the 8.2 the simple query "select id from bundles where
path @> array[255,254]" runs about 0.5s returning 25k of rows. The same
query on 8.3 returns the same number of rows, but it requires about 40s.
Anybody has the same problems ?
Regards,
ML
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
