X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B2034D1B4EF for ; Fri, 3 Oct 2003 14:31:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 59709-08 for ; Fri, 3 Oct 2003 11:31:01 -0300 (ADT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 173FCD1B502 for ; Fri, 3 Oct 2003 11:30:53 -0300 (ADT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 7E91E2BDEC for ; Fri, 3 Oct 2003 16:30:44 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id D797BDA8AB for ; Fri, 3 Oct 2003 16:30:44 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 63487973EA for ; Fri, 3 Oct 2003 16:30:44 +0200 (SAST) Date: Fri, 3 Oct 2003 16:30:40 +0200 From: Stef To: pgsql-performance@postgresql.org Subject: Postgres low end processing. Message-Id: <20031003163040.3641f39a.svb@ucs.co.za> X-Mailer: Sylpheed version 0.9.5claws28 (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: LV^-*d3kQlL,6{Y:X)M~tuL#y!p.kO_Qbc!xxqhZC4s}Y]L0g)z^aiLsQGY34d|}Xp:HNm)MRsc?^?ZQ}smznF&jx|w@,a**K&QL.Dc~2~M5V`zb>hExCJDB[[o=M)e"; k-n[7tz2TY7+; *_xX's(5cUEtdw*yG-OmKm}6($zpUz8S`Nz@w X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Fri__3_Oct_2003_16_30_41_+0200_m8AE1l+9oErPqzEx" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/85 X-Sequence-Number: 3833 --Signature=_Fri__3_Oct_2003_16_30_41_+0200_m8AE1l+9oErPqzEx Content-Type: multipart/mixed; boundary="Multipart=_Fri__3_Oct_2003_16_30_40_+0200_yL2q87cXztrCXW/D" --Multipart=_Fri__3_Oct_2003_16_30_40_+0200_yL2q87cXztrCXW/D Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Hi everyone, I've been trying to find out if some guidelines exist, somewhere, describing how postgres can possibly run on less than 8MB of RAM. (Disk space not an issue). The closest thread I could find in the list archives is : http://archives.postgresql.org/pgsql-general/2002-06/msg01343.php Is it possible to have a stripped-down version of postgres that will use an absolute minimal amount of memory? Maybe by switching off some features/options at compile time, and/or configuration tweaks? (Or anything else) This will be on very low end i386 architecture. Performance penalties are expected and will be accepted. I will need the functionality of >= 7.3.4 , at least. Any help will be much appreciated. Regards Stef --Multipart=_Fri__3_Oct_2003_16_30_40_+0200_yL2q87cXztrCXW/D Content-Type: application/pgp-signature; name="00000009.mimetmp" Content-Disposition: attachment; filename="00000009.mimetmp" Content-Transfer-Encoding: base64 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcg djEuMi4zIChHTlUvTGludXgpCgppRDhEQlFFL2ZZR1pnRFlzM1VrUmpaa1JB cnB5QUo5M2FaM3RNd1RTWlpnNUVlY0lkL29XUk9ZZnhRQ2ZhblNVCi80V0Y4 VVpTVnhxSS9BUW9rZ0hFUXFRPQo9WlFSaAotLS0tLUVORCBQR1AgU0lHTkFU VVJFLS0tLS0KCg== --Multipart=_Fri__3_Oct_2003_16_30_40_+0200_yL2q87cXztrCXW/D-- --Signature=_Fri__3_Oct_2003_16_30_41_+0200_m8AE1l+9oErPqzEx Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/fYgUgDYs3UkRjZkRAhdQAJ0a7V0JSug//08ktSGUwuBtBVpnZwCdHD/V pZ8v+JaRuNWhDlUBzpf6Gb0= =g+xq -----END PGP SIGNATURE----- --Signature=_Fri__3_Oct_2003_16_30_41_+0200_m8AE1l+9oErPqzEx--