Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions

From: johno <jan(dot)suchal(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
Date: 2014-07-22 10:42:26
Message-ID: CACuOPqCo0ma4JNgPsoz8-JJkR_ebC6F9sLWadwBvmS9LG6CfTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> No, it doesn't. Read it again ... or read up on row comparisons,
> if you're unfamiliar with that notation. The above queries are
> exactly equivalent per spec.
>

Wow, this is great. Thanks.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Benjamin Dugast 2014-07-23 09:39:20 Re: Blocking every 20 sec while mass copying.
Previous Message Евгений Селявка 2014-07-22 07:38:18 estimate btree index size without creating