| From: | Matthias Apitz <guru(at)unixarea(dot)de> |
|---|---|
| To: | Shubham Mittal <mittalshubham30(at)gmail(dot)com> |
| Cc: | Matthias Apitz <guru(at)unixarea(dot)de>, Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Query takes around 15 to 20 min over 20Lakh rows |
| Date: | 2021-09-06 18:26:52 |
| Message-ID: | YTZdbOpGg9gB/0vF@c720-r368166 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El día lunes, septiembre 06, 2021 a las 11:45:34p. m. +0530, Shubham Mittal escribió:
> 20 Lakh is the current no of rows in the task table.. on which the query is
> executed..
Ahh, I never came accross this (Indian) unit 'lakh' and now understand
that we're are talking about https://en.wikipedia.org/wiki/Lakh
and 20 Lakh are only 2.000.000 rows, which isn't a very big number.
Can't help with your query, though.
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
August 13, 1961: Better a wall than a war. And, while the GDR was still existing,
no German troups and bombs have been killed in Yugoslavia, Afghanistan, Afrika...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2021-09-06 19:11:42 | Re: Behavior change in PostgreSQL 14Beta3 or bug? |
| Previous Message | Josef Šimánek | 2021-09-06 18:26:27 | Re: Query takes around 15 to 20 min over 20Lakh rows |