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 and > when a string matc

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

Re: Data migration from postgres 8.4 to 9.4

Am 16.04.2018 um 09:03 schrieb Akshay Ballarpure: > Hello, Hi Akshay, > I need help in using postgresql 8.4 data in postgres 9.4 version. Do I > need to run any tool to achieve the same? Yes. (-performance is probably the wrong place to ask though, please try -general or -admin next time) Pleas

Data migration from postgres 8.4 to 9.4

Hello, I need help in using postgresql 8.4 data in postgres 9.4 version. Do I need to run any tool to achieve the same? Steps i followed is ran postgresql 8.4 and 9.4, copied data from 8.4 instance to 9.4 and try to start postgresql 9.4 but no luck, getting below error. [root@ms-esmon esm-dat