Re: Splitting queries across servers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Wow.  Your needs really *are* demanding.  You might need to look into a
high-end server to meet those kinds of needs - Sun has some *very*
expensive hardware that can handle over 1/2TB of RAM, for example, and
Cray makes supercomputers (even more *very* expensive) which can handle
somewhere around 32 TB of RAM...

You're sure you can't possibly put up with even a small amount of
swapping?


On Jan 26, 2005, at 11:00 AM, Max wrote:

> Hello,
>
> Our postgresql database is getting too big to be handled by one
> server. We
> need the database to be in RAM and cannot afford swapping. At the
> moment,
> we're using only 3GB or RAM, however our business growth is going to
> drive
> this number into the double digits zone, maybe triple digits.
>
> What are our options ?
>
> I am a little bit ignorant in this part of RDBM. Can we distribute our
> tables across multiple servers (read server+postgres) and perform
> distributed SQL queries ? If so, how does that work ? I am totally
> resourceless!
>
> Thank you in advance
>
> Max.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
>       joining column's datatypes do not match
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB98Wx7aqtWrR9cZoRAtYNAJ0SHP+Y65TasCxvUxd9RjTXSJqyOgCdEi6X
VfX0V8TKg4JEPPy6eJyYPVM=
=zAYr
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com