Re: Vacuum full: alternatives?
От
John R Pierce
Тема
Re: Vacuum full: alternatives?
Дата
Msg-id
90db2072-d945-6b30-fc91-ec563369cb51@hogranch.com
Ответ на
Re: Vacuum full: alternatives? (David G. Johnston)
Список
Дерево обсуждения
Vacuum full: alternatives? Job <Job@colliniconsulting.it>
Re: Vacuum full: alternatives? Chris Ernst <cernst@zvelo.com>
Re: Vacuum full: alternatives? Rakesh Kumar <rakeshkumar464a3@gmail.com>
R: Vacuum full: alternatives? Job <Job@colliniconsulting.it>
Re: R: Vacuum full: alternatives? Rakesh Kumar <rakeshkumar464a3@gmail.com>
Re: R: Vacuum full: alternatives? Melvin Davidson <melvin6925@gmail.com>
Re: R: Vacuum full: alternatives? Martín Marqués <martin@2ndquadrant.com>
Re: R: Vacuum full: alternatives? Vik Fearing <vik@2ndquadrant.fr>
Re: R: Vacuum full: alternatives? Alex Ignatov <a.ignatov@postgrespro.ru>
Re: R: Vacuum full: alternatives? Martín Marqués <martin@2ndquadrant.com>
Re: R: Vacuum full: alternatives? Jeff Janes <jeff.janes@gmail.com>
R: R: Vacuum full: alternatives? Job <Job@colliniconsulting.it>
Re: R: Vacuum full: alternatives? Adarsh Sharma <eddy.adarsh@gmail.com>
Re: Vacuum full: alternatives? Andreas Kretschmer <andreas@a-kretschmer.de>
R: Vacuum full: alternatives? Job <Job@colliniconsulting.it>
Re: R: Vacuum full: alternatives? Robert Wysocki <robert.wysocki@net-a-porter.com>
Re: R: Vacuum full: alternatives? Andreas Kretschmer <andreas@a-kretschmer.de>
Re: R: Vacuum full: alternatives? Scott Mead <scottm@openscg.com>
Re: R: Vacuum full: alternatives? John R Pierce <pierce@hogranch.com>
Re: Vacuum full: alternatives? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Vacuum full: alternatives? John R Pierce <pierce@hogranch.com>
Re: R: Vacuum full: alternatives? Guillaume Lelarge <guillaume@lelarge.info>
Re: R: Vacuum full: alternatives? Melvin Davidson <melvin6925@gmail.com>
Re: R: Vacuum full: alternatives? Martín Marqués <martin@2ndquadrant.com>
Re: R: Vacuum full: alternatives? Melvin Davidson <melvin6925@gmail.com>
Re: R: Vacuum full: alternatives? Vik Fearing <vik@2ndquadrant.fr>
Re: R: Vacuum full: alternatives? Melvin Davidson <melvin6925@gmail.com>
Re: R: Vacuum full: alternatives? Jeff Janes <jeff.janes@gmail.com>
Re: R: Vacuum full: alternatives? Martín Marqués <martin@2ndquadrant.com>
Re: R: Vacuum full: alternatives? Melvin Davidson <melvin6925@gmail.com>
Re: Vacuum full: alternatives? Scott Marlowe <scott.marlowe@gmail.com>
R: Vacuum full: alternatives? Job <Job@colliniconsulting.it>
On 6/20/2016 8:51 AM, David G. Johnston wrote:
incorrect. in fact, an update is performed identically to an INSERT + DELETE(old)Except for heap-only-tuple optimization, right? We cannot build a HOT chain if the user requests a delete separately since their is no longer an association to trace from the old record.I suspect this affects free space usage to some degree as well but I agree and believe that the reclaimed space is not forbidden to be used (I wouldn't rely on my word though and haven't tried to find relevant documentation).
yeah, HOT only works on updates that don't modify any indexed fields, and only if there's adequate free space in the same block. If you have a update intensive table thats a candidate for HOT, I've been recommending setting that table's fill factor to 50-70% prior to populating it to leave freespace in every block.
-- john r pierce, recycling bits in santa cruz
В списке pgsql-general по дате отправления
