Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id EA5E82E0061 for ; Mon, 28 Apr 2008 12:56:38 -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 80212-05 for ; Mon, 28 Apr 2008 12:56:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by developer.postgresql.org (Postfix) with ESMTP id 6D4B52E0032 for ; Mon, 28 Apr 2008 12:56:28 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n7so8158967wag.5 for ; Mon, 28 Apr 2008 08:56:27 -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:mime-version:content-type:content-transfer-encoding:content-disposition; bh=47nR+/6DmIZrvwUk/3CVKI7yEJ4Mn3HPl1tnJSU2pOU=; b=is547n3/vaf9Kh6oj16DptBZX2C6hfGa5iSvvW4uifO7bQ2AExgMNS0FL7bsj8r9NPol1z6gsiK7wIyLmObwhL3NjN1eL4KREz9kXikMtC2RvtMv9PCdXl4RIrni8wkL5d/h1Miw4uq7YMt8KSmOeEpc9twNiKbaRjLn8vpQMn0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=LGSSVKyzOlrJFMC3cgAHjV1nEFUG1uhyrguLDjP+W5OZUw0ypX1uYXBzDNvObUc1SC6jsjU7ds4ehNZFZaqs94s0nd9A15H9cgQ0k8cca1VapCjX6elmPDO9a5iZjvo3+GAMH/UeqfXHHIJ7+8IwAc7w/Vo5AGVAKu4l/TmDMiU= Received: by 10.115.78.1 with SMTP id f1mr6617452wal.100.1209398187492; Mon, 28 Apr 2008 08:56:27 -0700 (PDT) Received: by 10.114.125.17 with HTTP; Mon, 28 Apr 2008 08:56:27 -0700 (PDT) Message-ID: Date: Mon, 28 Apr 2008 17:56:27 +0200 From: "A B" To: pgsql-performance@postgresql.org Subject: Where do a novice do to make it run faster? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/396 X-Sequence-Number: 29889 So, it is time to improve performance, it is running to slow. AFAIK (as a novice) there are a few general areas: 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 :-)