Re: how to make this database / query faster - Mailing list pgsql-general

From brian
Subject Re: how to make this database / query faster
Date
Msg-id 47DC6A2C.6040703@zijn-digital.com
Whole thread Raw
In response to Re: how to make this database / query faster  (mark <markkicks@gmail.com>)
List pgsql-general
mark wrote:
> On Sat, Mar 15, 2008 at 5:04 PM, brian <brian@zijn-digital.com> wrote:
>>
>> As there's an index on id would it be faster to transpose the WHERE
>> conditions?
>>
>> WHERE id > your_last_id
>> AND session_key IS NOT NULL
>>
>> I can't remember if the order of WHERE is significant.
>
> brian,
> i have an index on session_key also
>

Yeah, I should have asked, "If there's just the index on id ..."

 > but i dont have a session key combined on both. should i do that?

I'll defer to someone with more insight.

pgsql-general by date:

Previous
From: mark
Date:
Subject: Re: how to make this database / query faster
Next
From: Dave Potts
Date:
Subject: Re: Loging of postgres requests