Jasbinder Singh Bali wrote:
> could you please elaborate this concept of queue table?
The basic idea is to for the insert trigger to not explicitly kick
off the work you need to have done, but simply insert a row into a
"work request table". A separate process notices that there is a
work request, and performs the work. This can be done by a periodic
cron job, or using NOTIFY/LISTEN.
There was a fairly detailed discussion of this last month - the
thread starts here:
http://archives.postgresql.org/pgsql-general/2007-04/msg01152.php
- John D. Burger
MITRE