Re: Proposal of PITR performance improvement for 8.4.
От | Simon Riggs |
---|---|
Тема | Re: Proposal of PITR performance improvement for 8.4. |
Дата | |
Msg-id | 1225193937.3971.162.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Proposal of PITR performance improvement for 8.4. ("Koichi Suzuki" <koichi.szk@gmail.com>) |
Ответы |
Re: Proposal of PITR performance improvement for 8.4.
|
Список | pgsql-hackers |
On Tue, 2008-10-28 at 16:33 +0900, Koichi Suzuki wrote: > This is my first proposal of PITR performance improvement for > PostgreSQL 8.4 development. This proposal includes readahead > mechanism of data pages which will be read by redo() routines in the > recovery. This is especially effective in the recovery without full > page write. Readahead is done by posix_fadvise() as proposed in > index scan improvement. > > Details of the implementation will be found in README file in the material. I'm happy with the idea of a readahead process. I thought we were implementing a BackgroundReader process for other uses. Is that dead now? I see you're doing this as a standalone command. Shame we can't include this into core for now, but I can see the reasons why. How does the whole toolchain look with this? Can you give a simple example of using pg_lesslog, pg_readahead and pg_standby together, if that is appropriate? -- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: