On 20/06/16 17:25, Melvin Davidson wrote: >>And you haven't read Vik's reply. :) > > Yes I have. Vacuum wll not lock all tables at once, only the ones it is > currently working on, so the planner may have a slight delay, > but it will not be gigantic.
I think you should try it. > I have proposed a reasonable solution to solve the problem in it's > entirety. Do you have a better one? You mean by partitioning? That doesn't really solve any problem, except that vacfull-ing a partition should be faster than doing the whole enchilada. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
