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