AI Rumman <rummandba@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
