Re: [GENERAL] Inconsistent query performance

2013-04-09 Thread Ramsey Gurley
On Apr 8, 2013, at 8:46 PM, Jeff Janes wrote: > On Monday, April 8, 2013, Ramsey Gurley wrote: > Hi all, > > I'm having issues with slow queries using postgres, and I'm finding some of > the issues difficult to reproduce. My application logs slow queries for me, > but often, when I go back to

Re: [GENERAL] Inconsistent query performance

2013-04-09 Thread Ramsey Gurley
On Apr 8, 2013, at 7:09 PM, Kevin Grittner wrote: > Ramsey Gurley wrote: > >> I'm having issues with slow queries using postgres, and I'm >> finding some of the issues difficult to reproduce. My application >> logs slow queries for me, but often, when I go back to run explain >> analyze on the

Re: [GENERAL] Inconsistent query performance

2013-04-08 Thread Jeff Janes
On Monday, April 8, 2013, Ramsey Gurley wrote: > Hi all, > > I'm having issues with slow queries using postgres, and I'm finding some > of the issues difficult to reproduce. My application logs slow queries for > me, but often, when I go back to run explain analyze on the query it is > very fast.

Re: [GENERAL] Inconsistent query performance

2013-04-08 Thread Kevin Grittner
Ramsey Gurley wrote: > I'm having issues with slow queries using postgres, and I'm > finding some of the issues difficult to reproduce. My application > logs slow queries for me, but often, when I go back to run explain > analyze on the query it is very fast. I assume this is due to some > sort o

Re: [GENERAL] Inconsistent query performance

2013-04-08 Thread Ramsey Gurley
I forgot to mention. I'm currently using postgres 8.3.x On Apr 8, 2013, at 3:08 PM, Ramsey Gurley wrote: > Hi all, > > I'm having issues with slow queries using postgres, and I'm finding some of > the issues difficult to reproduce. My application logs slow queries for me, > but often, when I g