Re: Uninterruptible long planning of a query with too many WHERE clauses

2018-11-12 Thread Tom Lane
Alexander Kuzmenkov writes: > El 11/11/18 a las 07:38, Tom Lane escribió: >> I think you have the right basic idea, but we don't have to completely >> lobotomize the bitmap-and search logic in order to cope with this. >> This code is only trying to figure out which paths are potentially >> redunda

Re: Uninterruptible long planning of a query with too many WHERE clauses

2018-11-12 Thread Alexander Kuzmenkov
El 11/11/18 a las 07:38, Tom Lane escribió: I think you have the right basic idea, but we don't have to completely lobotomize the bitmap-and search logic in order to cope with this. This code is only trying to figure out which paths are potentially redundant, so for a path with too many quals, we

Re: Uninterruptible long planning of a query with too many WHERE clauses

2018-11-10 Thread Tom Lane
Alexander Kuzmenkov writes: > Recently one of our customers encountered a situation when the planning > of a particular query takes too long (several minutes) and can't be > interrupted by pg_terminate_backend(). The query and schema are attached > (this is generated by Zabbix). Ugh. I hope t