Re: Performance on DISABLE TRIGGER (resend)

From: gmb <gmbouwer(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance on DISABLE TRIGGER (resend)
Date: 2015-03-03 18:06:57
Message-ID: 1425406017358-5840247.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2015-03-03 18:09:42 Re: Copy Data between different databases
Previous Message Francisco Olarte 2015-03-03 18:00:08 Re: