Partitioning in postgres - basic question - Mailing list pgsql-performance

From Tore Lukashaugen
Subject Partitioning in postgres - basic question
Date
Msg-id fe3980$hd9$1@news.hub.org
Whole thread Raw
Responses Re: Partitioning in postgres - basic question
List pgsql-performance
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



pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Tuning Help - What did I do wrong?
Next
From: Ben
Date:
Subject: quickly getting the top N rows