Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance
Date: 2002-11-27 16:57:04
Message-ID: 18374.1038416224@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Oleg Bartunov <oleg(at)sai(dot)msu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message SZUCS Gábor 2002-11-27 17:00:46 Re: Delete Order When Referential Integrity Is Active
Previous Message Ken Guest 2002-11-27 16:56:39 Re: rename

Browse pgsql-hackers by date

  From Date Subject
Next Message scott.marlowe 2002-11-27 17:18:32 Re: [HACKERS] Realtime VACUUM, was: performance of
Previous Message Tom Lane 2002-11-27 16:56:34 Re: FreeBSD, Linux: select, select count(*) performance

Browse pgsql-sql by date

  From Date Subject
Next Message Nathan Young 2002-11-27 17:37:07 Re: join question
Previous Message Tom Lane 2002-11-27 16:56:34 Re: FreeBSD, Linux: select, select count(*) performance