Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
From
: 林士博 <
lin@xxxxxxxxxxxx
>
Date
: Tue, 1 Sep 2015 19:25:31 +0900
Cc
:
pgsql-performance@xxxxxxxxxxxxxx
In-reply-to
: <CACudzGjdZJePOvKQoPM8wAscRhq9AwB42gk3r=vQmk9dh9zY5g@mail.gmail.com>
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.
References
:
Re: Query > 1000× slowdown after adding datetime comparison
From:
Tomas Vondra
Re: Query > 1000× slowdown after adding datetime comparison
From:
twoflower
Re: Query > 1000× slowdown after adding datetime comparison
From:
twoflower
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
From:
David G. Johnston
Re: Re: Query > 1000× slowdown after adding datetime comparison
From:
twoflower
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
From:
Stefan Keller
Re: Re: Query > 1000× slowdown after adding datetime comparison
From:
twoflower
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
From:
Stefan Keller
Re: Re: Query > 1000× slowdown after adding datetime comparison
From:
twoflower
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
From:
林士博
Re: Re: Query > 1000× slowdown after adding datetime comparison
From:
twoflower
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
From:
林士博
Prev by Date:
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Next by Date:
PostgreSQL Tuning for Messaging/Messenger/Chatting Application
Previous by thread:
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Next by thread:
Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]