From: | Jason Earl <jdearl(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: [HACKERS] 8Ko limitation |
Date: | 2000-07-20 21:19:56 |
Message-ID: | 20000720211956.18528.qmail@web112.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)cyberpass(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Howe | 2000-07-21 00:35:41 | strange JDBC error |
Previous Message | Dale Anderson | 2000-07-20 21:19:25 | Re: Re: [HACKERS] 8Ko limitation |