From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: erserver |
Date: | 2002-07-25 15:28:13 |
Message-ID: | 20020725082516.U48415-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 25 Jul 2002, Andrew Sullivan wrote:
> One thing we did discover with 7.1.3 is that RI triggers on the slave
> can _really_ slow things down. It appears that triggers get slower
> and slower as a transaction rolls on, and therefore make everything
> crawl if you have a lot of rows to update (if, for instance, you stop
> replication for a while for some reason). The easy answer is to drop
> all the RI triggers, although that means you have to add another step
> in the event you have to flip over to the slave server. I haven't
> yet discovered whether the same problem persists in 7.2.
As a note, very possibly not, since IIRC Tom made some changes to
speed up the adding of the deferred triggers between 7.1 and 7.2.
However, it's probably not a bad idea to drop the triggers anyway. :)
From | Date | Subject | |
---|---|---|---|
Next Message | Stephane Bortzmeyer | 2002-07-25 15:35:49 | Re: How to covert 'char' to 'inet' |
Previous Message | Tom Lane | 2002-07-25 15:25:21 | Re: Auto DROP SEQUENCE? |