| From: | Bzzzz <lazyvirus(at)gmx(dot)com> |
|---|---|
| To: | Goke Aruna <goksie(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org, Babatunde Adeyemi <barbietunnie(at)gmail(dot)com> |
| Subject: | Re: Slow response to my query |
| Date: | 2019-11-28 15:13:19 |
| Message-ID: | 20191128161319.176c199c@msi.defcon1.lan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, 28 Nov 2019 10:38:22 +0100
Goke Aruna <goksie(at)gmail(dot)com> wrote:
> however, do you have ant specific test to run with the pgbench?
Nope, I don't have the man in mind - read it and adapt your test to your
problem.
BTW, you did not say it, but I suppose you're using rust not SSDz?
> I have about 6 of my columns indexed.
Are they involved in your query?
> I will share the test query once i got the queries from the UI man.
? Without the table and it's indexes structures plus the query, it's like
a car without an engine (or a chauffeur)…
Also, read this:
https://hakibenita.com/be-careful-with-cte-in-postgre-sql
and that:
https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/
Jean-Yves
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Pousty | 2019-11-28 16:11:43 | Re: Slow response to my query |
| Previous Message | Goke Aruna | 2019-11-28 09:38:22 | Re: Slow response to my query |