From: | Teodor Sigaev <teodor(at)stack(dot)net> |
---|---|
To: | hs(at)cybertec(dot)at |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problems with Gist when migrating from 7.1.3 -> 7.3.x |
Date: | 2003-02-20 08:58:31 |
Message-ID: | 3E5498B7.2050203@stack.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
First of all try disable index scan.
For further, pls, create minimal test suite demostrated this problem...
Hans-Jürgen Schönig wrote:
> Hallo ...
>
> We have a problem with Gist fields when migrating from 7.1.3 to 7.3. Our
> queries lead to different results. Actually data is lost somehow.
>
> The problem occurs when running queries like that:
>
> where (( key2img @ '{44756,44809}' or key2img && '{49582}' ) and not
> key2img
> && '{47343}' )
>
> 7.1.3 seems to return the correct result. 7.3 is much faster but returns
> nothing.
> Is it a bug? Is it a conceptual change? What went wrong? Did anybody
> encount similour problems?
>
> Regards,
>
> Hans
> <http://kernel.cybertec.at>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Teodor Sigaev
teodor(at)stack(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Vitaly | 2003-02-20 09:12:54 | error while working with pgsql in php |
Previous Message | Shridhar Daithankar<shridhar_daithankar@persistent.co.in> | 2003-02-20 06:32:01 | Re: 7.3.1 takes long time to vacuum table? |