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