Re: [PERFORM] Postgres performance issue - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: [PERFORM] Postgres performance issue
Date
Msg-id CAOR=d=3-Y7Hvv6v0H7GZzJ5Ow=1z3OxhwZ4tGt5dM4STJdmNPg@mail.gmail.com
Whole thread Raw
In response to [PERFORM] Postgres performance issue  (Junaid Malik <junaid.malik@confiz.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [PERFORM] Speed differences between two servers
Next
From: Hans Braxmeier
Date:
Subject: [PERFORM] Postgres uses too much RAM