Actually PostgreSQL gets around the file size limits
on some systems by breaking tables into 1 Gig chunks.
Your colleague was right, but the guys on the
PostgreSQL development team worked around that
particular hurdle a long time ago.
Jason
--- Erich <hh@cyberpass.net> wrote:
> > Even on Linux? I'm studying a database project
> where the raw data is 10 to 20
> > Gb (it will be in several tables in the same
> database). Linux has a limit of 2
> > Gb for a file (even on 64-bits machine, if I'm
> correct). A colleague told me
>
> Quoi?
>
> On my RedHat6.2 system:
>
> /dev/md0 14111856 257828 13137168
> 2% /raid
>
> > to use NetBSD instead, because PostgreSQL on a
> Linux machine cannot host more
> > than 2 Gb per database. Any practical experience?
> (I'm not interested in "It
> > should work".)
>
> For a heavy-duty server, I would probably pick
> OpenBSD over Linux, but
> both will work fine, and both can have filesystems
> far larger than
> 2gb.
>
> e
__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail � Free email you can access from anywhere!
http://mail.yahoo.com/
