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
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