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