Re: [PERFORM] Weird CASE WHEN behaviour causing query to be suddenly very slow

We have to confirm the theory first: a 'perf top' sampling during two runs shall give enough information. Regards, Qingqing On Tue, Mar 31, 2015 at 8:58 AM, Kevin Viraud wrote: > Touche ! Thanks a lot. > > Looking more at the data yes it goes very often to ELSE Clause. And > therefore reaching

Re: [PERFORM] Weird CASE WHEN behaviour causing query to be suddenly very slow

On 3/31/15 10:58 AM, Kevin Viraud wrote: Touche ! Thanks a lot. Looking more at the data yes it goes very often to ELSE Clause. And therefore reaching the MAX_CACHED_RES. In there anyway to increase that value ? Sure, change it and re-compile. But be aware that increasing it will probably

Re: [PERFORM] views much slower in 9.3 than 8.4

On 3/30/15 10:52 AM, Tom Lane wrote: Kevin Grittner writes: >Tom Lane wrote: >>But the other problem is that the planner considers less-than-1% >>differences in cost estimates to be "in the noise", which means >>that it's not going to consider cost differences of less than >>1480 units in the

Re: [PERFORM] Some performance testing?

Care to elaborate? We usually do not recommend specific kernel versions for our customers (who run on a variety of distributions). Thanks, M. Mel Llaguno • Staff Engineer – Team Lead Office: +1.403.264.9717 x310 www.coverity.com • Twitter: @coverity Coverity by Synopsys

Re: [PERFORM] Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

Hi Jeff > The default collation for the database cluster is set when you create the > cluster with initdb (the package you used to install postgresql might provide > scripts that wrap initdb and call it something else, sorry I can't be much > use with those). > You can set it with --lc-colla

Re: [PERFORM] Some performance testing?

On 04/07/2015 09:46 AM, Mel Llaguno wrote: > FYI - all my tests were conducted using Ubuntu 12.04 x64 LTS (which I > believe are all 3.xx series kernels). If it's 3.2 or 3.5, then your tests aren't useful, I'm afraid. Both of those kernels have known, severe, memory management issues. -- Josh B

Re: [PERFORM] Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

I meant “collation”, not “collection”. Pietro Il giorno 07/apr/2015, alle ore 18:49, Pietro Pugni ha scritto: > >> On Tue, Apr 7, 2015 at 6:27 AM, Pietro Pugni wrote: >> Hi Jeff, >> sorry for the latency but server was down due to a error I made in the >> sysctl.conf file. >>> Yes, b

Re: [PERFORM] Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

> On Tue, Apr 7, 2015 at 6:27 AM, Pietro Pugni wrote: > Hi Jeff, > sorry for the latency but server was down due to a error I made in the > sysctl.conf file. >> Yes, but are the defaults for those two systems? on psql, use \l to see. >> > > \l returns the following: > > T420 (Postgre

Re: [PERFORM] Some performance testing?

FYI - all my tests were conducted using Ubuntu 12.04 x64 LTS (which I believe are all 3.xx series kernels). Mel Llaguno • Staff Engineer – Team Lead Office: +1.403.264.9717 x310 www.coverity.com • Twitter: @coverity Coverity by Synopsys On 4/6/15, 2:51 PM, "Josh Berk