Re: [HACKERS] Linux Largefile Support In Postgresql RPMS - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] Linux Largefile Support In Postgresql RPMS
Date
Msg-id 27296.1029258242@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Linux Largefile Support In Postgresql RPMS  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: [HACKERS] Linux Largefile Support In Postgresql RPMS  (Andrew Sullivan <andrew@libertyrms.info>)
Re: [HACKERS] Linux Largefile Support In Postgresql RPMS  (strange@nsk.yi.org)
Re: [HACKERS] Linux Largefile Support In Postgresql RPMS  (Greg Copeland <greg@CopelandConsulting.Net>)
List pgsql-general
Oliver Elphick <olly@lfix.co.uk> writes:
> But large file support is not really an issue for the database itself,
> since table files are split at 1Gb.  Unless that changes, the database
> is not a problem.

I see no really good reason to change the file-split logic.  The places
where the backend might possibly need large-file support are
    * backend-side COPY to or from a large file
    * postmaster log to stderr --- does this fail if log output
      exceeds 2G?
There might be some other similar issues, but that's all that comes to
mind offhand.

On a system where building with large-file support is reasonably
standard, I agree that PG should be built that way too.  Where it's
not so standard, I agree with Andrew Sullivan's concerns ...

            regards, tom lane

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Transaction Exception Question
Next
From: Andrew Sullivan
Date:
Subject: Re: [HACKERS] Linux Largefile Support In Postgresql RPMS