Re: [GENERAL] inputs into query planner costing

2015-03-31 Thread Mike Roest
Thanks for the responses For anyone searching in the future I'll answer Tom's questions and list the boneheaded fix that it ended up actually being (really painful as I've been fighting this for a week). 1) According to amazon they run stock postgres as far as the query planner is concerned. 2) Y

Re: [GENERAL] inputs into query planner costing

2015-03-31 Thread Tom Lane
Mike Roest writes: >I'm having an issue with query performance between 2 different pgsql > environments. > Ther first is our current production postgres server with is running 9.3.5 > on Centos 5 x64. The second system is Amazon's RDS postgres as a service. > On our local DB server we have a

Re: [GENERAL] inputs into query planner costing

2015-03-31 Thread Andy Colson
On 3/31/2015 10:31 AM, Mike Roest wrote: Hi there, I'm having an issue with query performance between 2 different pgsql environments. Ther first is our current production postgres server with is running 9.3.5 on Centos 5 x64. The second system is Amazon's RDS postgres as a service. On our

[GENERAL] inputs into query planner costing

2015-03-31 Thread Mike Roest
Hi there, I'm having an issue with query performance between 2 different pgsql environments. Ther first is our current production postgres server with is running 9.3.5 on Centos 5 x64. The second system is Amazon's RDS postgres as a service. On our local DB server we have a query that executes