The docs claim that the master table “should” be empty. It it possible to just
create child tables off an existing master table with data, then just inserting
data into the new child tables.
THe plan would be to keep data in the master table and purge it over time until
it’s eventually empty, t
On Fri, Dec 29, 2017 at 11:37:56PM -0500, Robert Blayzor wrote:
> The docs claim that the master table “should” be empty. It it possible to
> just create child tables off an existing master table with data, then just
> inserting data into the new child tables.
>
> THe plan would be to keep data
This topic is confusing to lots of people, usually including myself, so I'm
hoping to clarify it at least to myself, and maybe provide a good reference or
doc update for others in the future.
autovacuum/analyze automatically scans tables being inserted/updated/deleted
and updates their statistics
