Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL clustering VS MySQL clustering

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-01-28 15:29:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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


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

In response to

pgsql-performance by date

Next:From: Andrew SullivanDate: 2005-01-28 15:31:38
Subject: Re: PostgreSQL clustering VS MySQL clustering
Previous:From: Pallav KalvaDate: 2005-01-28 15:15:50
Subject: Poor Performance on Postgres 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group