Re: [PERFORM] Query performing very bad and sometimes good

2014-08-06 Thread Kevin Grittner
Andreas Joseph Krogh andr...@visena.com wrote: Some-times it performs much better (but still not good) As has already been suggested, that difference is almost certainly due to differences in how much of the necessary data is cached or what the query is competing with. Does anyone see

[PERFORM] Query performing very bad and sometimes good

2014-08-05 Thread Andreas Joseph Krogh
Hi all.   Running version: on= select version();   version  PostgreSQL 9.3.2 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro

Re: [PERFORM] Query performing very bad and sometimes good

2014-08-05 Thread David G Johnston
Andreas Joseph Krogh-2 wrote Hi all.   Running version: on= select version();   version  PostgreSQL 9.3.2 on