Bad rules

From: Steve King <steve(dot)king(at)ecmsys(dot)co(dot)uk>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Bad rules
Date: 2002-09-30 08:14:00
Message-ID: 5B5F2A89A44ED5118A790090274DD8462AB5BE@SNOOPY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guido Staub 2002-09-30 09:44:17 current_timestamp after queries
Previous Message Tom Lane 2002-09-30 04:36:34 Re: [SQL] CURRENT_TIMESTAMP