Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 204B064FD15 for ; Thu, 4 Sep 2008 16:39:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24317-10 for ; Thu, 4 Sep 2008 16:39:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id D178A64FCEF for ; Thu, 4 Sep 2008 16:39:14 -0300 (ADT) Received: (qmail invoked by alias); 04 Sep 2008 19:39:09 -0000 Received: from pD9E83BEA.dip.t-dialin.net (EHLO [192.168.2.50]) [217.232.59.234] by mail.gmx.net (mp011) with SMTP; 04 Sep 2008 21:39:09 +0200 X-Authenticated: #7655942 X-Provags-ID: V01U2FsdGVkX192PwBkoAJ2w7mkpxBRwE/rPTn+xIJ78im2pv5NCG Bh4ksSaCF+w5Dk Message-ID: <48C0395C.4000806@gmx.net> Date: Thu, 04 Sep 2008 21:39:08 +0200 From: Ulrich User-Agent: Thunderbird 2.0.0.16 (X11/20080724) MIME-Version: 1.0 To: Scott Marlowe CC: pgsql-performance@postgresql.org Subject: Re: More shared_buffers instead of effective_cache_size? References: <48C035E2.3070407@gmx.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.78 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/62 X-Sequence-Number: 31375 Scott Marlowe wrote: > Stop using a virtual server? That is not possible... > I wouldn't set shared_buffers that high > just because things like vacuum and sorts need memory too Okay, I understand that vacuum uses memory, but I thought sorts are done in work_mem? I am only sorting the result of one query which will never return more than 500 rows. -Ulrich