Partitioning tables... - Mailing list pgsql-admin

From Joe Maldonado
Subject Partitioning tables...
Date
Msg-id 1059679331.2548.14.camel@joem
Whole thread Raw
Responses Re: Partitioning tables...  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
List pgsql-admin
Hello all,
    I currently have a project which will store roughly 10B  records in
postgres which will be inserted at a rate of about 40K/s.  While we have
adequate disk storage it is paramount that subsets of the data be
queryable quickly, without hindering the insert process to a crawl.

    I know in Oracle you can partition the tables into logical subsets and
was wondering if this was also possible in postgres.

Thanks in advance,
    -Joe


pgsql-admin by date:

Previous
From: "Benjamin Thelen (CCGIS)"
Date:
Subject: Re: changing ownership of db
Next
From: pgboy@guthrie.charm.net
Date:
Subject: Re: storage calculations