Temporary tables

From: Pawel Pierscionek <pawel(at)astercity(dot)net>
To: pgsql-hacers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Temporary tables
Date: 1999-01-19 18:57:35
Message-ID: 3831.990119@astercity.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've already asked on pgsql-general but there was now answer so I'll
try here.

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 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-01-19 20:46:11 Re: [HACKERS] KPGsql
Previous Message John Holland 1999-01-19 16:29:35 Re: [HACKERS] Postgres Speed or lack thereof