Re: How about a proper TEMPORARY TABLESPACE?

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: How about a proper TEMPORARY TABLESPACE?
Дата
Msg-id CAJghg4KJ_QhicSpJauwMLnFi5E9m=Nnd4TvmAyRrW04yOwf=VA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How about a proper TEMPORARY TABLESPACE?  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Ответы Re: How about a proper TEMPORARY TABLESPACE?
Re: How about a proper TEMPORARY TABLESPACE?
Re: How about a proper TEMPORARY TABLESPACE?
Список pgsql-hackers
Дерево обсуждения
Hi Hackers,

I have worked on that patch a little more. So now I have functional patch (although still WIP) attached. The feature works as following:

- Added a boolean parameter "only_temp_files" to pg_tablespace.spcoptions;
- This parameter can be set to true only during CREATE TABLESPACE, not on ALTER TABLESPACE (I have thought of ways of implementing the latter, and I'd like to discuss it more latter);
- On the creation of relations, it is checked if it is a temporary-tablespace, and an error occurs when it is and the relation is not temporary (temp table or index on a temp table);
- When a temporary file (either relation file or sort/agg file) is created inside a temporary-tablespace, the entire directories structure is created on-demand (e.g. if pg_tblspc/<oid>/<TABLESPACE_VERSION_DIRECTORY> is missing, it is created on demand) it is done on OpenTemporaryFileInTablespace, at fd.c (I wonder if shouldn't we do that for any tablespace) and on TablespaceCreateDbspace, at tablespace.c.

I still haven't change documentation, as I think I need some insights about the changes. I have some more thoughts about the syntax and I still think that "TEMP LOCATION" syntax is better suited for this patch. First because of the nature of the changes I made, it seems more suitable to a column on pg_tablespace rather than an option. Second because no ALTER is available (so far) and I think it is odd to have an option that can't be changed. Third, I think "TEMP" keyword is more clear and users can be more used to it.

Thoughts?

I'm going to add the CF app entry next. Could I get some review now or after discussion about how things are going (remember I'm a newbie on this, so I'm a little lost)?

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Вложения

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