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