Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions - Mailing list pgsql-performance

From johno
Subject Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
Date
Msg-id CACuOPqCo0ma4JNgPsoz8-JJkR_ebC6F9sLWadwBvmS9LG6CfTA@mail.gmail.com
Whole thread Raw
In response to Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Евгений Селявка
Date:
Subject: estimate btree index size without creating
Next
From: Benjamin Dugast
Date:
Subject: Re: Blocking every 20 sec while mass copying.