Re: Can PostGreSQL handle 100 user database? - Mailing list pgsql-general

From Alex Pilosov
Subject Re: Can PostGreSQL handle 100 user database?
Date
Msg-id Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com
Whole thread Raw
In response to Re: Can PostGreSQL handle 100 user database?  ("Mr. Shannon Aldinger" <god@yinyang.hjsoft.com>)
List pgsql-general
On Thu, 30 Nov 2000, Mr. Shannon Aldinger wrote:

> Linux kernel 2.2.x unpatched has the 2GB file size and 1GB ram limit.
> Patched with the lfs package the 2GB file size limit goes away.
> The lfs patch needs applied against gnu-libc as well. This alone may not
> avoid the 2GB limit, the application must use the lseek64 instead of
> lseek, for example. lfs will be included by default in the upcoming 2.4.x
That's automatic, if you compile your source with -D_LARGE_FILES (or
something like that, don't remember exact names).

> kernels. The upcoming 2.4.x kernels also support more ram. I'm fairly
> certain ram patches exist for the 2.2.x series.
>
> I have just one question to ask will postgresql 7.1 include full support
> for using lseek64, stat64, etc?
Postgres doesn't need to. Just autoconf script needs to have an option
--with-large-files argument that would add -D_LARGE_FILES to CFLAGS.

-alex


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: strange query plans
Next
From: "Jonathan Ellis"
Date:
Subject: pltcl: missing close-brace