Re: Slow response to my query

Bzzzz <[email protected]> Thu, 28 Nov 2019 05:42:13 +0100

Newsgroups	gmane.comp.db.postgresql.novice
Organization	Anyone, anywhere BUT in banana demokratik republik of france and UERSS.
Message-ID	<[email protected]>

On Thu, 28 Nov 2019 05:35:44 +0100
Goke Aruna <[email protected]> wrote:

Hi,

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

Did you test your installation with pgbench?

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

Do you have any indexes?

What is your test query?

Jean-Yves