From: | Greg Spiegelberg <gspiegelberg(at)cranel(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Max file size |
Date: | 2003-07-01 12:08:08 |
Message-ID: | 3F0179A8.2010208@cranel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
scott.marlowe wrote:
> On Tue, 1 Jul 2003, mauricio wrote:
>
>
>>Hi,
>>I'm evaluating some DB and one of the things i'd like to know is the
>>maximum size of a file that postgres can handle with. cause i'm planning
>>to have a centalized database the must have some billion records.
>
>
> In it's default configuration Postgresql autosplits table at approximately
> 1 gigabyte. Therefore, it has no built in limit to table size.
>
> If you have an OS that can handle larger files, you can compile postgresql
> to use larger file sizes. I have seen no great improvement in speed in
> using one large file for a table over splitting at 1Gig.
Hrm. This all ought to be dependent on record size and operating
system limits on the number of file descriptors, shouldn't it?
Greg
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg(at)Cranel(dot)com
Cranel. Technology. Integrity. Focus.
From | Date | Subject | |
---|---|---|---|
Next Message | mauricio | 2003-07-01 12:17:24 | Max file size |
Previous Message | Gémes Géza | 2003-07-01 11:23:07 | Re: postgreSQL users = LDAP users? |