Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL
Дата
Msg-id 878x9x6dri.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Ответы Re: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL
Список pgsql-hackers
"Pavel Stehule" <pavel.stehule@gmail.com> writes:

> Global temp table can be created from template only when is used. It's
> has not negative efect on app which doesn't use it. The benefit of
> g.t.t. is simplifycation of stored procedures.

And if it's used in 200 txns/s? Imagine the earlier poster who was looking for
a way to display the count of records matching a search followed by the ten
records on the page without re-executing the search.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Proposal: In-Place upgrade concept
Следующее
От: Michael Paesold
Дата:
Сообщение: Re: Still recommending daily vacuum...