Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 82D6A476615
	for <pgsql-hackers@postgresql.org>;
	Wed, 27 Nov 2002 11:59:37 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 98D3B47644C
	for <pgsql-hackers@postgresql.org>;
	Wed, 27 Nov 2002 11:57:01 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gARGv4sX018375;
	Wed, 27 Nov 2002 11:57:04 -0500 (EST)
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com>,
	Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance 
In-reply-to: <Pine.GSO.4.44.0211271928320.11279-100000@ra.sai.msu.su> 
References: <Pine.GSO.4.44.0211271928320.11279-100000@ra.sai.msu.su>
Comments: In-reply-to Oleg Bartunov <oleg@sai.msu.su>
	message dated "Wed, 27 Nov 2002 19:29:43 +0300"
Date: Wed, 27 Nov 2002 11:57:04 -0500
Message-ID: <18374.1038416224@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/1037
X-Sequence-Number: 32253

Oleg Bartunov <oleg@sai.msu.su> writes:
> Are there any reason to "fetch (and perhaps decompress) the TOAST entries"
> just to count(*) without any WHERE clause ?

It doesn't.  That was my point...

			regards, tom lane