From: Pawel Pierscionek <pawel@astercity.net>
To: pgsql-sql <pgsql-sql@postgreSQL.org>
Subject: Temporary tables
Date: Mon, 11 Jan 1999 23:39:11 +0100
Message-ID: <19985.990111@astercity.net> (raw)
Hi,
I have to play a lot with temp tables.
Could you pls, give me a hint on emulating them under Postgres.
I have to use them quite often and with 10000 rows each.
I don't use indices cause I only cache a search result and don't need
any sorting, searching on temptables.
What's faster:
1)
once:
create tmptable;
many times:
delete from tmptable;
insert into tmptable select ... ;
or
2)
many times:
drop tmptable;
select ... into tmptable;
I prefer the second way since I have a lot of concurrent access and
create unique named tables under each transaction.
Unfortunately the DROP thing dumps a core under PLPGSQL function. :(
TIA,
Pawel
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: pawel@astercity.net
Subject: Re: Temporary tables
In-Reply-To: <19985.990111@astercity.net>
* 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