Skip site navigation (1) Skip section navigation (2)

Re: Fix for large file support

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Stefan KaltenbrunnerDate: 2007-04-06 14:33:20
Subject: Re: What X86/X64 OS's do we need coverage for?
Previous:From: Andrew DunstanDate: 2007-04-06 14:13:42
Subject: Re: What X86/X64 OS's do we need coverage for?

pgsql-patches by date

Next:From: Joshua D. DrakeDate: 2007-04-06 14:39:16
Subject: Re: Auto Partitioning
Previous:From: Simon RiggsDate: 2007-04-06 13:09:19
Subject: Re: Auto Partitioning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group