Postgres Pro
Downloads
Home   >   mailing lists

Slow response to my query - Mailing list pgsql-novice

From Goke Aruna
Subject Slow response to my query
Date
Msg-id CAE=DitppHwWXa9MOe3JXnc2av2K_TJPM1sNTSwf=zmmS79yfOA@mail.gmail.com
Whole thread Raw
List pgsql-novice
Tree view
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


pgsql-novice by date:

Previous
From: Yessica Brinkmann
Date:
Subject: Re: CurrentMemoryContext and MemoryContextStrdup
Next
From: Bzzzz
Date:
Subject: Re: Slow response to my query