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 Thread Tomas Vondra
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...)

2018-04-17 Thread Hackety Man
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 Thread Pavel Stehule
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...)

2018-04-17 Thread Hackety Man
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...)

2018-04-17 Thread Hackety Man
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 >>

Installing PostgreSQL 9.5 in centos 6 using YUM

2018-04-17 Thread Dinesh Chandra 12108
Hi Team, Could anyone help me to solve the below issue. I am installing PostgreSQL 9.5 in centos 6 using YUM [root@VM-02 PostgreSQL]# yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-3.noarch.rpm Loaded plugins: fastestmirror,