From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Goulet, Dick <DGoulet@vicr.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-interfaces@postgresql.org, Scott Lamb <slamb@slamb.org>
Subject: Re: Incremental results from libpq
Date: Thu, 17 Nov 2005 19:34:30 -0500 (EST)
Message-ID: <200511180034.jAI0YUO23634@candle.pha.pa.us> (raw)
In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502EF5628@25exch1.vicorpower.vicr.com>
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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgman@candle.pha.pa.us, DGoulet@vicr.com, alvherre@commandprompt.com, tgl@sss.pgh.pa.us, peter_e@gmx.net, slamb@slamb.org
Subject: Re: Incremental results from libpq
In-Reply-To: <200511180034.jAI0YUO23634@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox