Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C98AC9FC2B3 for ; Fri, 18 May 2007 10:15:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 97340-09 for ; Fri, 18 May 2007 10:15:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web56406.mail.re3.yahoo.com (web56406.mail.re3.yahoo.com [216.252.111.85]) by postgresql.org (Postfix) with SMTP id BF5DD9FC2CB for ; Fri, 18 May 2007 10:15:27 -0300 (ADT) Received: (qmail 36131 invoked by uid 60001); 18 May 2007 13:15:26 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=MBReJuP20RAsPsfBpkOTyYbYh/KtIBx/1AGOxcjG9IMy78CwWL4ZzPYw/xO9GjKWAxUCxdpAreL5QmX72GE+yTUu5GI5a3LDTogsGutlxxivuAEZASgjJwSvBWKenbfQ7aQN9D7acOyiZIvlhmasX0LJvB8FxJmPrmLuCX7AQv0=; X-YMail-OSG: 9FrJZ7QVM1mMUhGqRuuCaHhuYtahT4PpIDoF8gehPoqNomGFkZEOkEm9XY6vVcIRyHW8leT0YIfJhdGGYD6Zgv1av_oHLlCxHxEpBVU098_FjHLZEJSlgUerJS6UOzw- Received: from [198.119.134.32] by web56406.mail.re3.yahoo.com via HTTP; Fri, 18 May 2007 06:15:25 PDT Date: Fri, 18 May 2007 06:15:25 -0700 (PDT) From: Jessica Richard Subject: select count(*) from a large table is very slow To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-304417302-1179494125=:35849" Content-Transfer-Encoding: 8bit Message-ID: <133912.35849.qm@web56406.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.257 tagged_above=0 required=5 tests=AWL=-2.855, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200705/181 X-Sequence-Number: 25501 --0-304417302-1179494125=:35849 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have a ~30 milliow row table, select count(*) from this table is very very very slow... How dow I get it run faster? Thanks, Jessica --------------------------------- We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. --0-304417302-1179494125=:35849 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have a ~30 milliow row table, select count(*) from this table is very very very slow...

How dow I get it run faster?

Thanks,
Jessica


We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list. --0-304417302-1179494125=:35849--