pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Fri, 28 Jan 2005 14:04:24 -0800
Message-ID: <ctect8$et4$1@news.hub.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>

Hervé Piedvache wrote:
>>My point being is that there is no free solution.  There simply isn't.
>>I don't know why you insist on keeping all your data in RAM, but the
>>mysql cluster requires that ALL data MUST fit in RAM all the time.
> 
> 
> 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 ...

If it's an issue of RAM and not CPU power, think about this scenario. 
Let's just say you *COULD* partition your DB over multiple servers. What 
  are your plans then? Are you going to buy 4 Dual Xeon servers? Ok, 
let's price that out.

For a full-blown rackmount server w/ RAID, 6+ SCSI drives and so on, you 
are looking at roughly $4000 per machine. So now you have 4 machines -- 
total of 16GB of RAM over the 4 machines.

On the otherhand, let's say you spent that money on a Quad Opteron 
instead. 4x850 will cost you roughly $8000. 16GB of RAM using 1GB DIMMs 
is $3000. If you went with 2GB DIMMs, you could stuff 32GB of RAM onto 
that machine for $7500.

Let's review the math:

4X server cluster, total 16GB RAM = $16K
1 beefy server w/ 16GB RAM = $11K
1 beefy server w/ 32GB RAM = $16K

I know what I would choose. I'd get the mega server w/ a ton of RAM and 
skip all the trickyness of partitioning a DB over multiple servers. Yes 
your data will grow to a point where even the XXGB can't cache 
everything. On the otherhand, memory prices drop just as fast. By that 
time, you can ebay your original 16/32GB and get 64/128GB.



view thread (131+ messages)  latest in thread

Message-ID: <ctect8$et4$1@news.hub.org>
Permalink:  ../ctect8$et4$1@news.hub.org/
Also on:    postgresql.org/message-id/ctect8$et4$1@news.hub.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: wyu@talisys.com
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <ctect8$et4$1@news.hub.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