Re: This query is still running after 10 hours...

Поиск
Список
Период
Сортировка
От Robert Creager
Тема Re: This query is still running after 10 hours...
Дата
Msg-id 20040928202140.4ea9d090@thunder.mshome.net
обсуждение исходный текст
Ответ на Re: This query is still running after 10 hours...  (Kevin Barnard <kevin.barnard@gmail.com>)
Ответы Re: This query is still running after 10 hours...
Список pgsql-performance
When grilled further on (Tue, 28 Sep 2004 09:28:47 -0500),
Kevin Barnard <kevin.barnard@gmail.com> confessed:

> What does observations_trigger do?
>

The trigger keeps another table (catalog) up to date with the information from the obs_v and obs_i tables.  There are
nodirect insert/update/delete's on the catalog table, only though the trigger. 

--
 19:56:54 up 5 days, 22:23,  2 users,  load average: 2.46, 2.27, 2.15
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

Вложения

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

Предыдущее
От: "Matthew Nuzum"
Дата:
Сообщение: Re: Caching of Queries
Следующее
От: Robert Creager
Дата:
Сообщение: Re: This query is still running after 10 hours...