On Fri, Oct 5, 2012 at 3:09 AM, Ivan Voras <ivoras@freebsd.org> wrote:
> I think I can make a fairly educated guess that catching exceptions
> while dealing with session variables should be much, much faster than
> creating any kind of a table :)
That is true, but it's not clear how using session variables keeps you
from having to create the table. If the table is already there, a
session variable guarding the table construction shouldn't be any
faster/better than a simple 'create if not exists'. A catalog scan is
basically boils down to a query. So I'm not sure that actually helps.
On the other hand, if the temp table can be completely ditched for a
session variable or two, then yeah, that would be much better since
you'd avoid the overhead of creating the table completely.
merlin