Re: MusicBrainz postgres performance issues

Поиск
Список
Период
Сортировка
От Josh Krupka
Тема Re: MusicBrainz postgres performance issues
Дата
Msg-id CAB6McgXxZdD6yuYRLg4tgDdhqzXKLs63aV+S_nOfZ9arSXUAhA@mail.gmail.com
обсуждение исходный текст
Ответ на MusicBrainz postgres performance issues  (Robert Kaye <rob@musicbrainz.org>)
Ответы Re: MusicBrainz postgres performance issues
Список pgsql-performance
It sounds like you've hit the postgres basics, what about some of the linux check list items?

what does free -m show on your db server?

If the load problem really is being caused by swapping when things really shouldn't be swapping, it could be a matter of adjusting your swappiness - what does cat /proc/sys/vm/swappiness show on your server?

There are other linux memory management things that can cause postgres and the server running it to throw fits like THP and zone reclaim.  I don't have enough info about your system to say they are the cause either, but check out the many postings here and other places on the detrimental effect that those settings *can* have.  That would at least give you another angle to investigate.

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

Предыдущее
От: Robert Kaye
Дата:
Сообщение: MusicBrainz postgres performance issues
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: MusicBrainz postgres performance issues