Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison

From: 林士博 <lin(at)repica(dot)co(dot)jp>
To: twoflower <standa(dot)kurik(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Date: 2015-09-01 09:45:00
Message-ID: CACudzGhZi_LKCat-bhSBWh=gx+mW=sverz=KDzCYwW6W6bTdjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I think you should try putting the precomputed boolean temp_eval column
to "EXTERNAL_TRANSLATION" r table.

And if possible, try creating a conditional index on id where temp_eval is
true,
on "EXTERNAL_TRANSLATION" r table.

So that, only check this index can get the top 1000 records.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message twoflower 2015-09-01 09:51:50 Re: Re: Query > 1000× slowdown after adding datetime comparison
Previous Message twoflower 2015-09-01 07:53:45 Re: Re: Query > 1000× slowdown after adding datetime comparison