Re: synchronous_commit: Developer's View - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: synchronous_commit: Developer's View
Date
Msg-id 1188766620.4167.45.camel@ebony.site
Whole thread Raw
In response to Re: synchronous_commit: Developer's View  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 2007-08-30 at 21:00 -0400, Tom Lane wrote:
> "Florian G. Pflug" <fgp@phlo.org> writes:
> > ... So at least for the pl/pgsql case, it seems easy enough to temporarily
> > change GUCs already. For other PLs, things might be different though -
> > I wouldn't know, I have never really used them...
> 
> It's definitely possible, but it's inconvenient and slow (slow because
> you have to run a subtransaction, which ain't cheap).  I think Simon
> might have a good point about generalizing the proposed "set the search
> path" facility to instead be "set any GUC for the duration of this
> function".  

> He's definitely all wet about the usefulness of that for
> synchronous_commit, but as Greg pointed out, there are other GUCs
> besides search_path that can break a function's expectations.

Not too sure what "all wet" means, but the imagery is great. :-)

As I said, I'm looking for a way to decorate a specific transaction
without changing application code. Setting it on a function works fine
as long as the function was invoked as a top-level procedure call in its
own implicit transaction, which is common usage. Clearly, this doesn't
really make sense for non-procedural functions such as md5(), though it
does for things like record_vehicle_position() or ad_impression().

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: tsearch filenames unlikes special symbols and numbers
Next
From: Oleg Bartunov
Date:
Subject: Re: tsearch filenames unlikes special symbols and numbers