From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Marek Lewczuk" <newsy(at)lewczuk(dot)com> |
Cc: | "Lista dyskusyjna pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 8.3 beta problems |
Date: | 2007-10-16 10:56:47 |
Message-ID: | 162867790710160356k2fb24747r22c32ee9e5dd6913@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2007/10/16, Marek Lewczuk <newsy(at)lewczuk(dot)com>:
> 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
>
attach execution plan, please.
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Nico Sabbi | 2007-10-16 11:18:55 | Inconsistence in transaction isolation docs |
Previous Message | Marek Lewczuk | 2007-10-16 10:53:07 | Re: 8.3 beta problems |