Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 04/17/2018 04:05 PM, Hackety Man wrote:
> Hi Pavel,
> 
> Thanks for sharing that information.  I was not aware that the parallel
> query functionality was not yet fully implemented.
> 

Nothing is ever "fully implemented". There are always gaps and possible
improvements ;-)

That being said, parallelism opens an entirely new dimension of possible
plans and planning issues.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux