Re: CREATE DATABASE vs delayed table unlink

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: CREATE DATABASE vs delayed table unlink
Дата
Msg-id 48EDDF2E.7080909@enterprisedb.com
обсуждение исходный текст
Ответ на CREATE DATABASE vs delayed table unlink  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: CREATE DATABASE vs delayed table unlink  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Matthew Wakeling wrote:
>> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>>> Another thought is to ignore ENOENT in copydir.
> 
> On Wed, 8 Oct 2008, Tom Lane wrote:
>> Yeah, I thought about that too, but it seems extremely dangerous ...
> 
> I agree. If a file randomly goes missing, that's not an error to ignore, 
> even if you think the only way that could happen is safe.

I committed a patch to do a full-blown checkpoint before the copy. 
Annoying to do two checkpoints, but CREATE DATABASE is a pretty 
heavy-weight operation anyway. I don't see any other solution at the 
moment, at least not one that we could back-patch.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: CREATE DATABASE vs delayed table unlink
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: [WIP] Reduce alignment requirements on 64-bit systems.