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

2014-08-06 Thread Kevin Grittner
Andreas Joseph Krogh 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 anything obvious or ha

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 x86_64-unknown-lin

[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