> > 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... Well, that's too much money. We'd like to stay away from these options. > > You're sure you can't possibly put up with even a small amount of > swapping? Nop. Too many users. Xmas shopping brought us down for a few minutes, and the rest of the time we were too slow. > > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
