The following bug has been logged on the website: Bug reference: 8196 Logged by: Ara Email address: aray1...@yahoo.com PostgreSQL version: 9.1.9 Operating system: ubuntu Description:
I have to tables which I'm joining with left join query. SELECT count(*) FROM table A LEFT JOIN table B ON ... result has 200 000 rows, for 190 000 of them there is no value for columns of table B (result of join) ISSUE: When I'm trying to filter result with WHERE B.some_column IS NULL query works more then 5 min (never waited for result). MORE INFO: When I'm filtering results with WHERE B.some_column IS NULL OR B.some_column = 'some value that some_column would never had' the query takes 2 second and gives normal result (190 000). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
