-----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@xxxxxxxxxxx>
$ 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
---------------------------(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
