public inbox for [email protected]
help / color / mirror / Atom feedFrom: Yevhenii Kurtov <[email protected]>
To: Jeff Janes <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re:
Date: Fri, 30 Jun 2017 02:11:43 +0700
Message-ID: <CAJhrTGzJwsTtbbuD8G24AFgkL2ny52=Ea62k6P=LR+_pi_61qQ@mail.gmail.com> (raw)
In-Reply-To: <CAMkU=1x2+kW2KMon7Y7wzK0b0KpxFfdN0SuPODJ6KmHbE6saeQ@mail.gmail.com>
References: <CAJhrTGxffyaiu1JwhYkY3noy5ukiyREpzv5yT_5CGubVzMXmqw@mail.gmail.com>
<CAMkU=1x2+kW2KMon7Y7wzK0b0KpxFfdN0SuPODJ6KmHbE6saeQ@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
Hi Jeff,
That is just a sample data, we are going live in Jun and I don't have
anything real so far. Right now it's 9.6 and it will be a latest stable
available release on the date that we go live.
On Fri, Jun 30, 2017 at 1:11 AM, Jeff Janes <[email protected]> wrote:
> On Tue, Jun 27, 2017 at 11:47 PM, Yevhenii Kurtov <
> [email protected]> wrote:
>
>> Hello,
>>
>> We have a query that is run almost each second and it's very important to
>> squeeze every other ms out of it. The query is:
>>
>> SELECT c0."id" FROM "campaign_jobs" AS c0
>> WHERE (((c0."status" = $1) AND NOT (c0."id" = ANY($2))))
>> OR ((c0."status" = $3) AND (c0."failed_at" > $4))
>> OR ((c0."status" = $5) AND (c0."started_at" < $6))
>> ORDER BY c0."priority" DESC, c0."times_failed"
>> LIMIT $7
>> FOR UPDATE SKIP LOCKED
>>
>>
>
>
>>
>> I see that query still went through the Seq Scan instead of Index Scan.
>> Is it due to poorly crafted index or because of query structure? Is it
>> possible to make this query faster?
>>
>
> An index on (priority desc, times_failed) should speed this up massively.
> Might want to include status at the end as well. However, your example data
> is not terribly realistic.
>
> What version of PostgreSQL are you using?
>
> Cheers,
>
> Jeff
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re:
In-Reply-To: <CAJhrTGzJwsTtbbuD8G24AFgkL2ny52=Ea62k6P=LR+_pi_61qQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox