Massive delete of rows, how to proceed? - Mailing list pgsql-performance

From Arnau
Subject Massive delete of rows, how to proceed?
Date
Msg-id 45673D56.10707@andromeiberica.com
Whole thread Raw
Responses Re: Massive delete of rows, how to proceed?  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
Hi all,

   I have a table with statistics with more than 15 million rows. I'd
like to delete the oldest statistics and this can be about 7 million
rows. Which method would you recommend me to do this? I'd be also
interested in calculate some kind of statistics about these deleted
rows, like how many rows have been deleted for date. I was thinking in
creating a function, any recommendations?

Thank you very much
--
Arnau

pgsql-performance by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Postgres scalability and performance on windows
Next
From: Tom Lane
Date:
Subject: Re: Postgres scalability and performance on windows