Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-sql by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group