On 25.07.2017 00:17, PT wrote:
The IN clause is not what's taking all the time. It's the processing of millions of rows that's taking all the time.
IN (...) - 17 sec IN (VALUES ...) - 4 sec So performance issue is with IN-clause.
Perhaps you should better describe what it is you really want to accomplish. Regardless of what it is, if it involves processing many millions of rows, you're probably going to need to do some sort of materialization.
I try to find better solutions for IN-task. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
