From: Chris <dmagick@gmail.com>
To: Tore Lukashaugen <tore@lukashaugen.freeserve.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Partitioning in postgres - basic question
Date: Fri, 05 Oct 2007 15:19:23 +1000
Message-ID: <4705C95B.2040603@gmail.com> (raw)
In-Reply-To: <fe3980$hd9$1@news.hub.org>
References: <fe3980$hd9$1@news.hub.org>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dmagick@gmail.com, tore@lukashaugen.freeserve.co.uk
Subject: Re: Partitioning in postgres - basic question
In-Reply-To: <4705C95B.2040603@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox