Sathish Nelson <satson.csc17@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
