Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a table with more than 60mio records, where every month I have to add about 2-4 milions. It's not insert only table, I need to read from it and update recently added rows (status changes, etc.). I have spotted some of my SELECT queries begun to ommit indexes because of number of rows to be searched using criterias. Therefore I want to archive records older than 6 months. Is there any good way to do this? Only thing I got in mind is manual copying data to archive db and remove at master. Perhaps there are some good practices or mechanisms to do it?

Michal

share|improve this question
add comment

1 Answer 1

I recently answered similar question here: database-archive-solutions

You should read about postgresql table partitioning, if you have good way to split data in parts.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.