Re: Maintaining a counter up-to-date

Поиск
Список
Период
Сортировка
От Samuel Tardieu
Тема Re: Maintaining a counter up-to-date
Дата
Msg-id 2003-06-02-20-29-28+trackit+sam@rfc1149.net
обсуждение исходный текст
Ответ на Re: Maintaining a counter up-to-date  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql
On  2/06, Richard Huxton wrote:

| You want to use triggers not rules here (see the "server programming" and 
| "procedural language" manual sections). A trigger will be fired for each row 
| inserted/deleted/updated. Of course this means it will be fired 5000 times 
| for 5000 updated rows.

Ouch. At the current time, I reverted to count(*) style which seems to be
performed in much less time in 7.3.2 than in 7.2.x.

I'll look at the triggers, thanks.
 Sam



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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Maintaining a counter up-to-date
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: To ListAdms: Is pgsql-sql operating?