pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Fri, 28 Jan 2005 10:29:58 -0500
Message-ID: <20050128152958.GA9076@phlogiston.dyndns.org> (raw)
In-Reply-To: <200501201602.39568.herve@elma.fr>
References: <200501201503.31241.herve@elma.fr>
	<200501201542.06645.herve@elma.fr>
	<41EFC569.6030800@familyhealth.com.au>
	<200501201602.39568.herve@elma.fr>

On Thu, Jan 20, 2005 at 04:02:39PM +0100, Hervé Piedvache wrote:
> 
> I don't insist about have data in RAM .... but when you use PostgreSQL with 
> big database you know that for quick access just for reading the index file 
> for example it's better to have many RAM as possible ... I just want to be 
> able to get a quick access with a growing and growind database ...

Well, in any case, you need much better hardware than you're looking
at.  I mean, dual Xeon with 2 Gig isn't hardly big iron.  Why don't
you try benchmarking on a honking big box -- IBM P690 or a big Sun
(I'd counsel against that, though) or something like that?  Or even
some Opterons.  Dual Xeon is probablt your very worst choice at the
moment.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.
		--Bruce Schneier



view thread (131+ messages)  latest in thread

Message-ID: <20050128152958.GA9076@phlogiston.dyndns.org>
Permalink:  ../20050128152958.GA9076@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20050128152958.GA9076@phlogiston.dyndns.org

 · 

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: ajs@crankycanuck.ca
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <20050128152958.GA9076@phlogiston.dyndns.org>

* 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