Search Postgresql Archives

Re: Query never completes with an OR condition

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

Subject: Re: Query never completes with an OR condition
From: Andrew Gierth <andrew@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 03 Dec 2018 18:09:14 +0000
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <20181203162836.GC16983@aart.rice.edu> (Kenneth Marshall's message of "Mon, 3 Dec 2018 10:28:36 -0600")
References: <20181203162836.GC16983@aart.rice.edu>
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix)

>>>>> "Kenneth" == Kenneth Marshall <ktm@xxxxxxxx> writes:

 Kenneth> The individual queries run as expected, but when the OR
 Kenneth> condition is added, it never finishes.

http://blog.rhodiumtoad.org.uk/2017/01/22/performance-issues-with-ored-conditions/

-- 
Andrew (irc:RhodiumToad)

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

Follow-Ups:
- Re: Query never completes with an OR condition
  - From: Stephen Frost

References:
- Query never completes with an OR condition
  - From: Kenneth Marshall

Prev by Date: Re: How to watch for schema changes
Next by Date: DROP CASCADE transitive dependencies
Previous by thread: Query never completes with an OR condition
Next by thread: Re: Query never completes with an OR condition
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux