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 0CC889FB1C0 for ; Thu, 6 Jul 2006 03:40:22 -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 25034-06 for ; Thu, 6 Jul 2006 03:40:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from office.redwerk.com (office.redwerk.com [85.90.206.104]) by postgresql.org (Postfix) with ESMTP id 142C69FA603 for ; Thu, 6 Jul 2006 03:40:16 -0300 (ADT) Received: from bofh by office.redwerk.com with local (Exim 4.62 (FreeBSD)) (envelope-from ) id 1FyNX6-0000Qf-2U for pgsql-performance@postgresql.org; Thu, 06 Jul 2006 09:40:16 +0300 Date: Thu, 6 Jul 2006 09:40:16 +0300 From: Eugeny N Dzhurinsky To: pgsql-performance@postgresql.org Subject: getting better performance Message-ID: <20060706064016.GC1091@office.redwerk.com> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/37 X-Sequence-Number: 19897 Hello! I have a postgresql server serving thousands of tables. Sometime there are queries which involves several tables. 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? -- Eugene N Dzhurinsky