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