Re: Triggers During COPY

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Triggers During COPY
Дата
Msg-id 200501272141.49531.josh@agliodbs.com
обсуждение исходный текст
Ответ на Triggers During COPY  (Thomas F.O'Connell <tfo@sitening.com>)
Ответы Re: Triggers During COPY
Re: Triggers During COPY
Список pgsql-performance
Thomas,

> Would it be absurd to drop the triggers during import and recreate them
> afterward and update the counts in a summ> ary update based on
> information from the import process?

That's what I'd do.

Also, might I suggest storing the counts in memcached (see the pgmemached
project on pgFoundry) rather than in a table?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: slow count()
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Triggers During COPY