Re: best practice in archiving CDR data

On Mon, Mar 29, 2010 at 02:08:23PM +0000, Edgardo Portal wrote:
> On 2010-03-29, Juan Backson <juanbackson(at)gmail(dot)com> wrote:
> > --0016e64ccb10fb54050482f07924
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > 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?
> >
>
> FWIW, I partition by ISO week, use INSERT RULEs to route CDRs

Just generally, triggers are much better than RULEs for this kind of
thing. The underlying functions can be made quite efficient.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate