Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 2FA051337BE1
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  3 May 2011 12:53:47 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 55189-02-8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  3 May 2011 15:53:29 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com
	[209.85.212.46])
	by mail.postgresql.org (Postfix) with ESMTP id 6EE8E1337C30
	for <pgsql-performance@postgresql.org>;
	Tue,  3 May 2011 12:52:24 -0300 (ADT)
Received: by vws1 with SMTP id 1so170348vws.19
	for <pgsql-performance@postgresql.org>;
	Tue, 03 May 2011 08:52:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:date:message-id:subject:from:to
	:content-type; bh=14pc4qTjvp5gIVLvZbj2kdZ+tQUJcHkemsPQPK35aZU=;
	b=tq/carG679GmX9ePhdBDs6MRicqc5FSQKd40BQr1o9Iq7R9G8+bt5rh9vD2HXMuN/W
	xYA0sQG7o3hjpb6eUEW1V8YexE2onRtESWeT6uXLJnfPSC++u0Y2sKXd3oseGL/OI0U+
	PJinH6olcwZYZ+IDYA6vkLLUb6Y8bVcSRkj3g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=NnYBncjOaxjbaxQci7JNgmHGM8XgnGyzgpS+Y1lYFhhTSoGHLTMe4xvysqMnRAQKbA
	ClwQ3hKYJwwRR3fHdpkf8ZRUsPuNmHWkd4l0aGU52asBocn7elNzTYNFK/WjQUJ+M02K
	2T+SU81i86MupDE/YLa6vjMBHTebDs4dM+Njs=
MIME-Version: 1.0
Received: by 10.52.176.1 with SMTP id ce1mr9814vdc.63.1304437943597; Tue, 03
	May 2011 08:52:23 -0700 (PDT)
Received: by 10.52.182.4 with HTTP; Tue, 3 May 2011 08:52:23 -0700 (PDT)
Date: Tue, 3 May 2011 17:52:23 +0200
Message-ID: <BANLkTimDjFDy8Q8vfDVZ4LBKXb1EjVsh4w@mail.gmail.com>
Subject: [PERFORMANCE] expanding to SAN: which portion best to move
From: Willy-Bas Loos <willybas@gmail.com>
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=bcaec517a812427bd004a26120b2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.887 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201105/27
X-Sequence-Number: 43536

--bcaec517a812427bd004a26120b2
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Our database has gotten rather large and we are running out of disk space.
our disks are 15K rpm SAS disks in RAID 10.

We are going to rent some space on a FibreChannel SAN.
That gives us the opportunity to separate the data and the indexes.
Now i thought it would be best to move the indexes to the SAN and leave the
data on the disks, since the disks are better at sequential I/O and the SAN
will have lots of random I/O since there are lots of users on it.

Is that a wise thing to do?

Cheers,

WBL

-- 
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw

--bcaec517a812427bd004a26120b2
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<div><br></div><div>Our database has gotten rather large and we are runn=
ing out of disk space.</div><div>our disks are 15K rpm SAS disks in RAID 10=
.</div><div><br></div><div>We are going to rent some space on a FibreChanne=
l SAN.</div>
<div>That gives us the opportunity to separate the data and the indexes.</d=
iv><div>Now i thought it would be best to move the indexes to the SAN and l=
eave the data on the disks, since the disks are better at sequential I/O an=
d the SAN will have lots of random I/O since there are lots of users on it.=
</div>
<div><br></div><div>Is that a wise thing to do?</div><div><br></div><div>Ch=
eers,</div><div><br></div><div>WBL<br clear=3D"all"><br>-- <br>&quot;Patrio=
tism is the conviction that your country is superior to all others because =
you were born in it.&quot; -- George Bernard Shaw<br>

</div>

--bcaec517a812427bd004a26120b2--