Re: temporary tables ? - Mailing list pgsql-general

From Sean Davis
Subject Re: temporary tables ?
Date
Msg-id 001401c58fde$0eb4f8a0$6401a8c0@WATSON
Whole thread Raw
In response to Query planner refuses to use index  (Kilian Hagemann <hagemann1@egs.uct.ac.za>)
List pgsql-general


> What is the influence on database growing in comparrison to permanent
> table frequently inserted/deleted rows ?

The tables are dropped automatically after the connection is closed.  The
database doesn't grow because of temporary tables.  As for comparison to a
frequently inserted/deleted table, that would depend on the time between
vacuums.  The rows aren't "removed" from a table until a vacuum is
performed.

>> On Jul 22, 2005, at 1:55 PM, Zlatko Matic wrote:
>>
>>> Hello.
>>> I have some tables that are updated by several users in the same time
>>> and are used in queries for reports. Those tables have rows that are
>>> actualy copied from original  tables that are not to be altered. There
>>> is a procedure that inserts rows for every user when connects, along
>>> with his username, so different users can't interfere with each other
>>> because every user has his own copy of rows that he can update, and
>>> records are filtered by current_user.
>>> Well, it's my heritage from MS Access, before I moved to Postgres,
>>> because there is no such thing as temporary table in Access...
>>> Now, I'm wondering is there any true advantage to implement temporary
>>> tables for each user, insted of one table with inserted rows with
>>> username for every user ?
>>
>> Temporary tables are not per-user, but per-connection.  A user can be
>> connected twice, but a temporary table created on one connection is not
>> visible from the other connection.  Also, temporary tables are
>> temporary--they disappear after the connection is closed.
>>
>



pgsql-general by date:

Previous
From: "Zlatko Matic"
Date:
Subject: Re: temporary tables ?
Next
From: Peter Fein
Date:
Subject: Re: Privileges needed by pg_autovacuum?