pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Entry point for Postgresql Performance
Date: Thu, 12 Mar 2009 23:11:02 +0530
Message-ID: <a97c77030903121041r57b7dd8ex77594e33fd9b1807@mail.gmail.com> (raw)
In-Reply-To: <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C29E@BTCMVEXC1-PRD.hq.netapp.com>
References: <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C29E@BTCMVEXC1-PRD.hq.netapp.com>

Databases are usually IO bound , vmstat results can confirm individual
cases and setups.
In case the server is IO bound the entry point should be setting up
properly performing
IO. RAID10 helps a great extent in improving IO bandwidth by
parallelizing the IO operations,
more spindles the better. Also write caches helps in great deal in
caching the writes and making
commits faster.

In my opinion system level tools (like vmstat) at peak load times  can
be an entry point
in understanding the  bottlenecks of a particular setup.

if there is swapping u absolutely need to double the ram . ( excess
ram can be used in disk block caching)
if its cpu bound add more cores or high speed cpus
if its io bound put better raid arrays & controller.


regds
mallah.

On Thu, Mar 12, 2009 at 4:22 PM, Nagalingam, Karthikeyan
<KARTHIKEYAN.Nagalingam@netapp.com> wrote:
> Hi,
>      Can you guide me, Where is the entry point to get the documentation for
> Postgresql performance tuning, Optimization for Postgresql with Storage
> controller.
>
> Your recommendation and suggestion are welcome.
>
> Regards
> Karthikeyan.N
>
>




view thread (3+ messages)

Message-ID: <a97c77030903121041r57b7dd8ex77594e33fd9b1807@mail.gmail.com>
Permalink:  ../a97c77030903121041r57b7dd8ex77594e33fd9b1807@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030903121041r57b7dd8ex77594e33fd9b1807@mail.gmail.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: mallah.rajesh@gmail.com, KARTHIKEYAN.Nagalingam@netapp.com
  Subject: Re: Entry point for Postgresql Performance
  In-Reply-To: <a97c77030903121041r57b7dd8ex77594e33fd9b1807@mail.gmail.com>
  References: <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C29E@BTCMVEXC1-PRD.hq.netapp.com> <a97c77030903121041r57b7dd8ex77594e33fd9b1807@mail.gmail.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