Alex Paulusberger <alexp@meta-bit.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
