Re: Triggers During COPY - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Triggers During COPY
Date
Msg-id 200501272141.49531.josh@agliodbs.com
Whole thread Raw
In response to Triggers During COPY  (Thomas F.O'Connell <tfo@sitening.com>)
Responses Re: Triggers During COPY
Re: Triggers During COPY
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: slow count()
Next
From: Mark Kirkwood
Date:
Subject: Re: Triggers During COPY