X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0A459528E7 for ; Thu, 9 Jun 2005 03:58:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78428-06 for ; Thu, 9 Jun 2005 06:58:30 +0000 (GMT) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id 758FB528D9 for ; Thu, 9 Jun 2005 03:58:28 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1DgGuk-0000lX-0t for pgsql-sql@postgresql.org; Thu, 09 Jun 2005 08:53:18 +0200 Received: from gateway.mgm-edv.de ([212.18.1.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 09 Jun 2005 08:53:18 +0200 Received: from spam_eater by gateway.mgm-edv.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 09 Jun 2005 08:53:18 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: SELECT very slow Date: Thu, 09 Jun 2005 08:56:54 +0200 Lines: 24 Message-ID: References: <27961.1118275606@sss.pgh.pa.us> <42A797B5.3060300@pobox.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: gateway.mgm-edv.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT; rv:1.7.6) Gecko/20050319 Mnenhy/0.7.2.0 X-Accept-Language: de, de-at, en-us, en In-Reply-To: <42A797B5.3060300@pobox.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.292 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/127 X-Sequence-Number: 21728 On 09.06.2005 03:13 Alain wrote: > > > Tom Lane escreveu: > >> Thomas Kellerer writes: >> >>> Is there anything I can do, to convince PG to return the first row >>> more quickly? > > > Are you now looking for the LIMIT ? > > SELECT * FROM table LIMIT 1; > > and when when you wnat the rest of it: > > SELECT * FROM table OFFSET 1; > No I want the whole result. Thomas