Skip site navigation (1) Skip section navigation (2)

Re: how to call sql code without function

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: giuseppe(dot)derossi(at)email(dot)it
Cc: "Medi Montaseri" <montaseri(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: how to call sql code without function
Date: 2007-08-21 15:30:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On 8/21/07, giuseppe(dot)derossi(at)email(dot)it <giuseppe(dot)derossi(at)email(dot)it> wrote:
> Hi Medi,
> Last night, I wrote a function which perfoms a subset of queries and returns
> the results of a temporary table. It's more fast than I believe and that's
> ok to me.
> There is a prolem : It works too fine. I'm afraid of Murphy's law. I red
> into the Internet that there are problem when there is a temporary table in
> a function. My queries are in direct way, that is, without Execute
> statement.
> What kind of problem can arise (session,caching, and so on) ? which should
> be the solution ?

The only real danger of using temp tables is that if you don't vacuum
often enough the system catalogs can get bloated.  Also, if you create
a new connection for each access, then you might wind up with a lot of
pg_temp_xxx schemas laying about, but they don't really hurt anything.
 Generally speaking temp tables in postgresql are pretty well behaved.

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2007-08-21 15:33:38
Subject: Re: How to export query results
Previous:From: Kevin GrittnerDate: 2007-08-21 14:57:39
Subject: Re: Dump & Load a database???

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group