Tim Dudgeon wrote
> All relevant columns are indexed and using PostgreSQL 9.4.
> Any clues how to re-write it to avoid the slow sub-query.
Try using an actual join instead of a subquery. You will have to provide
aliases and then setup the where clause appropriately.
I am reading the query correctly in that the repeated reference to 643413 is
redundant? The lack of a defined natural primary key makes blind reasoning
difficult.
David J.
--
View this message in context: http://postgresql.nabble.com/slow-sub-query-problem-tp5827273p5827275.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.