The trigger can be specified to fire on time condition?

Поиск
Список
Период
Сортировка
От Jamal Ghaffour
Тема The trigger can be specified to fire on time condition?
Дата
Msg-id 44033246.9030808@elios-informatique.fr
обсуждение исходный текст
Ответы Re: The trigger can be specified to fire on time condition?
Список 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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: neverending vacuum
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: The trigger can be specified to fire on time condition?