Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 402E69FA162 for ; Mon, 11 Dec 2006 07:08:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 95804-06 for ; Mon, 11 Dec 2006 07:08:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 63EBB9F9F75 for ; Mon, 11 Dec 2006 07:08:34 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so742044nzh for ; Mon, 11 Dec 2006 03:08:33 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nTVTHjIwuqqHW+jjfdnD2/uI339LSKyjF34QhNpmF5tCs1pbodoebttUob9lLnpSuZ+W2EHAWITxpOJ1m2hD43N57PtixZCrbFjB2fXbPoz/OXRAYcsTtjVZE5CmPLeK7iRlqaZeuXMkSUvTRZW6syJkJJJh+XaVbfp/gqiY0A4= Received: by 10.65.251.2 with SMTP id d2mr10682096qbs.1165835313104; Mon, 11 Dec 2006 03:08:33 -0800 (PST) Received: by 10.65.215.20 with HTTP; Mon, 11 Dec 2006 03:08:31 -0800 (PST) Message-ID: <8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com> Date: Mon, 11 Dec 2006 09:08:31 -0200 From: "Daniel van Ham Colchete" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations In-Reply-To: <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8a0c7af10612101141n2c7727c3r2f92345753960808@mail.gmail.com> <430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com> <8a0c7af10612101702i49b5a533v4a2300d90d9dae6b@mail.gmail.com> <96AA0685-0BCC-4300-BB12-696FE495B008@fastcrypt.com> <8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com> <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/218 X-Sequence-Number: 22274 > >> > >> How much memory does this machine have and what version of postgresql > >> are you using? > > It's only a test server with 512MB RAM, I only used it to see how well > > would the PostgreSQL do in a ugly case. > > Given that optimal performance for postgresql can require up to 50% > of available memory, you are going to leave the OS with 256MB of > memory ? If it were the case I wouldn't have any problems letting the OS use only 256MB, but this is not my production server. My production is built yet. It'll have at least 2GB of memory. But it's good to know anyway.