Re: Slow response to my query

--000000000000807fa2059864e086
Content-Type: text/plain; charset="UTF-8"

Thanks Jean-Yves,
I will install pgbench and revert.
however, do you have ant specific test to run with the pgbench?

I have about 6 of my columns indexed.

I will share the test query once i got the queries from the UI man.

Regards

On Thu, Nov 28, 2019 at 5:42 AM Bzzzz <[email protected]> wrote:

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

--000000000000807fa2059864e086
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Thanks Jean-Yves,</div><div>I will install pgbench an=
d revert.</div><div>however, do you have ant specific test to run with the =
pgbench?</div><div><br></div><div>I have about 6 of my columns indexed.</di=
v><div><br></div><div>I will share the test query once i got the queries fr=
om the UI man.</div><div><br></div><div>Regards<br></div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Nov 28, 20=
19 at 5:42 AM Bzzzz &lt;<a href=3D"mailto:[email protected]">lazyvirus@gmx.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x">On Thu, 28 Nov 2019 05:35:44 +0100<br>
Goke Aruna &lt;<a href=3D"mailto:[email protected]" target=3D"_blank">goksie=
@gmail.com</a>&gt; wrote:<br>
<br>
Hi,<br>
<br>
&gt; I have a HP DL380 server=C2=A0 g8 with 32GB RAM and 48 *2.5Ghz CPU. Ru=
nning<br>
&gt; on CentOS Linux 7.4.<br>
&gt;<br>
&gt; I have a postgresql 12 database. One of my tables has 42 columns and<b=
r>
&gt; has about 500million records.<br>
&gt; However, any attempt to select even 1 column from the table take hours=
<br>
&gt; at least 1.5hours to respond.<br>
<br>
Did you test your installation with pgbench?<br>
<br>
&gt; Kindly help on documentation on how to optimize it to return the<br>
&gt; response in milliseconds.<br>
<br>
Do you have any indexes?<br>
<br>
What is your test query?<br>
<br>
Jean-Yves<br>
</blockquote></div>

--000000000000807fa2059864e086--