| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: FreeBSD, Linux: select, select count(*) performance |
| Date: | 2002-11-27 16:56:34 |
| Message-ID: | 18354.1038416194@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> On Wed, 27 Nov 2002, Tom Lane wrote:
>> You didn't say what was *in* the table, exactly ... but I'm betting
>> there are a lot of toasted columns, and that the extra runtime
>> represents the time to fetch (and perhaps decompress) the TOAST entries.
> 278 columns of various types.
> namely,
> [snip]
Hmm, no particularly wide columns there --- but 278 columns is a lot.
I think the extra time might just be the time involved in fetching all
those column values out of the table row?
If you're interested in pursuing it, I'd suggest rebuilding the backend
with profiling enabled so you can see exactly where the time goes.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Guest | 2002-11-27 16:56:39 | Re: rename |
| Previous Message | Stephan Szabo | 2002-11-27 16:48:24 | Re: Integrity constraint [false] problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-27 16:57:04 | Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance |
| Previous Message | Teodor Sigaev | 2002-11-27 16:55:07 | Re: contrib/ltree patches |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-27 16:57:04 | Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance |
| Previous Message | Achilleus Mantzios | 2002-11-27 16:35:20 | Re: FreeBSD, Linux: select, select count(*) performance |