[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    =?UTF-8?Q?Re:_[PERFORM]_Re:_Query_>_1000=C3=97_slow?= =?UTF-8?Q?down_after_adding_datetime_compariso
From:       twoflower <standa.kurik () gmail ! com>
Date:       2015-08-31 20:30:41
Message-ID: 1441053041230-5864101.post () n5 ! nabble ! com
[Download RAW message or body]

I did not. I wanted to compare this query to the one I tried before, having
*documenttype = 4* as the sole condition. That one was very fast and the
*documenttype* was not indexed either. 

But this query, using the new temporary column, still runs, after 48
minutes...



--
View this message in context: \
http://postgresql.nabble.com/Query-1-000-000-slowdown-after-adding-datetime-comparison-tp5864045p5864101.html
 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[prev in list] [next in list] [prev in thread] [next in thread]