Re: unlogged tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: unlogged tables
Дата
Msg-id 29798.1291761094@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Dec 7, 2010 at 3:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think a more relevant question is how complicated it'll be to issue
>> those fsyncs --- do you have a concrete implementation in mind?

> It can reuse most of the infrastructure we use for re-initializing
> everything after a crash or unclean shutdown.  We just iterate over
> every tablepace/dbspace directory and look for files with _init forks.
>  If we find any then we open the main fork files and fsync() each one.

I assume you meant "all the other fork files", but OK.  Still, couldn't
that be rather expensive in a large DB?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Final(?) proposal for wal_sync_method changes
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Final(?) proposal for wal_sync_method changes