> That's also a way you could migrate your current table without disrupting production.
>
> Partitioning like that is often done as a performance optimization; but it sounds like you're proposing that a file system cannot be expected to handle a large table in piece??? I don't understand that.
Let us say that that the sys admins have set a limit of 1TB per FS.
This automatically implies that a single table can not grow more than
1TB, unless it is broken into smaller tables via inheritance and each
child table goes to a separate table-space. I hope I am clearer now.