Jayadevan M wrote: >> And the schema of the tables involved, and any indexes on them. > The details of the tables and indexes may take a bit of effort to > explain. Will do that. In psql you can do \d to get a decent summary. Without seeing the query and the table definitions, it's hard to give advice; especially when a sort step increases the number of rows. I'm guessing there is incorrect usage of some set-returning function. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
