| From: | Joel Burton <jburton(at)scw(dot)org> |
|---|---|
| To: | Albert <mhjuang(at)gennet(dot)com(dot)tw> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: max. size for a table |
| Date: | 2001-04-23 05:00:30 |
| Message-ID: | Pine.LNX.4.21.0104230059290.15933-100000@olympus.scw.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 23 Apr 2001, Albert wrote:
> Hi all~~
>
> In the documentation of "Limitations of PostgreSQL", the maximum size for a
> table is 64TB on all operating system.
> I am using Linux(the limitation size of ext2 file is 2GB).
> Would anyone tell me if there is any solution to make a table large than 2GB
> in Linux using PostgreSQL.
> Thank you very much.
There are many patches for Linux kernels that remove the 2GB limit (or
alternate filesystems to ext2).
If you're not sure where to start, try a google search : '2GB limitation
remove', which returns a bunch of hits.
Good luck,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2001-04-23 05:02:09 | Re: install pgSQL 7.1 |
| Previous Message | Joel Burton | 2001-04-23 04:41:04 | 7.2 request: other quoting mechanism for PLs? |