| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Fix for large file support |
| Date: | 2007-04-06 14:21:05 |
| Message-ID: | 46165751.2090009@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2007-04-06 14:33:20 | Re: What X86/X64 OS's do we need coverage for? |
| Previous Message | Andrew Dunstan | 2007-04-06 14:13:42 | Re: What X86/X64 OS's do we need coverage for? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-04-06 14:39:16 | Re: Auto Partitioning |
| Previous Message | Simon Riggs | 2007-04-06 13:09:19 | Re: Auto Partitioning |