Re: Postgres performance issue

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Junaid Malik <junaid(dot)malik(at)confiz(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgres performance issue
Date: 2017-05-08 18:50:41
Message-ID: CAOR=d=3-Y7Hvv6v0H7GZzJ5Ow=1z3OxhwZ4tGt5dM4STJdmNPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, May 4, 2017 at 8:10 AM, Junaid Malik <junaid(dot)malik(at)confiz(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hans Braxmeier 2017-05-08 20:23:14 Postgres uses too much RAM
Previous Message Scott Marlowe 2017-05-08 18:48:29 Re: Speed differences between two servers