Re: [GENERAL] Vacuum and state_change

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [GENERAL] Vacuum and state_change
Дата
Msg-id d6e0d57a-fb1a-0a62-4ce4-b5f838fb20ef@aklaver.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Vacuum and state_change  (armand pirvu <armand.pirvu@gmail.com>)
Ответы Re: [GENERAL] Vacuum and state_change
Список pgsql-general
On 06/09/2017 02:01 PM, armand pirvu wrote:
>
>> On Jun 9, 2017, at 3:52 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> On 06/09/2017 01:31 PM, armand pirvu wrote:
>>
>>>>


> By temporary tables I mean just regular table not tables created by "create temporary table" . I should have been
moreprecise. We call them temporary since we do drop them after all is said and done. Maybe we should change the way we
callthem 

You will want to look at this before making that decision:

https://www.postgresql.org/docs/9.6/static/sql-createtable.html

Temporary Tables


Basically, temporary tables are session specific.


>
> 9.5 but considering I can track what auto vacuum does I was thinking to use that as a reason to the upgrade advantage

It is nice, you just have to weigh against what effect the other changes:

https://www.postgresql.org/docs/9.6/static/release-9-6.html

might have on your setup.



--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: [GENERAL] Limiting DB access by role after initial connection?
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: [GENERAL] Limiting DB access by role after initial connection?