| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | "Goulet, Dick" <DGoulet(at)vicr(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-interfaces(at)postgresql(dot)org, Scott Lamb <slamb(at)slamb(dot)org> |
| Subject: | Re: Incremental results from libpq |
| Date: | 2005-11-18 00:34:30 |
| Message-ID: | 200511180034.jAI0YUO23634@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Goulet, Dick wrote:
> Alvaro,
>
> You are quite correct, which is functionally the only
> difference. Personally I don't think that really amounts to "a hill of
> beans". The functionality is the same, even if the syntax is a touch
> different. Course, I didn't get a chance to tinker with this, but in
> Oracle a global temp table can have indexes and constraints. Is the
> same true in Postgresql?? I've found it to be a performance improver
> where your loading the temp table with thousands of rows.
Sure, you can create TEMPORARY anything, and because each backend has
its own table, performance is better.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murray Cumming | 2005-11-19 17:34:18 | Detecting postgres servers |
| Previous Message | Scott Lamb | 2005-11-17 22:04:26 | Re: Incremental results from libpq |