Request a Demo
Home   >   mailing lists

Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL - Mailing list pgsql-admin

From Ilya Kosmodemiansky
Subject Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Date
Msg-id CAG95seU7jONxDvMnTkC23pgFPGmO=zG266CR1ZThjrbvvtz8VA@mail.gmail.com
Whole thread Raw
In response to Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL  (Motog Plus <mplus7535@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Seeking Suggestions for Best Practices: Archiving and Migrating Historical Data in PostgreSQL
Next
From: Ron Johnson
Date:
Subject: Re: pg_dump verbose start and stop times?