in reply to Re^4: Help on selecting and deleting many records in a DB.
in thread Help on selecting and deleting many records in a DB.

Well, it does if you run it every day and clean up afterwards, with a cron job for instance.

If possible, it seems you could solve a big part of your problem using partitioning of your table, probably by day; see:
http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html


libremen.com : legal case, contract and insurance claim management software
  • Comment on Re^5: Help on selecting and deleting many records in a DB.

In Section Seekers of Perl Wisdom