Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YLXPs-0001l3-7n for pgsql-performance@arkaria.postgresql.org; Wed, 11 Feb 2015 13:33:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YLXPr-0006W6-Mj for pgsql-performance@arkaria.postgresql.org; Wed, 11 Feb 2015 13:33:19 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YLXPp-0006TC-Tz for pgsql-performance@postgresql.org; Wed, 11 Feb 2015 13:33:18 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YLXPl-0007GE-LY for pgsql-performance@postgresql.org; Wed, 11 Feb 2015 13:33:16 +0000 Received: from calvados.home ([175.143.73.193]) by mail.gmx.com (mrgmx002) with ESMTPSA (Nemesis) id 0LdHqj-1Xv2Qu23VZ-00iSPK; Wed, 11 Feb 2015 14:33:09 +0100 Message-ID: <54DB5A11.3030700@gmx.net> Date: Wed, 11 Feb 2015 14:33:05 +0100 From: =?UTF-8?B?VG9yc3RlbiBGw7ZydHNjaA==?= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: Sathish Nelson , pgsql-performance@postgresql.org Subject: Re: slow query References: In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:1haUh33i/AlJRPYUJAwI4wnB4fsdywk5LcJ65ITxHFnaK7Z/87n nSf9F0luo8GDWZEhKxnEpc8IC7bJiOfmjjI7hJvUbLFmrCUa+I+sHbQCBGgp83BL3ZptrI2 PehL7Tk3sT19jqZdwiESIG5h52ptPfUPRuC5lTd87vJuLL/8+/3/i3Sl0F7e5ynzAzTtDab UpO2f3eR6rayjT7u+rjJg== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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