Alex Paulusberger <alexp(at)meta-bit(dot)com> writes:
> initially if am able to evaluate 5-6 records a second and insert them
> into the results table, however towards the end
> of the evaluation, the figure drops to under 2.
Do you have suitable index(es) on the temp table? Is the system actually
using it/them for your queries?
regards, tom lane