Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 663DE2E0052 for ; Tue, 25 Mar 2008 10:09:56 -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 45727-10 for ; Tue, 25 Mar 2008 10:09:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [202.61.230.242]) by postgresql.org (Postfix) with ESMTP id E4F372E0055 for ; Tue, 25 Mar 2008 10:09:46 -0300 (ADT) Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by www.postnewspapers.com.au (Postfix) with ESMTP id A8CB6D55CA; Tue, 25 Mar 2008 22:09:42 +0900 (WST) Received: from localhost (access [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id E0BBD1E0435; Tue, 25 Mar 2008 22:09:43 +0900 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id qKc1cwun8jFH; Tue, 25 Mar 2008 22:09:41 +0900 (WST) Received: from [203.161.97.213] (203.161.97.213.static.amnet.net.au [203.161.97.213]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTP id 590F91E0434; Tue, 25 Mar 2008 22:09:41 +0900 (WST) Message-ID: <47E8F98E.1040505@postnewspapers.com.au> Date: Tue, 25 Mar 2008 22:09:34 +0900 From: Craig Ringer User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: sathiya psql Cc: pgsql-performance@postgresql.org Subject: Re: what is the maximum number of rows in a table in postgresql 8.1 References: <7be3f35d0803250448h62f47b13mebe0252fca9b90e1@mail.gmail.com> <20080325120101.GC6756@alvh.no-ip.org> <47E8EEF1.40709@postnewspapers.com.au> In-Reply-To: X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/471 X-Sequence-Number: 29425 sathiya psql wrote: > EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ; > And your usual query is: SELECT count(*) from call_log_in_ram; ? If so, you should definitely build a summary table maintained by a trigger to track the row count. That's VERY well explained in the mailing list archives. This was suggested to you very early on in the discussion. If you have problems with other queries, how about showing EXPLAIN ANALYZE for the other queries you're having problems with? -- Craig Ringer