Re: WAL and commit_delay

Поиск
Список
Период
Сортировка
От Matthew Kirkwood
Тема Re: WAL and commit_delay
Дата
Msg-id Pine.LNX.4.10.10102191239300.9444-300000@sphinx.mythic-beasts.com
обсуждение исходный текст
Ответ на Re: WAL and commit_delay  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: WAL and commit_delay  (Matthew Kirkwood <matthew@hairy.beasts.org>)
Re: WAL and commit_delay  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, 18 Feb 2001, Tom Lane wrote:

> I think that there may be a performance advantage to pre-filling the
> logfile even so, assuming that file allocation info is stored in a
> Berkeley/McKusik-like fashion (note: I have no idea what ext2 or
> reiserfs actually do).

ext2 is a lot like [UF]FS.  reiserfs is very different, but does
have similar hole semantics.

BTW, I have attached two patches which streamline log initialisation
a little.  The first (xlog-sendfile.diff) adds support for Linux's
sendfile system call.  FreeBSD and HP/UX have sendfile() too, but the
prototype is different.  If it's interesting, someone will have to
come up with a configure test, as autoconf scares me.

The second removes a further three syscalls from the log init path.
There are a couple of things to note here:* I don't know why link/unlink is currently preferred over  rename.  POSIX
offersstrong guarantees on the semantics  of the latter.* I have assumed that the close/rename/reopen stuff is only
therefor the benefit of Windows users, and ifdeffed it  for everyone else.
 

Matthew.

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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: PHP 4.0.4pl1 / Beta 5
Следующее
От: Sascha Schumann
Дата:
Сообщение: Re: PHP 4.0.4pl1 / Beta 5