Re: How to tame a gigantic (100+ lines) query in a web app?
| От | Sim Zacks |
|---|---|
| Тема | Re: How to tame a gigantic (100+ lines) query in a web app? |
| Дата | |
| Msg-id | 4E48D9B7.3040007@compulab.co.il обсуждение исходный текст |
| Ответ на | How to tame a gigantic (100+ lines) query in a web app? ("W. Matthew Wilson" <matt@tplus1.com>) |
| Список | pgsql-general |
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
body p { margin-bottom: 0cm; margin-top: 0pt; }
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#ffffff"
text="#000000">
On 08/14/2011 05:39 PM, W. Matthew Wilson wrote:
<blockquote
cite="mid:CAGHfCUDQc8RywD1_qa1_d3K3pFA5mGa4y5dyWh+ysdAgAgzfPg@mail.gmail.com"
type="cite">
Is there anything dangerous about making temporary tables in this way?
Matt
The only dangerous thing I have encountered with temp tables is
that the planner compiles the table oid into the plan and if you
run a function after the table has been dropped and recreated it
will tell you that the table doesn't exist. This is from 8.2 and
lower, I haven't checked if this is still a problem in more recent
versions.
Sim
В списке pgsql-general по дате отправления: