Re: Proposal "VACUUM SCHEMA"

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal "VACUUM SCHEMA"
Date: 2014-12-24 02:49:40
Message-ID: CAFcNs+pE=Sdi_s8E0Y449U_nerfRXmOyBMSg4UtW7o+bY1HyTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em terça-feira, 23 de dezembro de 2014, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>
escreveu:

> On 12/23/14, 8:54 AM, Fabrízio de Royes Mello wrote:
>
>> > Right now a lot of people just work around this with things like DO
>> blocks, but as mentioned elsewhere in the thread that fails for commands
>> that can't be in a transaction.
>> >
>>
>> I use "dblink" to solve it. :-)
>>
>
> So... how about instead of solving this only for vacuum we create
> something generic? :) Possibly using Robert's background worker work?

Interesting idea.

But and what about the idea of improve the "--table" option from clients:
vaccumdb and clusterdb?

Regards,

Fabrízio Mello

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2014-12-24 03:04:23 Re: Using 128-bit integers for sum, avg and statistics aggregates
Previous Message Jim Nasby 2014-12-24 01:09:27 Re: Proposal "VACUUM SCHEMA"