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