On 08/08/2012 04:15 AM, Merlin Moncure wrote:
IF current_user = 'bulk_writer' THEN
return new;
END IF;
<expensive stuff>
... or re-create the trigger with a `WHEN` clause (only available in
newer Pg versions, see CREATE TRIGGER) that excludes the migrated
customer ID. You'd have to do it in a new tx to avoid locking the table
for ages though.
--
Craig Ringer
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
