Ограничения ОС Astra Linux
ФС:
ext4 Максимальный размер файла: 16 Терабайт
Postgres:
https://wiki.postgresql.org/wiki/FAQ
What is the maximum size for a row, a table, and a database?
These are the limits:
Maximum size for a database? unlimited (32 TB databases exist)
Maximum size for a table? 32 TB
Maximum size for a row? 400 GB
Maximum size for a field? 1 GB
Maximum number of rows in a table? unlimited
Maximum number of columns in a table? 250-1600 depending on column types
Maximum number of indexes on a table? unlimited
Of course, these are not actually unlimited, but limited to available disk space and memory/swap space.
Performance may suffer when these values get unusually large.
The maximum table size of 32 TB does not require large file support from the operating system.
Large tables are stored as multiple 1 GB files so file system size limits are not important.
The maximum table size, row size, and maximum number of columns can be quadrupled by increasing
the default block size to 32k. The maximum table size can also be increased using table partitioning.
One limitation is that indexes can not be created on columns longer than about 2,000 characters.
Fortunately, such indexes are rarely needed. Uniqueness is best guaranteed by a function index
of an MD5 hash of the long column, and full text indexing allows for searching of words within the column.
Note if you are storing a table with rows that exceed 2KB in size (aggregate size of data in each row)
then the "Maximum number of rows in a table" may be limited to 4 Billion or less, see TOAST.
ФС:
ext4 Максимальный размер файла: 16 Терабайт
Postgres:
https://wiki.postgresql.org/wiki/FAQ
What is the maximum size for a row, a table, and a database?
These are the limits:
Maximum size for a database? unlimited (32 TB databases exist)
Maximum size for a table? 32 TB
Maximum size for a row? 400 GB
Maximum size for a field? 1 GB
Maximum number of rows in a table? unlimited
Maximum number of columns in a table? 250-1600 depending on column types
Maximum number of indexes on a table? unlimited
Of course, these are not actually unlimited, but limited to available disk space and memory/swap space.
Performance may suffer when these values get unusually large.
The maximum table size of 32 TB does not require large file support from the operating system.
Large tables are stored as multiple 1 GB files so file system size limits are not important.
The maximum table size, row size, and maximum number of columns can be quadrupled by increasing
the default block size to 32k. The maximum table size can also be increased using table partitioning.
One limitation is that indexes can not be created on columns longer than about 2,000 characters.
Fortunately, such indexes are rarely needed. Uniqueness is best guaranteed by a function index
of an MD5 hash of the long column, and full text indexing allows for searching of words within the column.
Note if you are storing a table with rows that exceed 2KB in size (aggregate size of data in each row)
then the "Maximum number of rows in a table" may be limited to 4 Billion or less, see TOAST.