Re: temporary tables ? - Mailing list pgsql-general

From Zlatko Matic
Subject Re: temporary tables ?
Date
Msg-id 004501c59034$3d8c2120$3d8b1dc3@zlatkovyfkpgz6
Whole thread Raw
In response to Query planner refuses to use index  (Kilian Hagemann <hagemann1@egs.uct.ac.za>)
Responses pg_resetxlog question
List pgsql-general
Thanks for explaination.
Zlatko

----- Original Message -----
From: "Sean Davis" <sdavis2@mail.nih.gov>
To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
Cc: "pgsql list" <pgsql-general@postgresql.org>
Sent: Sunday, July 24, 2005 1:27 AM
Subject: Re: [GENERAL] 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.
>>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 frequent updates
Next
From: Andrew Rawnsley
Date:
Subject: pg_resetxlog question