Re: Triggers During COPY

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
Cc: PgSQL - Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Triggers During COPY
Date: 2005-01-28 05:41:49
Message-ID: 200501272141.49531.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-01-28 05:55:37 Re: Triggers During COPY
Previous Message Bruno Wolff III 2005-01-28 05:38:34 Re: slow count()