Re: Evaluating boolean formula: slow performance

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

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Evaluating boolean formula: slow performance
From: Jörg Kiegeland <kiegeland@xxxxxx>
Date: Fri, 11 Jan 2008 18:42:13 +0100
In-reply-to: <4787A1FB.2050808@xxxxxx>
References: <4787A1FB.2050808@xxxxxx>
User-agent: Thunderbird 1.5.0.10 (Windows/20070221)

I have to correct my statement, a query seems to be only linear whenusing OR.

This however is strange since some weeks ago, I could get good responsetimes when using exclusively AND.


I will investigate on this..


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

References:
- Evaluating boolean formula: slow performance
  - From: Jörg Kiegeland

Prev by Date: Evaluating boolean formula: slow performance
Next by Date: Re: Best way to index IP data?
Previous by thread: Evaluating boolean formula: slow performance
Next by thread: Simple select, but takes long time
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