Thread: Partitioning in postgres - basic question

Partitioning in postgres - basic question

From
"Tore Lukashaugen"
Date:
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)?

Thanks
Tore



Re: Partitioning in postgres - basic question

From
Chris
Date:
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/