Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C39932E0033 for ; Mon, 28 Apr 2008 13:19:36 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 83529-06 for ; Mon, 28 Apr 2008 13:19:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.156]) by developer.postgresql.org (Postfix) with ESMTP id F3AF52E002D for ; Mon, 28 Apr 2008 13:19:31 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 22so4587849fge.23 for ; Mon, 28 Apr 2008 09:19:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=di9+rexcI0dVqw/5hrUytX4VVZ1G//rWh1sbmV2op5o=; b=PROehl/3EAAnGej6kFTVEmvwnJuNSOw74tyVHb0cnP8hPlk0fXMfHqULL5a0jYkDMBcDdomMgGdy5MBDNidlQwMFFBtuEGISxN3oxfOQoj7DdEv8fBj9yT8tkJqoVB42z4TDEkKLGzPtaF84jgxbTz38NxFm68nUskLJk5clqSM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jzGD8LPlyDiDV5v7v+BurFF2ItNu2pkX1acp3zFT7A6KT7/CPRpGzjqf0+ak6l/AMBrdzETNRKZk6ILHgq+X2AKI6aEcIGO8QnH8xKAxzCyqWWeLlwaY3dowP12W4f6dpNaJyNugtu9w3wDwc0zx4l8WCb/JpNKRK0ncXcv8p/M= Received: by 10.86.25.12 with SMTP id 12mr8148442fgy.25.1209399570916; Mon, 28 Apr 2008 09:19:30 -0700 (PDT) Received: by 10.86.81.6 with HTTP; Mon, 28 Apr 2008 09:19:30 -0700 (PDT) Message-ID: Date: Mon, 28 Apr 2008 18:19:30 +0200 From: "Claus Guttesen" To: "A B" Subject: Re: Where do a novice do to make it run faster? Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: 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: 200804/399 X-Sequence-Number: 29892 > 1) hardware > 2) rewriting my queries and table structures > 3) using more predefined queries > 4) tweek parameters in the db conf files > > Of these points: > 1) is nothing I can do about right now, but in the future perhaps. > 2) will be quite hard right now since there is more code than time. > 3) almost like 2 but perhaps more do-able with the current constraints. > 4) This seems to be the easiest one to start with... > > So what should I do/read concerning point 4? > If you have other good suggestions I'd be very interested in that. > > Thank you :-) You can provide information postgresql-version, what type of queries you're running, some explain analyze of those, and what type of hardware you're running and what OS is installed. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare