Re: Proposal "VACUUM SCHEMA"
От | Fabrízio de Royes Mello |
---|---|
Тема | Re: Proposal "VACUUM SCHEMA" |
Дата | |
Msg-id | CAFcNs+rKYqKdkF6cuvKM4e3UBKGGmmzVJxOFy=s=tP4Aw46-+g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Proposal "VACUUM SCHEMA" (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Proposal "VACUUM SCHEMA"
(Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: Proposal "VACUUM SCHEMA" (José Luis Tallón <jltallon@adv-solutions.net>) |
Список | 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>
В списке pgsql-hackers по дате отправления: