Re: [PERFORM] help with understanding EXPLAIN and boosting performance

2010-10-15 Thread Tom Lane
Brandon Casci writes: > I have an application hosted on Heroku. They use postgres. It's more or less > abstracted away, but I can get some performance data from New Relic. For the > most part, performance is ok, but now and then some queries take a few > seconds, and spike up to 15 or even 16 seco

[PERFORM] help with understanding EXPLAIN

2010-10-15 Thread Brandon Casci
Hello I have an application hosted on Heroku. They use postgres. It's more or less abstracted away, but I can get some performance data from New Relic. For the most part, performance is ok, but now and then some queries take a few seconds, and spike up to 15 or even 16 seconds! Ouch! This is the

[PERFORM] help with understanding EXPLAIN and boosting performance

2010-10-15 Thread Brandon Casci
Hello I have an application hosted on Heroku. They use postgres. It's more or less abstracted away, but I can get some performance data from New Relic. For the most part, performance is ok, but now and then some queries take a few seconds, and spike up to 15 or even 16 seconds! Ouch! This is the