Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bltt4-0001mE-O1 for pgsql-performance@arkaria.postgresql.org; Mon, 19 Sep 2016 08:25:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bltt4-0000k9-6S for pgsql-performance@arkaria.postgresql.org; Mon, 19 Sep 2016 08:25:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bltrP-0007I5-Na for pgsql-performance@postgresql.org; Mon, 19 Sep 2016 08:23:31 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bltrL-0007vI-5Q for pgsql-performance@postgresql.org; Mon, 19 Sep 2016 08:23:30 +0000 Received: from localhost (localhost [127.0.0.1]) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTP id A415E80822; Mon, 19 Sep 2016 20:23:19 +1200 (NZST) X-Virus-Scanned: Debian amavisd-new at cat-porwal-prod-mail1.servers.catalyst.net.nz Received: from cat-porwal-prod-mail1.catalyst.net.nz ([127.0.0.1]) by localhost (cat-porwal-prod-mail1.servers.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id cMii0vDwHQ44; Mon, 19 Sep 2016 20:23:19 +1200 (NZST) Received: from [192.168.1.64] (222-153-76-81.jetstream.xtra.co.nz [222.153.76.81]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 3C41980814; Mon, 19 Sep 2016 20:23:19 +1200 (NZST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=catalyst.net.nz; s=catalyst; t=1474273399; bh=G0uTmmZDRkB192g09c/ogY3cd+yYPL2supFcuX4RAmI=; h=Subject:To:References:From:Date:In-Reply-To; b=OSsDLZSZ+td9VJTy2eIm1h8gNt6mf91SZ+OKDoQEYHdM7C8f8oUaIrAs3jDOvpfQj uIu69aHiKfNqLMLmvZNeDr1yQYk2XbThQ4R/DeOc6a6E9aD+EJezluvIuNM/eoXrzQ fskPXF2NmB7mKomaTQ77pVRXGkmkQnQlWgJv/PEY= Subject: Re: Postgresql 8.4 optimize for heavy select load To: Job , "pgsql-performance@postgresql.org" References: <88EF58F000EC4B4684700C2AA3A73D7A08054C149843@W2008DC01.ColliniConsulting.lan> From: Mark Kirkwood Message-ID: <3a4d7d2f-bee4-2c16-0851-626f3b2e052f@catalyst.net.nz> Date: Mon, 19 Sep 2016 20:23:18 +1200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: <88EF58F000EC4B4684700C2AA3A73D7A08054C149843@W2008DC01.ColliniConsulting.lan> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -5.1 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 19/09/16 19:40, Job wrote: > Hello, > > i would please like to have some suggestions to optimize Postgres 8.4 for a very heavy number of select (with join) queries. > The queries read data, very rarely they write. > We probably need to see schema and query examples to help you (with EXPLAIN ANALYZE output). Also - err 8.4 - I (and others probably) will recommend you upgrade to a more recent (and supported for that matter) version - currently 9.5/9.6 - lots of performance improvements you are missing out on! Best wishes Mark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance