Re: [GENERAL] 8.3 beta problems

2007-10-17 Thread Marek Lewczuk
Tom Lane pisze: I'm wondering if you have an example that doesn't work well with the gist page-splitting heuristic changes that Teodor put in awhile back. Those are all in 8.2.5 already, though you might have to REINDEX to really notice a change if the index was first built with an older 8.2.x re

Re: [GENERAL] 8.3 beta problems

2007-10-16 Thread Tom Lane
Marek Lewczuk <[EMAIL PROTECTED]> writes: >> 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. Comparing to 8.2.which-exactly? I'm wondering if you have an example that doesn't work well with the gist page-split

Re: [GENERAL] 8.3 beta problems

2007-10-16 Thread Pavel Stehule
2007/10/16, Marek Lewczuk <[EMAIL PROTECTED]>: > 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 ab

Re: [GENERAL] 8.3 beta problems

2007-10-16 Thread Marek Lewczuk
Marek Lewczuk pisze: 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