Re: How to tame a gigantic (100+ lines) query in a web app? - Mailing list pgsql-general

From Sim Zacks
Subject Re: How to tame a gigantic (100+ lines) query in a web app?
Date
Msg-id 4E48D9B7.3040007@compulab.co.il
Whole thread Raw
In response to How to tame a gigantic (100+ lines) query in a web app?  ("W. Matthew Wilson" <matt@tplus1.com>)
List 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 by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Postgres on SSD
Next
From: Vincent de Phily
Date:
Subject: altering foreign key without a table scan