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: (view raw, whole thread or download thread mbox)
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?



In response to


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-2017 The PostgreSQL Global Development Group