Re: Proposal "VACUUM SCHEMA" - Mailing list pgsql-hackers

<div dir="ltr"><div class="gmail_extra"><br />On Sun, Dec 21, 2014 at 5:18 PM, Tom Lane <<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>wrote:<br />><br />> Fabrízio de Royes Mello <<a
href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>>writes:<br />> > I work with some customer
thathave databases with a lot of schemas and<br />> > sometimes we need to run manual VACUUM in one schema, and
wouldbe nice to<br />> > have a new option to run vacuum in relations from a specific schema.<br />><br />>
I'mpretty skeptical of this alleged use-case.  Manual vacuuming ought<br />> to be mostly a thing of the past, and
evenif it's not, hitting<br />> *everything* in a schema should seldom be an appropriate thing to do.<br />><br
/><br/></div><div class="gmail_extra">I agree manual vacuum is a thing of the past, but autovacuum doesn't solve 100%
ofthe cases, and sometimes we need to use it so my proposal is just do help DBAs and/or Sysadmins to write simple
maintenancescripts.<br /></div><div class="gmail_extra"><br /><br />> While the feature itself might be fairly
innocuous,I'm just wondering<br />> why we need to encourage manual vacuuming.  <br /><br /></div><div
class="gmail_extra">IMHOwe will not encourage manual vacuuming, just give more flexibility to users.<br /></div><div
class="gmail_extra"><br/><br />> And why that, but not<br />> say schema-wide ANALYZE, CLUSTER, TRUNCATE, ...<br
/>><br/><br /></div><div class="gmail_extra">+1. I can write patches for each of this maintenance statement too.<br
/></div><divclass="gmail_extra"><br /></div><div class="gmail_extra">Regards,<br /></div><div class="gmail_extra"><br
/>--<br/>Fabrízio de Royes Mello<br />Consultoria/Coaching PostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/>>> Blog: <a
href="http://fabriziomello.github.io">http://fabriziomello.github.io</a><br/>>> Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/>>> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a><br/>>> Github: <a
href="http://github.com/fabriziomello">http://github.com/fabriziomello</a></div></div>