Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL

Hi Ramzy,


On Fri, May 30, 2025 at 9:51 AM Motog Plus <mplus7535@gmail.com> wrote:
> We’d like to understand:
> - What approaches have worked well for you in practice?

It really depends on your requirements. What volumes of data you store
and intend to archive? Are your tables partitioned, or is partitioning
at least an option for you? Would it be a rear operation (really once
a year) or you need to do it regularly




Best regards,
Ilya Kosmodemiansky
CEO, Founder

Data Egret GmbH
Your remote PostgreSQL DBA team
T.: +49 6821 919 3297
ik@dataegret.com