Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 45C519F9BB3 for ; Fri, 5 Oct 2007 02:16:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80842-10 for ; Fri, 5 Oct 2007 02:16:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.180]) by postgresql.org (Postfix) with ESMTP id 1A7F59F9BA5 for ; Fri, 5 Oct 2007 02:16:12 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so532697waf for ; Thu, 04 Oct 2007 22:16:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=9HdxCZOG82AOMuCpb4giQAigBbXcDCsYYYKjXUsY7BM=; b=NxOjDL8qpfiFqsXiUaXcgUDvBXd/Jh7iL7ntyybbSmYneMd/wmQsAIcjoT+2rTDQGPloIjX13WF0mSfwVIGMVa1DQdI7iR8huqKW0S9EQlCmyKWm7coQy4EfO5dWq/5TafvtlLcMebiLBediw4JwHAuFyCEJZz0HZadG3ejdMKM= 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; b=tA3rDOeLm7FPb9grc449yNjpphjY/wBBxH8Z++49z6U/Gg6lw6oICX24whdZ7PagPKncj72caS4xdZ8dyHx9AhMSz7H3oBsVinNlVqZc3d6KmOEYFXdnqjmQRGB/NEeCrEjL8hR7Jerg186Rp55KU0T96IlCLz1A61rCHNRIfBI= Received: by 10.115.22.1 with SMTP id z1mr6787659wai.1191561371041; Thu, 04 Oct 2007 22:16:11 -0700 (PDT) Received: from ?10.1.1.13? ( [203.217.18.65]) by mx.google.com with ESMTPS id m29sm1277976poh.2007.10.04.22.16.05 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 04 Oct 2007 22:16:06 -0700 (PDT) Message-ID: <4705C95B.2040603@gmail.com> Date: Fri, 05 Oct 2007 15:19:23 +1000 From: Chris User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Tore Lukashaugen CC: pgsql-performance@postgresql.org Subject: Re: Partitioning in postgres - basic question References: In-Reply-To: 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: 200710/53 X-Sequence-Number: 27075 Tore Lukashaugen wrote: > Hi, > > I am new to postgres having worked with Oracle in the past. I am interested > in understanding Postgres's table partition functionality better. > Specifically, I have a third party application running against my postgres > database, but the database is becoming rather large to maintain. I am > thinking about partitioning the biggest table. > > Would I be able to set-up partitioning on this table with it being seemless > to the third party app (assuming that it performs pretty standard DML > statements against the table in question)? http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html#DDL-PARTITIONING-IMPLEMENTATION The examples use rules but some on the list have said triggers work better if you have a lot of partitions. -- Postgresql & php tutorials http://www.designmagick.com/