Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 37B262E2F9B for ; Thu, 6 Mar 2008 08:50:24 -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 01947-08 for ; Thu, 6 Mar 2008 08:50:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 807512E2F9A for ; Thu, 6 Mar 2008 08:50:12 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-27-98.bk17-dsl.surnet.cl [190.95.27.98]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m26CnZit021339 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 6 Mar 2008 04:49:38 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 7E7B247BF8; Thu, 6 Mar 2008 09:49:08 -0300 (CLST) Date: Thu, 6 Mar 2008 09:49:08 -0300 From: Alvaro Herrera To: sathiya psql Cc: Dave Cramer , pgsql-performance@postgresql.org Subject: Re: count * performance issue Message-ID: <20080306124908.GG27074@alvh.no-ip.org> References: <20080306060829.GA21084@a-kretschmer.de> <47CF8EA6.8070503@mark.mielke.cc> <20080306063643.GB21084@a-kretschmer.de> <3E9C3A51-C28E-4B75-9739-E344DAC72880@fastcrypt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Thu, 06 Mar 2008 04:49:38 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/115 X-Sequence-Number: 29069 sathiya psql escribió: > > Yes it is the latest stable version. > > is there any article saying the difference between this 7.3 and 8.4 http://www.postgresql.org/docs/8.3/static/release.html In particular, http://www.postgresql.org/docs/8.3/static/release-8-3.html http://www.postgresql.org/docs/8.3/static/release-8-2.html http://www.postgresql.org/docs/8.3/static/release-8-1.html http://www.postgresql.org/docs/8.3/static/release-8-0.html which are all the major releases between 7.4 and 8.3. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.