For the time being, it sounds like I'll probably try to implement the drop/create trigger setup during import.
-tfo
-- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
On Jan 27, 2005, at 11:41 PM, Josh Berkus wrote:
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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org