I am using postgres 7.2, and have rule on a table which causes a notify if
an insert/update/delete is performed on the table.
The table is very very small.
When performing a simple (very simple) update on the table this takes about
3 secs, when I remove the rule it is virtually instantaneous.
The rest of the database seems to perform fine, have you any ideas or come
across this before??

Regards
Steve


Mon, 30 Sep 2002 09:14:00 +0100
Steve King <steve.king@ecmsys.co.uk>
Bad rules
Steve King <steve.king@ecmsys.co.uk> writes:
> I am using postgres 7.2, and have rule on a table which causes a notify if
> an insert/update/delete is performed on the table.
> The table is very very small.
> When performing a simple (very simple) update on the table this takes about
> 3 secs, when I remove the rule it is virtually instantaneous.
> The rest of the database seems to perform fine, have you any ideas or come
> across this before??

Let's see the rule exactly?  NOTIFY per se is not slow in my experience.

(One thing to ask: have you done a VACUUM FULL on pg_listener in recent
memory?  Heavy use of LISTEN/NOTIFY does tend to bloat that table if you
don't keep after it with VACUUM.)

			regards, tom lane

Fri, 04 Oct 2002 10:48:10 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Bad rules 