Re: Can PostGreSQL handle 100 user database?

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