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 |
