Re: R: Vacuum full: alternatives?

On 20.06.2016 17:30, Vik Fearing wrote:
> On 20/06/16 16:23, Martín Marqués wrote:
>> El 20/06/16 a las 09:50, Melvin Davidson escribió:
>>>
>>>> but it won't let it grow too (or am I missing something).
>>> Yes, you are missing something. By partioning and {Vacuum Full only the
>>> table with data no longer needed}, the rest of the data remains
>>> available to the users
>>> AND space is reclaimed by the O/S, so it's the best of both worlds.
>> That's not entirely true. Think about a SELECT which has to scan all
>> child tables.
> Or any SELECT on the parent at all.  The planner needs to examine the
> CHECK constraints on the children and can't do it if the child is locked
> in ACCESS EXCLUSIVE mode.
+1


Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company