Another little question ... would using any sort of TEMP table help out, i.e.
loading the unaggregated data into a TEMP table, aggregating the data via a
SELECT INTO another TEMP table, and then finally INSERT ... SELECT into the
master, aggregated, triggered table? It seems like this might be a win if
A) the TEMP tables fit into memory, and B) the load data aggregates well.
Worst case (i.e. all unique data in the load) seems like it might take much
longer, however, since I'm creating 2 new TEMP tables ....
In response to
pgsql-performance by date
|Next:||From: Merlin Moncure||Date: 2006-05-26 19:40:22|
|Subject: Re: is it possible to make this faster?|
|Previous:||From: Worky Workerson||Date: 2006-05-26 18:48:20|
|Subject: Bulk loading/merging|