Re: Re: Query > 1000× slowdown after adding datetime comparison

From: twoflower <standa(dot)kurik(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Re: Query > 1000× slowdown after adding datetime comparison
Date: 2015-08-31 20:30:41
Message-ID: 1441053041230-5864101.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stefan Keller 2015-08-31 21:00:28 Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
Previous Message Stefan Keller 2015-08-31 20:24:35 Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison