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: | Raw Message | Whole Thread | 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
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 |
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 |
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 |