Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7C3289FB5C0 for ; Fri, 12 Jan 2007 06:41:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 50846-10 for ; Fri, 12 Jan 2007 06:41:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by postgresql.org (Postfix) with ESMTP id E085D9FB5A0 for ; Fri, 12 Jan 2007 06:41:44 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id i28so615414wra for ; Fri, 12 Jan 2007 02:41:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=qA191lRcnZcJuuadEphl7E3pShEFUQvQEdwkWGtYDskpqQoMMawTaWW1ilu4tsoJoF15IhZk9ajJAIwzZ2/GsfLoEZUhgoLFweeFv6UMWTQcCIwqU+v/Xnf/mGfGYwzW5ZmW8dylidswfxaemLhdri31f8b6M3VXZCxDSwPr0aw= Received: by 10.78.122.11 with SMTP id u11mr151973huc.1168598503193; Fri, 12 Jan 2007 02:41:43 -0800 (PST) Received: from ?192.168.0.39? ( [62.232.55.118]) by mx.google.com with ESMTP id 33sm1087897hue.2007.01.12.02.41.41; Fri, 12 Jan 2007 02:41:42 -0800 (PST) Message-ID: <45A765DE.9020003@enterprisedb.com> Date: Fri, 12 Jan 2007 10:41:34 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: Tobias Brox CC: Peter Childs , pgsql-performance@postgresql.org Subject: Re: Planner statistics, correlations References: <20070112081631.GA10636@oppetid.no> <20070112090500.GB16243@oppetid.no> In-Reply-To: <20070112090500.GB16243@oppetid.no> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/203 X-Sequence-Number: 22804 Tobias Brox wrote: > Maybe it would help to partitionate the table every year? I thought about partitioning the table by state, putting rows with state=4 into one partition, and all others to another partition. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com