The trigger can be specified to fire on time condition? - Mailing list pgsql-performance

From Jamal Ghaffour
Subject The trigger can be specified to fire on time condition?
Date
Msg-id 44033246.9030808@elios-informatique.fr
Whole thread Raw
Responses Re: The trigger can be specified to fire on time condition?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
Hi All,
I ' m using the postgresql datbase to stores cookies. Theses cookies
become invalid after  30 mn and have to be deleted. i have defined a
procedure that will
delete all invalid cookies, but i don't know how to call it in loop way
(for example each hour).
I think that it  possible  because this behaivor is the same of the
autovaccum procedure that handle the vaccum process every time (60s in
default way).
After reading the documentation, it seems  that triggers can't handle
this stuff .
how can i resolve the problem ?


Thanks

Attachment

pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: neverending vacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: The trigger can be specified to fire on time condition?