> Hi, > > I am using Postgres to store CDR data for voip switches. The data size quickly > goes about a few TBs. > > What I would like to do is to be able to regularly archive the oldest data so > only the most recent 6 months of data is available. > > All those old data will be stored in a format that can be retrieved back either > into DB table or flat files. > > Does anyone know how should I go about doing that? Is there any existing tool > that can already do that?
Sounds like table partitioning: create, for instance, a table for each month and DROP old tables after 6 month or so.