Re: Performance on DISABLE TRIGGER (resend) - Mailing list pgsql-general

From gmb
Subject Re: Performance on DISABLE TRIGGER (resend)
Date
Msg-id 1425406017358-5840247.post@n5.nabble.com
Whole thread Raw
In response to Re: Performance on DISABLE TRIGGER (resend)  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
Greg Sabino Mullane wrote
> Disabling triggers requires a heavy lock. A better way is to use
> the session_replication_role feature. See:
>
> http://blog.endpoint.com/2015/01/postgres-sessionreplication-role.html

This is a very effective solution to my problem. Thanks for the tip, Greg.



--
View this message in context: http://postgresql.nabble.com/Performance-on-DISABLE-TRIGGER-tp5839727p5840247.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re:
Next
From: Francisco Olarte
Date:
Subject: Re: Copy Data between different databases