Re: [HACKERS] Checkpoint request failed on version 8.2.1.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Дата
Msg-id 15400.1168925362@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Checkpoint request failed on version 8.2.1.  ("Takayuki Tsunakawa" <tsunakawa.takay@jp.fujitsu.com>)
Список pgsql-general
"Takayuki Tsunakawa" <tsunakawa.takay@jp.fujitsu.com> writes:
> BTW, why does the bgwriter try to open and write the pages of already
> dropped relations?

It does not; the problem is with stale fsync requests.

> If the relation being dropeed has
> already been registered in the list of files to be fsynced, isn't it
> possible to remove the file from the list before unlinking the file,
> asking bgwriter in a similar way as ForwardFsyncRequest()?

I suggested that here
http://archives.postgresql.org/pgsql-hackers/2007-01/msg00642.php
but have received no feedback about it ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Improve Postgres Query Speed
Следующее
От: Aleksander Kmetec
Дата:
Сообщение: Custom index type for indexing long texts?