Partitioning database in Postgres

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ntech
    New Member
    • Jul 2007
    • 13

    #1

    Partitioning database in Postgres

    Dear all,
    I have some problems regarding postgresql. I have installed Postgresql server 7.2.4 and since the database size is growing day by day, I want to partition the database. I have gone under some documents but still get it. So, can anyone help me how to partition database in postgresql by example and which version it supports?

    Thanks,
    Sagar
  • michaelb
    Recognized Expert Contributor
    • Nov 2006
    • 534

    #2
    Originally posted by ntech
    Dear all,
    ... ... ...
    I have installed Postgresql server 7.2.4 ...
    Sagar, the 7.2 version is obsolete, it is very old, it is not supported, it is buggy... - you should consider upgrading to a later version.

    As for your question Postgresql supports table partitioning, but then again - I don't think this feature is available with 7.2.
    Follow these links for more information:
    5.12. Table Partitioning # 5.12.1. Overview 5.12.2. Declarative Partitioning 5.12.3. Partitioning Using Inheritance 5.12.4. Partition Pruning 5.12.5. Partitioning and Constraint Exclusion …

    22.6. Tablespaces # Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database …

    Comment

    Working...