X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DEB939FB1C3 for ; Thu, 6 Jul 2006 05:48:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40768-03 for ; Thu, 6 Jul 2006 05:48:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id 181D29FA603 for ; Thu, 6 Jul 2006 05:48:10 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id m19so26048nfc for ; Thu, 06 Jul 2006 01:48:09 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sQboxooAkqxkb3ZNlseI/Rxhcm5qGOIKN+3Tiw8iyhYbk3xF7PIAIC65yJ0uxi7zA4kHCDwvt5FYqDnD9hbMbtoBQJzlkq9BIZVv/xxkMzvPk9reyZA3FANxzPu1ISlo3cqb+OQYeqZSiM3FFlMYr3AbDE8O8vpGGGpvwllssOA= Received: by 10.49.21.7 with SMTP id y7mr242006nfi; Thu, 06 Jul 2006 01:48:09 -0700 (PDT) Received: by 10.48.47.19 with HTTP; Thu, 6 Jul 2006 01:48:09 -0700 (PDT) Message-ID: <751e56400607060148vc8186ffpe580c4741ce942fd@mail.gmail.com> Date: Thu, 6 Jul 2006 12:48:09 +0400 From: "Ivan Zolotukhin" Reply-To: iz@sai.msu.ru To: "A. Kretschmer" Subject: Re: getting better performance Cc: pgsql-performance@postgresql.org In-Reply-To: <20060706064807.GD27611@webserv.wug-glas.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20060706064016.GC1091@office.redwerk.com> <20060706064807.GD27611@webserv.wug-glas.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/40 X-Sequence-Number: 19900 On 7/6/06, A. Kretschmer wrote: > am 06.07.2006, um 9:40:16 +0300 mailte Eugeny N Dzhurinsky folgendes: > > In postgresql.conf I have these settings: > > > > shared_buffers = 40000 > > work_mem = 8192 > > maintenance_work_mem = 16384 > > max_stack_depth = 2048 > > > > all other settings are left by default (except ones needed for pg_autovacuum). > > > > Is there anything I can tune to get better performance? > > You can set "log_min_duration_statement" to log slow querys and then > analyse this querys. When you collect your logs try PgFouine http://pgfouine.projects.postgresql.org/ to understand what queries should be optimized and what's the reason of poor performance.