Re: Partitioning Vs. Split Databases - performance?

I haven't seen anyone using OpenSSI with PostgreSQL yet but as it does run
with MySQL and Oracle so it might be the case that it goes good with
PostgreSQL as well.

Just read the following -->
http://wiki.openssi.org/go/FAQ#Does_OpenSSI_support_the_PostgreSQL_database.3F

If anyone did try it PostgreSQL on OpenSSI that will be a good info to have.

-----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/24/06, Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> wrote:
>
> At 08:12 AM 12/22/2006, Joshua D. Drake wrote:
> >
> > > With One Big Database, you can get a SAN and attach a whole lot of
> > > disk space, but your mobo will only accept a certain number of DIMMs
> > > and processors of certain designs. And when your growing mega
> > > database maxes out your h/w, you're stuck.
> >
> >Define mega... Because you would need to be in the multi-terrabyte
> >range.
>
> Why multi terabyte? All that needs happen is for the hardware to run
> out of I/O. Nowadays with the sizes of disks, you can run out of I/O
> way before you run out of space.
>
> It could start to take way too long to backup/restore the entire database.
>
> If your app lends itself to horizontal scaling and you think you will
> need to scale to more than say 5X, its better to scale horizontally
> than go vertically (get a bigger box).
>
> Has clustering technology advanced to the point where making a
> "bigger box" can be done easily and cheaply with just many small
> boxes? I've seen stuff like OpenSSI etc, but how well does Postgresql
> run on such stuff? Shared memory is usually slow/problematic on such
> systems.
>
> Regards,
> Link.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>