From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Alban Médici (NetCentrex)" <amedici@fr.netcentrex.net>
Cc: pgsql-benchmarks@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] stats on cursor and query execution troubleshooting
Date: Wed, 06 Oct 2004 10:16:39 -0400
Message-ID: <25576.1097072199@sss.pgh.pa.us> (raw)
In-Reply-To: <4163C5C3.3030304@fr.netcentrex.net>
References: <4163C5C3.3030304@fr.netcentrex.net>
=?ISO-8859-1?Q?=22Alban_M=E9dici_=28NetCentrex=29=22?= <amedici@fr.netcentrex.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-benchmarks@postgresql.org
Cc: tgl@sss.pgh.pa.us, amedici@fr.netcentrex.net, pgsql-performance@postgresql.org
Subject: Re: [PERFORM] stats on cursor and query execution troubleshooting
In-Reply-To: <25576.1097072199@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox