Skip site navigation (1) Skip section navigation (2)

Performance

From: Ogden <lists(at)darkstatic(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Performance
Date: 2011-04-12 16:36:19
Message-ID: DF2D5436-117C-4D02-9B3C-A55723B7DDE1@darkstatic.com (view raw or flat)
Thread:
Lists: pgsql-performance
I have been wrestling with the configuration of the dedicated Postges 9.0.3 server at work and granted, there's more activity on the production server, but the same queries take twice as long on the beefier server than my mac at home. I have pasted what I have changed in postgresql.conf - I am wondering if there's any way one can help me change things around to be more efficient.

Dedicated PostgreSQL 9.0.3 Server with 16GB Ram

Heavy write and read (for reporting and calculations) server. 

max_connections = 350 
shared_buffers = 4096MB  
work_mem = 32MB
maintenance_work_mem = 512MB


seq_page_cost = 0.02                    # measured on an arbitrary scale
random_page_cost = 0.03 
cpu_tuple_cost = 0.02  
effective_cache_size = 8192MB



The planner costs seem a bit low but this was from suggestions from this very list a while ago. 


Thank you

Ogden

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2011-04-12 16:40:27
Subject: Re: Linux: more cores = less concurrency.
Previous:From: Merlin MoncureDate: 2011-04-12 16:12:37
Subject: Re: Linux: more cores = less concurrency.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group