Re: temporary tables ?
От | Zlatko Matic |
---|---|
Тема | Re: temporary tables ? |
Дата | |
Msg-id | 004501c59034$3d8c2120$3d8b1dc3@zlatkovyfkpgz6 обсуждение исходный текст |
Ответ на | Query planner refuses to use index (Kilian Hagemann <hagemann1@egs.uct.ac.za>) |
Ответы |
pg_resetxlog question
|
Список | 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 по дате отправления: