temporary tables ?

Поиск
Список
Период
Сортировка
Искать
От
Zlatko Matic
Тема
temporary tables ?
Дата
Msg-id
004501c58ee6$85a20fa0$d58a1dc3@zlatkovyfkpgz6
Список
Дерево обсуждения
Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Martijn van Oosterhout <kleptog@svana.org>
Re: Query planner refuses to use index Janning Vygen <vygen@gmx.de>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Michael Fuhr <mike@fuhr.org>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Michael Fuhr <mike@fuhr.org>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
Re: Query planner refuses to use index Tom Lane <tgl@sss.pgh.pa.us>
Re: Query planner refuses to use index Kilian Hagemann <hagemann1@egs.uct.ac.za>
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 ?
What would be advantage of temporary tables?
Would database grow less if I implement temporary tables (less need for 
vacuum ?), in comparison to my current solution with true table with rows 
for every user ?

Zlatko 

В списке pgsql-general по дате отправления
От: Steve Crawford
Дата:
От: Sean Davis
Дата:
Сообщение: Re: temporary tables ?
FAQ