Re: temporary tables ?

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