pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Scott Marlowe <scott.marlowe@gmail.com>
To: Thomas Spreng <spreng@socket.ch>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Oddly slow queries
Date: Tue, 22 Apr 2008 09:25:42 -0600
Message-ID: <dcc563d10804220825j592cb3fdtf0d977dcf4e51312@mail.gmail.com> (raw)
In-Reply-To: <7A2BA520-ED19-418F-9339-95C7F7158664@socket.ch>
References: <3D7728ED-3D36-47E6-9266-351073ED4E11@socket.ch>
	<op.t9odybcgcigqcu@apollo13.peufeu.com>
	<AE4F81FF-C8BE-44BC-A79D-48EC5BF20162@socket.ch>
	<60y77du7qs.fsf@dba2.int.libertyrms.com>
	<20B852C4-2ACA-445F-9289-558B6C86BAB4@socket.ch>
	<87mynp3h3q.fsf@wolfe.cbbrowne.com>
	<7A2BA520-ED19-418F-9339-95C7F7158664@socket.ch>

On Tue, Apr 22, 2008 at 7:42 AM, Thomas Spreng <spreng@socket.ch> wrote:
>
>  I think I'll upgrade PostgreSQL to the latest 8.3 version in the next
>  few days anyway, along with a memory upgrade (from 1.5GB to 4GB) and a
>  new 2x RAID-1 (instead of RAID-5) disk configuration. I hope that this
>  has already a noticeable impact on the performance.

Note that if you have a good RAID controller with battery backed cache
and write back enabled, then you're probably better or / at least as
well off using four disks in a RAID-10 than two separate RAID-1 sets
(one for xlog and one for data).

Test to see.  I've had better performance in general with the RAID-10 setup.

view thread (14+ messages)  latest in thread

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

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, spreng@socket.ch, cbbrowne@acm.org
  Subject: Re: Oddly slow queries
  In-Reply-To: <dcc563d10804220825j592cb3fdtf0d977dcf4e51312@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