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

> On May 30, 2025, at 7:39 AM, Joe Tailleur <joe.tailleur@gmail.com> wrote:
>
> Using table partitioning works well for me.  I detach and move the partition to an archive schema; which I can then
backupand restore into a separate database, and once that is complete, remove the table from the archive schema on the
livedatabase. 

What's the purpose of the archive schema?