Sathish Nelson 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
--
Sent
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, th