Slow response to my query

From: Goke Aruna <goksie(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Slow response to my query
Date: 2019-11-28 04:35:44
Message-ID: CAE=DitppHwWXa9MOe3JXnc2av2K_TJPM1sNTSwf=zmmS79yfOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a HP DL380 server g8 with 32GB RAM and 48 *2.5Ghz CPU. Running on
CentOS Linux 7.4.

I have a postgresql 12 database. One of my tables has 42 columns and has
about 500million records.
However, any attempt to select even 1 column from the table take hours at
least 1.5hours to respond.

Kindly help on documentation on how to optimize it to return the response
in milliseconds.

Regards

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bzzzz 2019-11-28 04:42:13 Re: Slow response to my query
Previous Message Yessica Brinkmann 2019-11-26 18:20:15 Re: CurrentMemoryContext and MemoryContextStrdup