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

On 04/17/2018 05:43 PM, Hackety Man wrote: > > > On Tue, Apr 17, 2018 at 10:23 AM, Tomas Vondra > > wrote: > > > > On 04/17/2018 04:01 PM, Hackety Man wrote: > > ... > Right.  I was more wondering why it switched

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

On Tue, Apr 17, 2018 at 10:23 AM, Tomas Vondra wrote: > > > On 04/17/2018 04:01 PM, Hackety Man wrote: > >> >> >> On Tue, Apr 17, 2018 at 6:49 AM, Tomas Vondra < >> tomas.von...@2ndquadrant.com > >> wrote: >> >> >> >> On

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

2018-04-17 12:52 GMT+02:00 Tomas Vondra : > > > On 04/17/2018 07:17 AM, Pavel Stehule wrote: > >> Hi >> >> 2018-04-16 22:42 GMT+02:00 Hackety Man hackety...@gmail.com>>: >> >> ... >> > > > >> A support of parallel query execution is not

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

Hi Pavel, Thanks for sharing that information. I was not aware that the parallel query functionality was not yet fully implemented. Thanks, Ryan On Tue, Apr 17, 2018 at 1:17 AM, Pavel Stehule wrote: > Hi > > 2018-04-16 22:42 GMT+02:00 Hackety Man

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

On Tue, Apr 17, 2018 at 6:49 AM, Tomas Vondra wrote: > > > On 04/16/2018 10:42 PM, Hackety Man wrote: > >> ... >> The first thing I did was to run some baseline tests using the basic >> queries inside of the IF() checks found in each of the functions to >>

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

Hi 2018-04-16 22:42 GMT+02:00 Hackety Man : > *A description of what you are trying to achieve and what results you > expect.:* > > My end goal was to test the execution time difference between using an > IF(SELECT COUNT(*)...) and an IF EXISTS() when no indexes were used

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

*A description of what you are trying to achieve and what results you expect.:* My end goal was to test the execution time difference between using an IF(SELECT COUNT(*)...) and an IF EXISTS() when no indexes were used and when a string match was not found. My expectation was that my 2 functions