Thread: Query Time is Slow

Query Time is Slow

From

"Foster, Kristian B (HSC)"

Date:

09 February 2013, 01:14:24

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 environments.

The parameters we have modified on postgresql.confi are the following:

· shared_buffers = 24MB to 512 MB to 4GB

· work_mem = 1MB to 512MB to 1GB

· maintenance_work = 16MB to 1GB

· temp_buffers = 8MB to 1GB

· effective_cache_size = 128MB to 1024MB to 16GB

· autovacuum = on to off

Currently the queries are running about 4x slower on postgres than sql server. Is there any settings I need to check?

Thanks

Kristian

Re: Query Time is Slow

From

Kevin Grittner

Date:

09 February 2013, 01:46:05

"Foster, Kristian B (HSC)" <kristian-foster@ouhsc.edu> 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 is likely to yield good advice which will help all queries,
but if anything remains slow after the first one is sorted out,
pick another.

-Kevin