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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Tom Lane <tgl@xxxxxxxxxxxxx>
Subject: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
From: johno <jan.suchal@xxxxxxxxx>
Date: Tue, 22 Jul 2014 12:42:26 +0200
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <11612.1406009729@sss.pgh.pa.us>

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.

References:
- Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
  - From: johno
- Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
  - From: Tom Lane
- Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
  - From: johno
- Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
  - From: Tom Lane

Prev by Date: estimate btree index size without creating
Next by Date: Re: Blocking every 20 sec while mass copying.
Previous by thread: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
Next by thread: estimate btree index size without creating
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux