Re: [GENERAL] Multicolumn Index on OR conditions

2017-09-22 Thread legrand legrand
No You should try with 2 single column indexes and may be rewrite your query with a Union All syntax -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] Multicolumn Index on OR conditions

2017-09-19 Thread vinny
On 2017-09-19 10:08, Job wrote: Hi, within a query with two or more conditions with "OR", example: "where a = 2 or b < 3" could be useful to speed up the query a multi-column index (a,b) even though the two conditions are in "OR" and not in "AND"? Thank you! F Having any kind of index usual