Steve King <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org