Re: query hangs

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: query hangs
Дата
Msg-id 4C15FDC1020000250003228B@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: query hangs  (AI Rumman <rummandba@gmail.com>)
Список pgsql-performance
AI Rumman <rummandba@gmail.com> wrote:

> [It takes a long time to return 2.6 million rows.]

> Any more idea, please.

I don't recall you telling us exactly what the environment and
connection type is in which you're trying to return this large
result set.  Any specific suggestions would depend on that
information.

I do wonder why you are returning 2.6 million rows.  A result set
that large is rarely useful directly (except during data conversion
or loading of some sort).  Is there any filtering or aggregation
happening on the client side with the received rows?  If so, my
first suggestion would be to make that part of the query, rather
than part of the client code.

> Is table partition a good solution for query optimization?

Table partitioning is useful in some cases, but you haven't told us
anything yet to indicate that it would help here.

-Kevin

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

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Dead lock
Следующее
От: Elias Ghanem
Дата:
Сообщение: Fwd: Dead lock