Re: [PERFORM] slow query

2015-02-11 Thread Torsten Förtsch 
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

Re: [PERFORM] slow query

2015-02-11 Thread Tom Lane 
Sathish Nelson satson.cs...@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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance