From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim Carroll <jim@carroll.com>
Cc: Jackson, DeJuan <djackson@cpsgroup.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Postgres Limitations
Date: Wed, 03 Feb 1999 11:42:01 -0500
Message-ID: <4818.918060121@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.BSD.3.91.990202214643.2669A-100000@apollo.carroll.com>
Jim Carroll <jim@carroll.com> writes:
>> It is currently unclear as to what will happen when you table reaches 2G
>> of storage on most file systems. I think that >2G table handling got
>> broken somehow.
> I know this is probably a "loaded" question, but do have any idea what
> might be the cause of this limitation ?
Postgres does have logic for coping with tables > 2Gb by splitting them
into multiple Unix files. Peter Mount recently reported that this
feature appears to be broken in the current sources (cf hackers mail
list archive for 25/Jan/99). I don't think anyone has followed up on
the issue yet. (I dunno about the other developers, but I don't have a
few Gb of free space to spare so I can't test it...) You could make a
useful contribution by either determining that the feature does work, or
fixing it if it's busted. Probably wouldn't be a very complex fix, but
I've never looked at that part of the code.
If your total database will exceed the space available on a single
filesystem on your platform, you will have to play some games with
symbolic links in order to spread the table files across multiple
filesystems. I don't know of any gotchas in doing that, but it's
kind of a pain for the DB admin to have to do it by hand.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, jim@carroll.com, djackson@cpsgroup.com
Subject: Re: [INTERFACES] Postgres Limitations
In-Reply-To: <4818.918060121@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox