> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
