Re: [PERFORM] Postgres performance issue

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: [PERFORM] Postgres performance issue
Дата
Msg-id CAOR=d=3-Y7Hvv6v0H7GZzJ5Ow=1z3OxhwZ4tGt5dM4STJdmNPg@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Postgres performance issue  (Junaid Malik <junaid.malik@confiz.com>)
Список pgsql-performance
On Thu, May 4, 2017 at 8:10 AM, Junaid Malik <junaid.malik@confiz.com> wrote:
> Hello Guys,
>
> We are facing problem related to performance of Postgres. Indexes are not
> being utilized and Postgres is giving priority to seq scan. I read many
> articles of Postgres performance and found that we need to set the
> randome_page_cost value same as seq_page_cost because we are using SSD
> drives. We are running copy of Discourse forum, you can read more about
> Discourse here meta.discourse.org. Details of all Server hardware and
> Postgres version are given below.

Just wondering if you've made any progress on this. If you get stuck
let us all know and somebody'll help out.


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: [PERFORM] Speed differences between two servers
Следующее
От: Hans Braxmeier
Дата:
Сообщение: [PERFORM] Postgres uses too much RAM