Answered Large files on now what's the limit

Chris Hughes

ProgressTalk.com Sponsor
Hi

Quick one, what is the file size limit with large files enabled?

I know its huge, but I had a customer ask and I'd like to be able to respond with a nice big (accurate) number.

Thanks

Chris
 

RealHeavyDude

Well-Known Member
The limit is defined by the file system or some ohter limit imposed by the operating system ( ulimit on some *nix systems ) on top of it. In theory any large file of the database could grow to the file system size.

Heavy Regards, RealHeavyDude.
 

TomBascom

Curmudgeon
The docs say that the maximum size of an extent is 1TB (an extent is one physical file).

The maximum for a type 2 storage area is (a collection of up to 1024 extents) is one petabyte.

You can have up to 31,994 application data storage areas (the first 6 are reserved for "system" use).
 

TomBascom

Curmudgeon
Those are the PROGRESS limits -- as RHD points out the filesystem or the OS may limit you to something smaller.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
Chapter 2 of the DB Admin manual has lots of information about architectural limits. You will probably reach practical limits first.

Extent size limits are also influenced by Progress version, recid size (32 or 64), and storage area type. I assume you are using a recent version of Progress with the Enterprise RDBMS license, 64-bit recids, and Type II storage areas.
 
Top