From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: SAN/NAS options
Date: Fri, 16 Dec 2005 19:48:00 -0500
Message-ID: <20051217004800.GF2883@mathom.us> (raw)
In-Reply-To: <20051217002525.GC53809@pervasive.com>
References: <Pine.OSX.4.61.0512140155590.282@office-dhcp-18.bway.net>
<439FC9B8.8020709@paradise.net.nz>
<20051216221801.GT53809@pervasive.com>
<20051216225103.GE2883@mathom.us>
<20051217002525.GC53809@pervasive.com>
On Fri, Dec 16, 2005 at 06:25:25PM -0600, Jim C. Nasby wrote:
>True, but now you've got 4x the amount of data in your cache that you
>probably don't need.
Or you might be 4x more likely to have data cached that's needed later.
If you're hitting disk either way, that's probably more likely than the
extra IO pushing something critical out--if *all* the important stuff
were cached you wouldn't be doing the seeks in the first place. This
will obviously be heavily dependent on the amount of ram you've got and
your workload, so (as always) you'll have to benchmark it to get past
the hand-waving stage.
Mike Stone
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: mstone+postgres@mathom.us
Subject: Re: SAN/NAS options
In-Reply-To: <20051217004800.GF2883@mathom.us>
* 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