From: Ian Harding <ianh@tpchd.org>
To: pgsql-sql@postgresql.org
Subject: Re: Temporary tables and indexes
Date: Tue, 08 Oct 2002 09:13:23 -0700
Message-ID: <sda2a224.029@mail.tpchd.org> (raw)
Sure there is! There are queries that benefit from having a temporary table created for a subquery and the temporary table indexed before the join. Since we can't easily return result sets from functions yet, it's not probably used that much, but from within a function, I can see why you might want to do this from time to time.
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
iharding@tpchd.org
WWSD - What Would Scooby Doo?
>>> "Josh Berkus" <josh@agliodbs.com> 10/08/02 08:36AM >>>
Ludwig,
> Are the indices of a temporary table automatically
> "dropped" together its corresponding temporary table
> after a database session?
I'm kind of surprised that it's possible to index a temporary table.
There's not much point in doing so.
Yes, the indexes would be dropped as well.
-Josh Berkus
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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: ianh@tpchd.org
Subject: Re: Temporary tables and indexes
In-Reply-To: <sda2a224.029@mail.tpchd.org>
* 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