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

Поиск
Список
Период
Сортировка
От Matthias Apitz
Тема Re: Query takes around 15 to 20 min over 20Lakh rows
Дата
Msg-id YTZdbOpGg9gB/0vF@c720-r368166
обсуждение исходный текст
Ответ на Re: Query takes around 15 to 20 min over 20Lakh rows  (Shubham Mittal <mittalshubham30@gmail.com>)
Список 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@unixarea.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...



В списке pgsql-general по дате отправления:

Предыдущее
От: Josef Šimánek
Дата:
Сообщение: Re: Query takes around 15 to 20 min over 20Lakh rows
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Behavior change in PostgreSQL 14Beta3 or bug?