On Tue, 1 Jul 2003, Greg Spiegelberg wrote: > 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?
not sure what you mean. The number of file descriptors isn't usually a big issue unless you've got a default installation of an older OS, the number of file descriptors won't likely be an issue unless you need to startup a lot of backends. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])