Re: Max file size - Mailing list pgsql-admin

From Greg Spiegelberg
Subject Re: Max file size
Date
Msg-id 3F0179A8.2010208@cranel.com
Whole thread Raw
In response to Re: Max file size  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Max file size  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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@Cranel.com
Cranel. Technology. Integrity. Focus.



pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Max file size
Next
From: "scott.marlowe"
Date:
Subject: Re: Max file size