Re: Index usage on OR queries - Mailing list pgsql-general

From Tore Halvorsen
Subject Re: Index usage on OR queries
Date
Msg-id CADGw-SdrYq87UvtG9OxG+1i4vyxjOOK_W-xePM6cavC-Bx0pgA@mail.gmail.com
Whole thread Raw
In response to Index usage on OR queries  (Tore Halvorsen <tore.halvorsen@gmail.com>)
List pgsql-general
-- This can be optimized by using CTEs
with am as (
  select * from a where time >= '2011-08-15'
)
, bm as (
  select * from b where time >= '2011-08-15'
)
select * from am join bm using(id)

Disregard this, it doesn't to the same at all.

Now I'm more confused as to how I can optimize the query.


--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2011 Tore Halvorsen || +052 0553034554

pgsql-general by date:

Previous
From: Tore Halvorsen
Date:
Subject: Index usage on OR queries
Next
From: Jeff Ross
Date:
Subject: Re: FATAL: terminating connection due to conflict with recovery