X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C6B0611F60E7 for ; Wed, 26 Apr 2006 17:33:17 -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 02844-08 for ; Wed, 26 Apr 2006 17:33:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.200]) by postgresql.org (Postfix) with ESMTP id 05D3811F60AE for ; Wed, 26 Apr 2006 17:33:04 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id h31so1099979wxd for ; Wed, 26 Apr 2006 13:33:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=SUqf8ZnTuR0elClPw/lTCdZ0f53boTPfc25HTUFEKwZ4O5L+gz3zP84aOdT73of2w86oYunPN92GbZg2UmaAwuvv3U1XWW2L5COJ8cT+VYCJtgYpNM9b+8cm7JUaF04I1D+Hpfc/R7wSVcDYyw6uHvj/cMauokYH1gP/oohsAEU= Received: by 10.70.39.8 with SMTP id m8mr131834wxm; Wed, 26 Apr 2006 13:33:04 -0700 (PDT) Received: by 10.70.83.7 with HTTP; Wed, 26 Apr 2006 13:33:04 -0700 (PDT) Message-ID: <1d219a6f0604261333u1e0a2c0btb7786f3c32360f27@mail.gmail.com> Date: Wed, 26 Apr 2006 16:33:04 -0400 From: "Chris Hoover" To: "Benjamin Krajmalnik" Subject: Re: Tale partitioning Cc: pgsql-admin@postgresql.org In-Reply-To: <8511B4970E0D124898E973DF496F9B432515C3@stash.stackdump.local> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17031_28837864.1146083584955" References: <8511B4970E0D124898E973DF496F9B432515C3@stash.stackdump.local> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/283 X-Sequence-Number: 21452 ------=_Part_17031_28837864.1146083584955 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Each of the partition tables needs it's own set of indexes. Build them, an= d see if the does not fix your performance issues. Also, be sure you turned on the constraint_exclusion parameter, and each table (other than the "master") has an constraint on it that is unique. HTH, Chris ------=_Part_17031_28837864.1146083584955 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Each of the partition tables needs it's own set of indexes.  Build the= m, and see if the does not fix your performance issues.  Also, be sure= you turned on the constraint_exclusion parameter, and each table (other th= an the "master") has an constraint on it that is unique.

HTH,

Chris



------=_Part_17031_28837864.1146083584955--