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

Reply via email to