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

From Chris Browne
Subject Re: The trigger can be specified to fire on time condition?
Date
Msg-id 60oe0szp2q.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to The trigger can be specified to fire on time condition?  (Jamal Ghaffour <Jamal.Ghaffour@elios-informatique.fr>)
List pgsql-performance
Jamal.Ghaffour@elios-informatique.fr (Jamal Ghaffour) writes:
> 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 ?

Time-based event scheduling is done using cron, external to the
database.
--
output = reverse("gro.mca" "@" "enworbbc")
http://cbbrowne.com/info/sgml.html
"Even in the  area of anticompetitive conduct, Microsoft  is mainly an
imitator." -- Ralph Nader (1998/11/11)

pgsql-performance by date:

Previous
From: Chris Browne
Date:
Subject: Re: Large Table With Only a Few Rows
Next
From: "Peter Childs"
Date:
Subject: Re: Large Table With Only a Few Rows