Re: Splitting queries across servers

>
> 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(at)fjrhome(dot)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
>
>
> ---------------------------(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
>