Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 620D32E0125 for ; Tue, 22 Jan 2008 16:21:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 73299-02-2 for ; Tue, 22 Jan 2008 16:20:56 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 90EBF2E02AB for ; Tue, 22 Jan 2008 16:19:30 -0400 (AST) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m0MKJR7t021069 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 22 Jan 2008 12:19:28 -0800 Date: Tue, 22 Jan 2008 12:19:21 -0800 From: "Joshua D. Drake" To: "Luiz K. Matsumura" Cc: pgsql-performance@postgresql.org Subject: Re: SELECT * FROM table is too slow Message-ID: <20080122121921.302c52f4@commandprompt.com> In-Reply-To: <479647A1.6010101@planit.com.br> References: <47656FC5.8060102@wooh.hu> <47657068.5070200@commandprompt.com> <479647A1.6010101@planit.com.br> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 22 Jan 2008 12:19:28 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/182 X-Sequence-Number: 28421 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBUdWUs IDIyIEphbiAyMDA4IDE3OjQ0OjMzIC0wMjAwDQoiTHVpeiBLLiBNYXRzdW11cmEiIDxsdWl6QHBs YW5pdC5jb20uYnI+IHdyb3RlOg0KDQo+ID4NCj4gDQo+IEpvc2h1YSBELiBEcmFrZSB3cm90ZTpI aSwNCj4gDQo+IElmIHdlIHJ1biB0aGUgY29tbWFuZHMgInZhY3VtbSBmdWxsIGFuYWx5emUiIGFu ZCAicmVpbmRleCB0YWJsZSIsDQo+IHRoaXMgY2FuIGJlIGNvbnNpZGVyZWQgYXMgZXF1aXZhbGVu dCB0byBtYWtpbmcgYSBkdW1wIC8gcmVzdG9yZSBpbg0KPiB0aGlzIGNhc2UgPw0KDQpZZXMuIA0K DQpKb3NodWEgRC4gRHJha2UNCg0KLSAtLSANClRoZSBQb3N0Z3JlU1FMIENvbXBhbnk6IFNpbmNl IDE5OTcsIGh0dHA6Ly93d3cuY29tbWFuZHByb21wdC5jb20vIA0KU2FsZXMvU3VwcG9ydDogKzEu NTAzLjY2Ny40NTY0ICAgMjR4Ny9FbWVyZ2VuY3k6ICsxLjgwMC40OTIuMjI0MA0KRG9uYXRlIHRv IHRoZSBQb3N0Z3JlU1FMIFByb2plY3Q6IGh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvYWJvdXQv ZG9uYXRlDQpTRUxFQ1QgJ1RyYWluaW5nJywgJ0NvbnN1bHRpbmcnIEZST00gdmVuZG9yIFdIRVJF IG5hbWUgPSAnQ01EJw0KDQoNCi0tLS0tQkVHSU4gUEdQIFNJR05BVFVSRS0tLS0tDQpWZXJzaW9u OiBHbnVQRyB2MS40LjYgKEdOVS9MaW51eCkNCg0KaUQ4REJRRkhsay9MQVRiL3pxZlpVVVFSQXVh MEFLQ3Nacldya2YwZCtqS1VhOUtLM2FUcXp1WlRaQUNiQmlENQ0KejNhSXN3Y2dSU3d5d3hsaEQr ZGdTSEU9DQo9dmRlUQ0KLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0tDQo=