Re: [HACKERS] intarray planning/exeuction problem with multiple operators

2015-07-13 Thread Tom Lane
Jeff Janes writes: > I've found an interesting performance problem in the intarray extension > module. It doesn't seem to be version dependent, I've verified it in 9.4.4 > and 9.6devel. Seems like this isn't specifically an issue for intarray, but rather one with the core GIN code not being smar

Re: [HACKERS] intarray planning/exeuction problem with multiple operators

2015-07-13 Thread Uriy Zhuravlev
On Sunday 12 July 2015 23:12:41 Jeff Janes wrote: > I've found an interesting performance problem in the intarray extension > module. It doesn't seem to be version dependent, I've verified it in 9.4.4 > and 9.6devel. Hello. Look at my patch. Maybe he solves this problem. https://commitfest.postgr

[HACKERS] intarray planning/exeuction problem with multiple operators

2015-07-12 Thread Jeff Janes
I've found an interesting performance problem in the intarray extension module. It doesn't seem to be version dependent, I've verified it in 9.4.4 and 9.6devel. If I do a query that involves both an = op and a @@ op ANDed together, it gives a high cost estimate, which is justified by the slow run