Sathish Nelson <satson.csc17@gmail.com> writes:
> 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
Increasing work_mem would make those sort steps faster ...
regards, tom lane