Re: pg_largeobject - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: pg_largeobject
Date
Msg-id 20160330104554.GA9754@tux
Whole thread Raw
In response to Re: pg_largeobject  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-general
Sridhar N Bamandlapally <sridhar.bn1@gmail.com> wrote:

> Is there any way we can change the segment file size, 
>
> I am trying to look into the possibility of segment file size Vs bytea size
> limitation
>
> PostgreSQL installation
>
> step 1:  ./configure --enable-largefile --with-segsize ( throwing error
> "configure: error: Large file support is not enabled. Segment size cannot be
> larger than 1GB" )

check if your filesystem supports large files:

getconf FILESIZEBITS /some/path

If the result is 64, LFS is supported.


Regards, Andreas Kretschmer
--
Andreas Kretschmer
http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Sridhar N Bamandlapally
Date:
Subject: Re: pg_largeobject
Next
From: Merlin Moncure
Date:
Subject: Re: Missed LIMIT clause pushdown in FDW API