From: | Samuel Smith <pgsql(at)net153(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Archeiving and Purging |
Date: | 2015-03-19 13:06:30 |
Message-ID: | 550AC9D6.3000306@net153.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/18/2015 09:20 AM, adityagis wrote:
> Dear Users,
> I have lots of data in my DB. I need to do archeiving and purging of my
> data.
> Can anyone please help me with step by step riles?
>
>
> Thanks in Advance.
> Aditya Kumar
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/Archeiving-and-Purging-tp5842393.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
This is where partitioning comes in: https://github.com/keithf4/pg_partman
After that is set up, you would only need to drop the partition which
would take only a second or so. Problem is, it will probably take awhile
to get the data into a partitioned scheme.
Of course, I don't know what you mean by "lots of data". Normally, just
using a delete statement will be fine up until about 100 million rows or
so (on decent hardware).
--Sam
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2015-03-19 15:36:42 | Re: Installation Size showing huge size in postgres installed on windows os |
Previous Message | Raymond O'Donnell | 2015-03-19 12:44:58 | Re: Installation Size showing huge size in postgres installed on windows os |