Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 16F1A1337B55 for ; Mon, 8 Nov 2010 13:16:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 98615-04 for ; Mon, 8 Nov 2010 17:16:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 8E3FD1337B49 for ; Mon, 8 Nov 2010 13:16:04 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 08 Nov 2010 11:16:03 -0600 Message-Id: <4CD7DBEC02000025000373E2@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Mon, 08 Nov 2010 11:15:56 -0600 From: "Kevin Grittner" To: "Thomas Kellerer" , Subject: Re: Select * is very slow References: <1289197016462-3254568.post@n5.nabble.com> <4CD7D89A02000025000373D8@gw.wicourts.gov> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/106 X-Sequence-Number: 41130 Thomas Kellerer wrote: > Kevin Grittner, 08.11.2010 18:01: >> I would add a request to see the output from `VACUUM VERBOSE >> employee;`. > Do you really think that VACCUM is the problem? If the OP only > selects two columns it is apparently fast. > If he selects all columns it's slow, so I wouldn't suspect dead > tuples here. > > My bet is that there are some really large text columns in > there... That's something we can infer pretty well from the verbose output. -Kevin