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/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
