Re: Query takes around 15 to 20 min over 20Lakh rows

From: Shubham Mittal <mittalshubham30(at)gmail(dot)com>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: 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:15:34
Message-ID: CA+ERcR8xU-kfGy8Dh4txiNRVaULdyhMD9g9PkcDSL135xJTuow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

20 Lakh is the current no of rows in the task table.. on which the query is
executed..

On Mon, Sep 6, 2021, 11:44 PM Matthias Apitz <guru(at)unixarea(dot)de> wrote:

>
> What does the term 'over 20Lakh rows' mean? Thanks
>
> 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...
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Šimánek 2021-09-06 18:26:27 Re: Query takes around 15 to 20 min over 20Lakh rows
Previous Message Matthias Apitz 2021-09-06 18:14:02 Re: Query takes around 15 to 20 min over 20Lakh rows