Sergey Konoplev wrote: > > Another thing is that even I set statement_timeout to 20s the query > with NOT IN finishes working after 30+ seconds without "canceled by > statement timeout" error.
Maybe it's not taking that long to execute the query then. Maybe something to do with process startup is delaying things - could you tweak the test script to send the outputs of the explain somewhere other than /dev/null? That way we'd know if there was a big difference between query-execution-time and process-execution-time. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
