Re: [PERFORM] Possible regression (slow query on 9.2/9.3 when compared to 9.1)

2013-12-29 Thread Tom Lane
Ronaldo Maia writes: > Recently I have tried to upgrade our postgres instalation from 9.1 to 9.3, > but one query in particular got extremelly slow. FWIW, this test case doesn't reproduce any problem for me --- I get identical plans and indistinguishable timings (about 450ms on my machine) from 9

Re: [PERFORM] Error install -pgmemcache

2013-12-29 Thread Devrim GÜNDÜZ
Hi, On Wed, 2013-11-20 at 10:36 -0200, Rogerio Pereira wrote: > I'm trying install pgmemcache and occurs error: > > pgmemcache.h:29:23: error: sasl/sasl.h: No such file or directory > > Exists solution exists to fix to problem? You will need to install cyrus-sasl-devel package. Still, I jus

[PERFORM] query plan not optimal

2013-12-29 Thread Jeff Janes
On Thursday, December 19, 2013, Marc Cousin wrote: > > > Yeah, I had forgotten to set it up correctly on this test environment > (its value is correctly set in production environments). Putting it to a > few gigabytes here gives me this cost: > > bacula=# explain select pathid, filename from batch