Thread: Partitioning tables...

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

On Thu, 31 Jul 2003, Joe Maldonado wrote:

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

I *think* that a partial index is probably your best bet.

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University