Re: Postgresql works too slow

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Postgresql works too slow
Дата
Msg-id 42635675.2020309@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Postgresql works too slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
>>Try enabliing your checkpoint_segments. In my example, our database
>>restore took 75mins. After enabling checkpoints_segments to 20, we cut
>>it down to less than 30 minutes.
>
>
> Increasing maintenance_work_mem might help too ... or several other
> settings ... with no information about exactly *what* is slow, it's
> hard to say.

Try turning fsync = false for the duration of your reload.

Chris

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql works too slow
Следующее
От: Nick Trainor
Дата:
Сообщение: UNSUBSCRIBE