Temporary table instead of repeated joins

From: Chantal Ackermann <chantal(dot)ackermann(at)web(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Temporary table instead of repeated joins
Date: 2002-07-02 12:48:50
Message-ID: 3D21A132.4070608@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hello all,

in my program I have to check for a certain combination of data before I
make an insert. The check is a select statement with a join and a
function call. Now, I wonder if I could gain performance if I would
create a temporary view that contained this join and the function call
and the other constraints. There will be frequent inserts into the
underlying tables so I can't use a real cache that is only updated once
in a while (say, a temporary table).

So would a select on the view be faster or is the view really just some
shortcut for the programmer but the database behaviour actually stays
the same?

Thanks for any hints
Chantal

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-07-02 13:57:09 Re: CASE Select, referring to selected value
Previous Message Achilleus Mantzios 2002-07-02 12:16:53 Re: CASE Select, referring to selected value