On 11/02/15 07:41, Sathish Nelson wrote: > am connecting three tables in query. one table have 73000 records > > another two tables have 138000 records. > > but its take 12 sec for show 12402 rows in tables
you need more work_mem. The query plan shows multiple external sort nodes. Otherwise, the query and the plan I received here are too badly formatted for me to comprehend. Torsten -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
