Re: Problem with slow query with WHERE conditions with OR clause on primary keys

From: "kolszew73(at)gmail(dot)com" <kolszew73(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with slow query with WHERE conditions with OR clause on primary keys
Date: 2013-12-18 19:23:21
Message-ID: 1387394601821-5783927.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thanx for your answer

My example is trivial because i want to show strange (for me) postgres
behavior with dealing with primary keys (extreme example), in real situation
user put search condition e.g. "Panas" and this generates query
...
where gd.other_code like 'Panas%' OR g.code like 'Panas%'
..

both columns has very good indexes and selectivity for "like 'Panas%'" ...

I have experience from Oracle with this type of queries, and Oracle have no
problem with it,
executes select on index on other_code from gd and join g
in next step executes select on index on code from g and join gd
and this two results are connected in last step (like union)
very fast on minimal cost

and in my opinion read whole huge tables only for 10 rows in result where
conditions are very good ... is strange

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Problem-with-slow-query-with-WHERE-conditions-with-OR-clause-on-primary-keys-tp5782803p5783927.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message prashant Pandey 2013-12-18 20:12:20 Regarding Hardware Tuning
Previous Message Guillaume Lelarge 2013-12-18 08:30:27 Re: Current query of the PL/pgsql procedure.