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: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
