Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EFCDA475D70 for ; Wed, 8 Jan 2003 11:04:31 -0500 (EST) Received: from rs-pi.com (unknown [193.95.196.91]) by postgresql.org (Postfix) with ESMTP id 5CABA475CA6 for ; Wed, 8 Jan 2003 11:04:31 -0500 (EST) Received: from spot (fw.rs-pi.com [193.95.196.154]) by rs-pi.com (Postfix) with SMTP id B25F3AF40 for ; Wed, 8 Jan 2003 17:10:24 +0100 (CET) Message-ID: <024d01c2b72f$a6a7dcc0$1100a8c0@rspi> From: "Nikola Ivacic" To: Subject: count(*) optimization Date: Wed, 8 Jan 2003 17:04:40 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_024A_01C2B738.08556160" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/100 X-Sequence-Number: 10965 This is a multi-part message in MIME format. ------=_NextPart_000_024A_01C2B738.08556160 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi I have trouble executing count(*) statement. On a large dataset it takes quite a while to return result. Is there any other way to get number of tupples in relation=20 or is the only way to optimize count() function to index it?=20 thanks Nikola ------=_NextPart_000_024A_01C2B738.08556160 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
Hi
 
I have trouble executing count(*)=20 statement.
On a large dataset it takes quite a while = to return=20 result.
Is there any other way to get number of tu= pples in=20 relation
or is the only way to optimize count(= )=20 function to index it? 
 
thanks
 
Nikola
------=_NextPart_000_024A_01C2B738.08556160--