| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | Doug Fields <dfields-pg-general(at)pexicom(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Urgent need of (paid) PostgreSQL support in New |
| Date: | 2002-12-11 15:09:05 |
| Message-ID: | 20021211150905.53175.qmail@web20807.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Doug Fields <dfields-pg-general(at)pexicom(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SZŰCS Gábor | 2002-12-11 15:25:08 | Re: ExecEvalExpr: unknown expression type 108 |
| Previous Message | Jean-Christian Imbeault | 2002-12-11 13:14:12 | Re: infinity as a date |