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.
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 |