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 10:25:31
Message-ID: CACudzGiQO2gMtcwvjGFV-FU2dwGM7J6hobu5nhMNX-ynyLZ6=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

By the way, if you set the documenttype with an unexisted value,
the query would check all the records, and it would run slower than the
original one.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message FattahRozzaq 2015-09-02 12:16:23 PostgreSQL Tuning for Messaging/Messenger/Chatting Application
Previous Message 林士博 2015-09-01 10:15:21 Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison