Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Query - Mailing list pgsql-performance

From 林士博
Subject Re: Slow Query
Date
Msg-id CACudzGibWcux4Zy72oxD2QmeyyqPqGCP+hg3DDidGrcWt6by3A@mail.gmail.com
Whole thread Raw
In response to Re: Slow Query  (robbyc <robcampbell73@gmail.com>)
Responses Re: Slow Query  (robbyc <robcampbell73@gmail.com>)
List pgsql-performance
Tree view
In the 'not exists' cluster, you do not have to search table "Vacancy as v" again.
I think it would be faster to use the outer Vacancy table as below.
In your case, that do the same work.

NOT EXISTS (
        SELECT 1
        FROM "CategoryOption_TableRow" "ct126" 
        WHERE "Vacancy"."Template"
          AND "ct126"."CategoryOptionID" IN (34024,35254,35255,35256)
          AND "ct126"."Category_TableID" = 126
          AND "ct126"."RowID" = "Vacancy"."ID"
          )

pgsql-performance by date:

Previous
From: robbyc
Date:
Subject: Re: Slow Query
Next
From: Josh Berkus
Date:
Subject: Strange query stalls on replica in 9.3.9