Query Time is Slow - Mailing list pgsql-performance

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