pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Amitabh Kant <amitabhkant@gmail.com>
To: Ivan Voras <ivoras@freebsd.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
Date: Thu, 4 Feb 2010 15:22:43 +0530
Message-ID: <84b68b3d1002040152r6066c57du34e0ce5af504c11e@mail.gmail.com> (raw)
In-Reply-To: <9bbcef731002040140s2dc07c07pc695b94f75382474@mail.gmail.com>
References: <84b68b3d1002030710x76c31adft58c56624409011fd@mail.gmail.com>
	<hkc8l8$ut3$1@ger.gmane.org>
	<84b68b3d1002040102o41b5c121k168accda7e31072b@mail.gmail.com>
	<9bbcef731002040140s2dc07c07pc695b94f75382474@mail.gmail.com>

On Thu, Feb 4, 2010 at 3:10 PM, Ivan Voras <ivoras@freebsd.org> wrote:

> On 4 February 2010 10:02, Amitabh Kant <amitabhkant@gmail.com> wrote:
> > On Wed, Feb 3, 2010 at 10:05 PM, Ivan Voras <ivoras@freebsd.org> wrote:
> >>
> >> On 02/03/10 16:10, Amitabh Kant wrote:
> >>>
> >>> Hello
> >>>
> >>> I have a server dedicated for Postgres with the following specs:
> >>>
> >>> RAM 16GB, 146GB SAS (15K) x 4 -  RAID 10 with BBU, Dual Xeon  E5345  @
> >>> 2.33GHz
> >>> OS: FreeBSD 8.0
> >>
> >> If you really do have "heavy read and write" load on the server, nothing
> >> will save you from the bottleneck of having only 4 drives in the system
> (or
> >> more accurately: adding more memory will help reads but nothing helps
> writes
> >> except more drivers or faster (SSD) drives). If you can, add another 2
> >> drives in RAID 1 and move+symlink the pg_xlog directory to the new
> array.
> >
> > Can't do anything about this server now, but would surely keep in mind
> > before upgrading other servers. Would you recommend the same speed
> > drives(15K SAS) for RAID 1, or would a slower drive also work here (10K
> SAS
> > or even SATA II)?
>
> Again, it depends on your load. It would probably be best if they are
> approximately the same speed; the location of pg_xlog will dictate
> your write (UPDATE / INSERT / CREATE) speed.
>
> Writes to your database go like this: the data is first written to the
> WAL (this is the pg_xlog directory - the transaction log), then it is
> read and written to the "main" database. If the main database is very
> busy reading, transfers from WAL to the database will be slower.
>

Thanks Ivan. I have to go in for upgrade of couple of more servers. I will
be going in for RAID 1 (OS + pg_xlog ) and RAID 10 (Pgsql data), all of them
of same speed.

With regards

Amitabh Kant

view thread (14+ messages)  latest in thread

Message-ID: <84b68b3d1002040152r6066c57du34e0ce5af504c11e@mail.gmail.com>
Permalink:  ../84b68b3d1002040152r6066c57du34e0ce5af504c11e@mail.gmail.com/
Also on:    postgresql.org/message-id/84b68b3d1002040152r6066c57du34e0ce5af504c11e@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: amitabhkant@gmail.com, ivoras@freebsd.org
  Subject: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
  In-Reply-To: <84b68b3d1002040152r6066c57du34e0ce5af504c11e@mail.gmail.com>
  References: <84b68b3d1002030710x76c31adft58c56624409011fd@mail.gmail.com> <hkc8l8$ut3$1@ger.gmane.org> <84b68b3d1002040102o41b5c121k168accda7e31072b@mail.gmail.com> <9bbcef731002040140s2dc07c07pc695b94f75382474@mail.gmail.com> <84b68b3d1002040152r6066c57du34e0ce5af504c11e@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