Zdenek Kotala wrote:
Current version of postgres support only 1GB chunks. This limit is
defined in the pg_config_manual.h header file. However this setting
allows to have maximal 2GB chunks. Main problem is that md storage
manager and buffile use "long" data type (32bits) for offset instead
"off_t" defined in <sys/types.h>.
off_t is 32bits long on 32bits OS and 64bits long on 64bits OS or when
application is compiled with large file support.
Attached patch allow to setup bigger chunks than 4GB on OS with large
file support.
I tested it on 7GB table and it works.
What does it actually buy us, though? Does it mean the maximum field
size will grow beyond 1Gb? Or give better performance?
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
