| From: | Jamal Ghaffour <Jamal(dot)Ghaffour(at)elios-informatique(dot)fr> |
|---|---|
| To: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | The trigger can be specified to fire on time condition? |
| Date: | 2006-02-27 17:09:26 |
| Message-ID: | 44033246.9030808@elios-informatique.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| Jamal.Ghaffour.vcf | text/x-vcard | 378 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-02-27 17:10:07 | Re: The trigger can be specified to fire on time condition? |
| Previous Message | Csaba Nagy | 2006-02-27 15:03:40 | Re: neverending vacuum |