Re: Postgres Replaying WAL slowly

Поиск
Список
Период
Сортировка
От Soni M
Тема Re: Postgres Replaying WAL slowly
Дата
Msg-id CAAMgDXnOKzSSUkntcLCDpe_fOu7MmEQ7AUaSTAPUaU5bph7c4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres Replaying WAL slowly  (Soni M <diptatapa@gmail.com>)
Список pgsql-performance
Here's some data from standby (this is when replaying take 44seconds per wal files):

2014-06-29 00:07:36.513 CDT,,,16682,,53af6f46.412a,44,,2014-06-28 20:43:34 CDT,,0,LOG,00000,"restartpoint complete: wrote 63187 buffers (3.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=209.170 s, sync=0.482 s, total=209.667 s; sync files=644, longest=0.036 s, average=0.000 s",,,,,,,,,""
2014-06-29 00:07:36.513 CDT,,,16682,,53af6f46.412a,45,,2014-06-28 20:43:34 CDT,,0,LOG,00000,"recovery restart point at 27CE/170056A8","last completed transaction was at log time 2014-06-27 13:39:00.542624-05",,,,,,,,""
2014-06-29 00:28:59.678 CDT,,,16682,,53af6f46.412a,47,,2014-06-28 20:43:34 CDT,,0,LOG,00000,"restartpoint complete: wrote 70942 buffers (3.4%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=209.981 s, sync=0.493 s, total=210.486 s; sync files=723, longest=0.156 s, average=0.000 s",,,,,,,,,""
2014-06-29 00:28:59.678 CDT,,,16682,,53af6f46.412a,48,,2014-06-28 20:43:34 CDT,,0,LOG,00000,"recovery restart point at 27CE/35002678","last completed transaction was at log time 2014-06-27 13:42:05.121121-05",,,,,,,,""

--
Regards,

Soni Maula Harriz

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

Предыдущее
От: Soni M
Дата:
Сообщение: Re: Postgres Replaying WAL slowly
Следующее
От: Emre Hasegeli
Дата:
Сообщение: Re: GIST optimization to limit calls to operator on sub nodes