From: Chantal Ackermann <chantal.ackermann@web.de>
To: pgsql-sql@postgresql.org
Subject: Temporary table instead of repeated joins
Date: Tue, 02 Jul 2002 14:48:50 +0200
Message-ID: <3D21A132.4070608@web.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chantal.ackermann@web.de
Subject: Re: Temporary table instead of repeated joins
In-Reply-To: <3D21A132.4070608@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox