pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Pilosov <alex@pilosoft.com>
To: Mr. Shannon Aldinger <god@yinyang.hjsoft.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Can PostGreSQL handle 100 user database?
Date: Thu, 30 Nov 2000 19:12:35 -0500 (EST)
Message-ID: <Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com> (raw)
In-Reply-To: <Pine.LNX.4.30.0011301344290.22067-100000@yinyang.hjsoft.com>

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




view thread (16+ messages)

Message-ID: <Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com>
Permalink:  ../Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com/
Also on:    postgresql.org/message-id/Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: alex@pilosoft.com, god@yinyang.hjsoft.com, pgsql-general@postgresql.org
  Subject: Re: Can PostGreSQL handle 100 user database?
  In-Reply-To: <Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com>
  References: <Pine.LNX.4.30.0011301344290.22067-100000@yinyang.hjsoft.com> <Pine.BSO.4.10.10011301910540.28752-100000@spider.pilosoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox