Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison - Mailing list pgsql-performance

From 林士博
Subject Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Date
Msg-id CACudzGiQO2gMtcwvjGFV-FU2dwGM7J6hobu5nhMNX-ynyLZ6=g@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison  (林士博 <lin@repica.co.jp>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: 林士博
Date:
Subject: Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Next
From: FattahRozzaq
Date:
Subject: PostgreSQL Tuning for Messaging/Messenger/Chatting Application