Re: Can PostGreSQL handle 100 user database?

From: "Mr(dot) Shannon Aldinger" <god(at)yinyang(dot)hjsoft(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can PostGreSQL handle 100 user database?
Date: 2000-11-30 18:59:22
Message-ID: Pine.LNX.4.30.0011301344290.22067-100000@yinyang.hjsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 30 Nov 2000, The Hermit Hacker wrote:

>
> Note that this is a Linux limitation ... and even then, I'm not quite sure
> how accurate that is anymore ... the *BSDs have supported >2gb file
> systems for ages now, and, since IBM supports Linux, I'd be shocked if
> there was a 2GB limit on memory, considering alot of IBMs servers support
> up to 4 or 8GB of RAM ...
>
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
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?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: Made with pgp4pine 1.75

iEYEARECAAYFAjomo5wACgkQwtU6L/A4vVD+bgCfZqBGG2C/FQceN4BkE9m474K1
mHcAoKEFHowB6iWhbOhPbOdDUxlN0eyA
=/AV7
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug Semig 2000-11-30 19:04:46 Re: Database cluster?
Previous Message Lamar Owen 2000-11-30 18:59:20 Re: Can PostGreSQL handle 100 user database?

Browse pgsql-sql by date

  From Date Subject
Next Message Marc SCHAEFER 2000-11-30 19:09:46 Re: Can PostGreSQL handle 100 user database?
Previous Message Lamar Owen 2000-11-30 18:59:20 Re: Can PostGreSQL handle 100 user database?