Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id BFA479FB1E6 for ; Wed, 18 Oct 2006 17:34:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 71908-10 for ; Wed, 18 Oct 2006 20:34:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web55905.mail.re3.yahoo.com (web55905.mail.re3.yahoo.com [216.252.110.66]) by postgresql.org (Postfix) with SMTP id BD8F89FA6B2 for ; Wed, 18 Oct 2006 17:34:35 -0300 (ADT) Received: (qmail 21062 invoked by uid 60001); 18 Oct 2006 20:34:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=PbIMn26Ozf8heUOpYdeuaWLInwZEHJ8uLIE4O+nFLFOqO8TZHN3tJUl7oV0f+7MkdAGbjUDO1G4HREdauSKdb8SAESD8lwOBljFkQZcDhE0yJwFs9BPnFdJkzHSHL5DRCp0VEbJkprnkcwcz69/qzKbGOdsTyPWURv6C8IxfOjM= ; Message-ID: <20061018203434.21060.qmail@web55905.mail.re3.yahoo.com> Received: from [207.164.182.8] by web55905.mail.re3.yahoo.com via HTTP; Wed, 18 Oct 2006 16:34:34 EDT Date: Wed, 18 Oct 2006 16:34:34 -0400 (EDT) From: Ioana Danes Subject: Re: Postgresql 8.1.4 - performance issues for select on view using max To: Dimitri Fontaine , pgsql-performance@postgresql.org Cc: Ioana Danes In-Reply-To: <200610182213.19037.dim@dalibo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200610/372 X-Sequence-Number: 21501 Thanks a lot I will give it a try. --- Dimitri Fontaine wrote: > Hi, > > Le mercredi 18 octobre 2006 21:51, Ioana Danes a > écrit : > > I am doing a test for a scenario where I have 2 > > schemas one (public) for the operational data and > > another one (archive) for old, archived data. So > > basically I want to split the data from some huge > > tables in two. All data before 2006 in archive and > all > > data after and including 2006 in public. > [...] > > I got into a scenario where my plan does not work > > without doing code change. > > This sounds a lot as a ddl partitionning, you may > want to add some checks to > your schema and set constraint_exclusion to on in > your postgresql.conf. > > Please read following documentation material : > > http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html > > Regards, > -- > Dimitri Fontaine > http://www.dalibo.com/ > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com