From: Andrew Dunstan <andrew@dunslane.net>
To: Syed Asif Tanveer <asif.tanveer@analytics.com.pk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres configuration for 8 CPUs, 6 GB RAM
Date: Tue, 27 Nov 2012 08:56:12 -0500
Message-ID: <50B4C67C.1040802@dunslane.net> (raw)
In-Reply-To: <000601cdcc73$69f82d70$3de88850$@analytics.com.pk>
References: <000601cdcc73$69f82d70$3de88850$@analytics.com.pk>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 11/27/2012 02:47 AM, Syed Asif Tanveer wrote:
>
> Hi,
>
> I am using PostgreSQL 9.1.5 for Data warehousing and OLAP puposes.
> Data size is around 100 GB and I have tuned my PostgreSQL accordingly
> still I am facing performance issues. The query performance is too low
> despite tables being properly indexed and are vacuumed and analyzed at
> regular basis. CPU usage never exceeded 15% even at peak usage times.
> Kindly guide me through if there are any mistakes in setting
> configuration parameters. Below are my system specs and please find
> attached my postgresql configuration parameters for current system.
>
>
There is at least anecdotal evidence that Windows servers degrade when
shared_buffers is set above 512Mb. Personally, I would not recommend
using Windows for a high performance server.
Also, it makes no sense to have a lower setting for maintenance_work_mem
than for work_mem. You would normally expect maintenance_work_mem to be
higher - sometimes much higher.
Apart from that, it's going to be impossible to tell what your problem
is without seeing actual slow running queries and their corresponding
explain analyse output.
cheers
andrew
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: andrew@dunslane.net, asif.tanveer@analytics.com.pk
Subject: Re: Postgres configuration for 8 CPUs, 6 GB RAM
In-Reply-To: <50B4C67C.1040802@dunslane.net>
* 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