Re: [PERFORM] Query Time is Slow

2013-02-08 Thread Kevin Grittner
"Foster, Kristian B (HSC)" wrote: > Currently the queries are running about 4x slower on postgres than > sql server.  Is there any settings I need to check? Your best bet would be to pick one query and follow the steps recommended here: http://wiki.postgresql.org/wiki/SlowQueryQuestions That i

[PERFORM] Query Time is Slow

2013-02-08 Thread Foster, Kristian B (HSC)
Start off, I'm new to postgres. I'm running Ubuntu 10.04.04 with postgres 9.1 on a VM with 32 GB of RAM. I'm trying to increase the response time on submitted queries. I'm comparing the same queries to a SQL Server instance with the same data sets. The queries are used in our Analytics enviro