Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xgxbi-0005Qw-28 for pgsql-performance@arkaria.postgresql.org; Wed, 22 Oct 2014 15:13:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xgxbh-0004Bu-IW for pgsql-performance@arkaria.postgresql.org; Wed, 22 Oct 2014 15:13:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xgxbg-0004Bl-PL for pgsql-performance@postgresql.org; Wed, 22 Oct 2014 15:13:48 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xgxbd-0003Cn-0b for pgsql-performance@postgresql.org; Wed, 22 Oct 2014 15:13:47 +0000 Received: from [192.168.1.27] ([84.58.60.26]) by mail.gmx.com (mrgmx102) with ESMTPSA (Nemesis) id 0LcVOE-1YND6H1T0w-00jufq for ; Wed, 22 Oct 2014 17:13:43 +0200 Message-ID: <5447C9A6.3000107@gmx.de> Date: Wed, 22 Oct 2014 17:13:42 +0200 From: =?ISO-8859-1?Q?Bj=F6rn_Wittich?= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: extremly bad select performance on huge table References: <5446972B.9040409@gmx.de> <9706.1413918462@sss.pgh.pa.us> <5446B4B3.4030802@gmx.de> <54473B2E.2080007@gmx.de> <1413989639.83279.YahooMailNeo@web122306.mail.ne1.yahoo.com> In-Reply-To: <1413989639.83279.YahooMailNeo@web122306.mail.ne1.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:Sl/w0Ux6xFEmbhgJkY9YZlFjbWDN3PnzGnMBz+HU5uyHMlpmvZw qkldBocEWl92qTC0xBmGGartc+dLtYhh3XAT5IRbLISjnO7XmTf1TRfsw+kpnfqGtN4r74Q O+OyY0HleuW4L6EZuwL4DjK3b2qzxsGI/6Jq7WdVkrxlty0ArOrge7pH85HcW4fmpInI0yi EhFR3yw9nDm3zShcX0oew== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -2.4 (--) 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 Hi Kevin, this is what I need (I think). Hopefully a cursor can operate on a join. Will read docu now. Thanks! Björn Am 22.10.2014 16:53, schrieb Kevin Grittner: > Björn Wittich wrote: > >> I do not want the db server to prepare the whole query result at >> once, my intention is that the asynchronous retrieval starts as >> fast as possible. > Then you probably should be using a cursor. > > -- > Kevin Grittner > EDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance