Home > mailing lists

Re: [GENERAL] Multicolumn Index on OR conditions - Mailing list pgsql-general

From	legrand legrand
Subject	Re: [GENERAL] Multicolumn Index on OR conditions
Date	September 23, 2017 03:51:24
Msg-id	1506117084551-0.post@n3.nabble.com Whole thread Raw
In response to	[GENERAL] Multicolumn Index on OR conditions (Job <Job@colliniconsulting.it>)
List	pgsql-general

Tree view

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:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

From: Andrei Matei
Date: 23 September 2017, 03:11:31
Subject: [GENERAL] errors on COMMIT and transaction states

From: Paul A Jungwirth
Date: 23 September 2017, 08:52:33
Subject: [GENERAL] Is float8 a reference type?

Re: [GENERAL] Multicolumn Index on OR conditions - Mailing list pgsql-general

Previous

Next