On Mon, Mar 29, 2010 at 02:08:23PM +0000, Edgardo Portal wrote: > On 2010-03-29, Juan Backson <juanbackson@xxxxxxxxx> 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@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
