Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Query - Mailing list pgsql-performance

From 林士博
Subject Re: Slow Query
Date
Msg-id CACudzGgToR=4k1Ca0q6Px2cR1baju2sEcFVzRZYKTBYNs0DXXA@mail.gmail.com
Whole thread Raw
In response to Slow Query  (robbyc <robcampbell73@gmail.com>)
List pgsql-performance
Tree view
OK.

If you benchmark that correctly, 
then it seems that adding some redundant search can get the query faster in some special cases.

And without further info, I can not see any reason.

2015-08-14 14:35 GMT+09:00 Robert Campbell <robcampbell73@gmail.com>:
Hi,

My mistake, didnt apply the sub query properly the first time.

It does return records but not quite as fast as original query, about 200ms slower

Vacancy ID is a primary key.

On Fri, Aug 14, 2015 at 3:10 PM, 林士博 <lin@repica.co.jp> wrote:
Is the "Vacancy"."ID" a primary key?
Or is unique in Vacancy table?




--



pgsql-performance by date:

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