Re: State of Beta 2
От | Vivek Khera |
---|---|
Тема | Re: State of Beta 2 |
Дата | |
Msg-id | 16240.34305.34558.91056@yertle.int.kciLink.com обсуждение исходный текст |
Ответ на | Re: State of Beta 2 ("Marc G. Fournier" <scrappy@postgresql.org>) |
Ответы |
Re: State of Beta 2
Re: State of Beta 2 |
Список | pgsql-general |
>>>>> "MGF" == Marc G Fournier <scrappy@postgresql.org> writes: MGF> I've tried restoring a >5gig database with sort_mem up to 100Meg in size, MGF> and didn't find that it sped up the index creation enough to make a MGF> difference ... shaved off a couple of minutes over the whole reload, so MGF> seconds off of each index ... and that was with the WAL logs also disabled MGF> :( Ditto for me. Can you reproduce my results by increasing checkpoint_buffers to some large value (I use 50)? this shaved something like 60 minutes off of my restore.
В списке pgsql-general по дате отправления: