--- Doug Fields <dfields-pg-general@pexicom.com>
wrote:
>
> The biggest slowdown seems to come when there are
> queries of the form:
>
> 1) INSERT INTO tableA SELECT * FROM temp_table
> executing simultaneously with queries of the form
> 2) INSERT INTO tableB SELECT column FROM tableA
> WHERE various clauses
>
You will probably find it more efficient to write a
procedure that handles the inserts into both tableA
and tableB sumultaneously based on the temp_table data.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com