From: Craig James <craig_james@emolecules.com>
To: Massan <grant.massan@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problem with database performance, Debian 4gb ram ?
Date: Fri, 06 Nov 2009 06:37:38 -0800
Message-ID: <4AF434B2.7040207@emolecules.com> (raw)
In-Reply-To: <26157096.post@talk.nabble.com>
References: <26157096.post@talk.nabble.com>
Massan wrote:
> Hi all,
>
> I have now readed many many forums and tried many different solutions and I
> am not getting good performance to database.
You don't give nearly enough information. To begin with, why do you think performance is poor? What exactly are you measuring? What does your application do, at least in broad terms? Have you identified any particular SQL queries that are slow, and if so, have you run EXPLAIN ANALYZE on them? What is the output of EXPlAIN ANALYZE?
What about your hardware, do you have a single disk, a huge RAID10 array, or something in between? How much memory, how many processors?
The more information you provide, the more likely you will get a good answer.
Craig
> My server is Debian linux, with
> 4gb ram, there is also java application and I am giving to that 512mb
> (JAVA_OPTS) memory. In database there is now like 4milj rows. What should I
> do better.
> Now .conf is:
>
> max_connections = 80
> shared_buffers = 512MB
> temp_buffers = 8MB
> work_mem = 20MB
> maintenance_work_mem = 384MB
> wal_buffers = 8MB
> checkpoint_segments = 128MB
> effective_cache_size = 2304MB
> cpu_tuple_cost = 0.0030
> cpu_index_tuple_cost = 0.0010
> cpu_operator_cost = 0.0005
> fsync = off
> checkpoint_timeout = 1h
>
> and I am giving kernels like:
>
> sysctl -w kernel.shmmax=1073741824
> sysctl -w kernel.shmall=2097152
>
> btw, what file I should modify to give this kernels as defaults ?
>
> Thank you very much ! Hope you can clear my problem !
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig_james@emolecules.com, grant.massan@gmail.com
Subject: Re: Problem with database performance, Debian 4gb ram ?
In-Reply-To: <4AF434B2.7040207@emolecules.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox