Search Postgresql Archives
Re: Query takes around 15 to 20 min over 20Lakh rows
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Query takes around 15 to 20 min over 20Lakh rows
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Thu, 2 Sep 2021 16:27:14 -0600
Cc
: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <CA+ERcR_a-UDe5iomYU+FOK+pmPd=cr1eJFyWVtdrF4HeEyyKkg@mail.gmail.com>
References
: <CA+ERcR_a-UDe5iomYU+FOK+pmPd=cr1eJFyWVtdrF4HeEyyKkg@mail.gmail.com>
What is T and how many rows are in there? How many rows in task_history? What indexes exist? Are you confident you want 2 million rows in that result set? What version is this on? What pg_settings have been changed from defaults?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Query takes around 15 to 20 min over 20Lakh rows
From:
Shubham Mittal
Prev by Date:
Query takes around 15 to 20 min over 20Lakh rows
Next by Date:
Re: Query takes around 15 to 20 min over 20Lakh rows
Previous by thread:
Query takes around 15 to 20 min over 20Lakh rows
Next by thread:
Re: Query takes around 15 to 20 min over 20Lakh rows
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
