Citext Performance

Apology for sending you emails directly but I do see you guys responding on email related to performance so thought of copying you folks. Folks, I read following (PostgreSQL: Documentation: 9.6: citext) and it does not hold true in my testing.. i.e citext is not performing better than lower.Am

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 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, p

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 > mailto:tomas.von...@2ndquadrant.com>> wrote: > > > > On 04/17/2018 04:01 PM, Hackety Man wrote: > > ... > Right.  I was more wondering why it switched over to a generic > pla

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

>>> >>> >>> Right. I was more wondering why it switched over to a generic plan, as >>> you've stated, like clockwork starting with the 6th execution run. >>> >>> >> That's a hard-coded value. The first 5 executions are re-planned using >> the actual parameter values, and then we try generating a g

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 04/16/2018 10:42 PM, Hackety Man wr

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 complete - it doesn't work >> in PostgreSQL 11 too. So alt

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 : > >> *A description of what you are trying t

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 >> see how the query planner ha

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 04:01 PM, Hackety Man wrote: On Tue, Apr 17, 2018 at 6:49 AM, Tomas Vondra mailto:tomas.von...@2ndquadrant.com>> 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

RE: Data migration from postgres 8.4 to 9.4

Thank you for detailed info. much appreciated. May i know how to install pg_upgrade ? With Best Regards Akshay From: "Albin, Lloyd P" To: Akshay Ballarpure Date: 04/16/2018 08:38 PM Subject:RE: Data migration from postgres 8.4 to 9.4 Akshay , There are several Official

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 07:17 AM, Pavel Stehule wrote: Hi 2018-04-16 22:42 GMT+02:00 Hackety Man >: ... > A support of parallel query execution is not complete -  it doesn't work in PostgreSQL 11 too. So although EXISTS variant can be faster (but can be - the worst case

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/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 see how the query planner handled them.  I ran the following two queries. EXPLAIN (ANA

Installing PostgreSQL 9.5 in centos 6 using YUM

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, refresh-packag