David G Johnston wrote > What happens if you pre-compute the date condition and hard code it?
I created a new boolean column and filled it for every row in DOCUMENT with *(doc.date_last_updated >= date(now() - '171:00:00'::interval))*, reanalyzed the table and modified the query to just compare this column to TRUE. I expected this to be very fast, considering that a (to me, anyway) similar query also containing a constant value comparison finishes immediately. However, the query is running now for 4 minutes already. That's really interesting. -- View this message in context: http://postgresql.nabble.com/Query-1-000-000-slowdown-after-adding-datetime-comparison-tp5864045p5864088.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
