| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Alban Médici (NetCentrex)" <amedici(at)fr(dot)netcentrex(dot)net> |
| Cc: | pgsql-benchmarks(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] stats on cursor and query execution troubleshooting |
| Date: | 2004-10-06 14:16:39 |
| Message-ID: | 25576.1097072199@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-benchmarks pgsql-performance |
=?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= <amedici(at)fr(dot)netcentrex(dot)net> writes:
> I'm looking for the statistic of memory, CPU, filesystem access while=20
> executing some regular SQL query, and I want to compare them to
> same kind of results while executing a cursor function.
I think your second query is finding all the disk pages it needs in
kernel disk cache, because they were all read in by the first query.
This has little to do with cursor versus non cursor, and everything
to do with hitting recently-read data again.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Médici (NetCentrex) | 2004-10-08 08:47:42 | Re: [PERFORM] stats on cursor and query execution troubleshooting |
| Previous Message | Alban Médici (NetCentrex) | 2004-10-06 10:15:31 | stats on cursor and query execution troubleshooting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Montgomery | 2004-10-06 15:45:30 | Re: Excessive context switching on SMP Xeons |
| Previous Message | Alan Stange | 2004-10-06 13:11:50 | Re: Excessive context switching on SMP Xeons |