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

From Jim Nasby
Subject Re: Proposal "VACUUM SCHEMA"
Date
Msg-id 549A1247.2030802@BlueTreble.com
Whole thread Raw
In response to Re: Proposal "VACUUM SCHEMA"  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 12/23/14, 7:44 AM, Robert Haas wrote:
> On Mon, Dec 22, 2014 at 5:00 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
>> I would MUCH rather that we find a way to special-case executing
>> non-transactional commands dynamically, because VACUUM isn't the only one
>> that suffers from this problem.
>
> Is pg_background a solution to this problem?

Yes, since it allows you to do "autonomous transactions". It's probably not the most efficient way to solve this, but
itshould work.
 
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Proposal "VACUUM SCHEMA"
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Proposal "VACUUM SCHEMA"