pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Partitioning in postgres - basic question
2+ messages / 2 participants
[nested] [flat]

* Partitioning in postgres - basic question
@ 2007-10-04 17:51 Tore Lukashaugen <tore@lukashaugen.freeserve.co.uk>
  2007-10-05 05:19 ` Re: Partitioning in postgres - basic question Chris <dmagick@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Tore Lukashaugen @ 2007-10-04 17:51 UTC (permalink / raw)
  To: 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 





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Partitioning in postgres - basic question
  2007-10-04 17:51 Partitioning in postgres - basic question Tore Lukashaugen <tore@lukashaugen.freeserve.co.uk>
@ 2007-10-05 05:19 ` Chris <dmagick@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Chris @ 2007-10-05 05:19 UTC (permalink / raw)
  To: Tore Lukashaugen <tore@lukashaugen.freeserve.co.uk>; +Cc: pgsql-performance

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2007-10-05 05:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-04 17:51 Partitioning in postgres - basic question Tore Lukashaugen <tore@lukashaugen.freeserve.co.uk>
2007-10-05 05:19 ` Chris <dmagick@gmail.com>

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