patternsqlModerate
Manually increase PostgreSQL's table size limit of 32 TB?
Viewed 0 times
postgresqlsizelimitmanuallyincreasetable
Problem
I need a free database software and thought of PostgreSQL. But then I read it has a table size limit of 32 terabytes, but I need more (and don't want to spend thousand/millions on high end database software like Oracle).
Is there a way to manually increase that limit? And if so, what is the penalty for doing so?
Is there a way to manually increase that limit? And if so, what is the penalty for doing so?
Solution
Just use a different setting for the block size:
--with-blocksize=BLOCKSIZE
The default, 8 kilobytes, is suitable for most situations; but other
values may be useful in special cases. The value must be a power of 2
between 1 and 32 (kilobytes).
Using 32 kilobytes, your table has a maximum size of 128TB.
--with-blocksize=BLOCKSIZE
The default, 8 kilobytes, is suitable for most situations; but other
values may be useful in special cases. The value must be a power of 2
between 1 and 32 (kilobytes).
Using 32 kilobytes, your table has a maximum size of 128TB.
Context
StackExchange Database Administrators Q#28556, answer score: 14
Revisions (0)
No revisions yet.