Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E32E09FB386 for ; Wed, 4 Oct 2006 06:11:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 99589-07 for ; Wed, 4 Oct 2006 09:11:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from webmail.enterprisedb.com (edb04.managed.contegix.com [63.246.7.176]) by postgresql.org (Postfix) with ESMTP id 712CB9FA4F4 for ; Wed, 4 Oct 2006 06:11:35 -0300 (ADT) Received: from [192.168.0.20] (unknown [62.232.55.86]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by webmail.enterprisedb.com (Postfix) with ESMTP id AC7C1A24701; Wed, 4 Oct 2006 04:11:33 -0500 (CDT) Message-ID: <45237AD0.50604@enterprisedb.com> Date: Wed, 04 Oct 2006 10:11:44 +0100 From: Heikki Linnakangas User-Agent: Thunderbird 1.5.0.7 (X11/20060915) MIME-Version: 1.0 To: simon godden CC: pgsql-performance@postgresql.org Subject: Re: simple case using index on windows but not on linux References: <168519350610040048m7c4031e3t1a24b3fd4d9265a3@mail.gmail.com> In-Reply-To: <168519350610040048m7c4031e3t1a24b3fd4d9265a3@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/74 X-Sequence-Number: 21203 simon godden wrote: > The only major difference between the hardware is that the windows > machine has 2gb RAM and a setting of 10000 shared memory pages, > whereas the linux machine has 756Mb RAM and a setting of 3000 shared > memory pages (max. shared memory allocation of 32Mb). I can't see any > other differences in configuration. You can increase the max shared memory size if you have root access. See http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html#SYSVIPC-PARAMETERS Scroll down for Linux-specific instructions. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com