From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Various performance questions
Date: Mon, 27 Oct 2003 07:52:06 -0500
Message-ID: <m3isman8qx.fsf@wolfe.cbbrowne.com> (raw)
References: <20031026194449.GD2979@rlx11.zapatec.com>
<87u15vxrue.fsf@stark.dyndns.tv>
<20031027045431.GE2979@rlx11.zapatec.com>
<m3r80zmd1a.fsf@wolfe.cbbrowne.com>
<20031027071703.GF2979@rlx11.zapatec.com>
In the last exciting episode, dror@zapatec.com (Dror Matalon) wrote:
> I was answering an earlier response that suggested that maybe the actual
> counting took time so it would take quite a bit longer when there are
> more rows to count.
Well, if a "where clause" allows the system to use an index to search
for the subset of elements, that would reduce the number of pages that
have to be examined, thereby diminishing the amount of work.
Why don't you report what EXPLAIN ANALYZE returns as output for the
query with WHERE clause? That would allow us to get more of an idea
of what is going on...
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/spiritual.html
When replying, it is often possible to cleverly edit the original
message in such a way as to subtly alter its meaning or tone to your
advantage while appearing that you are taking pains to preserve the
author's intent. As a bonus, it will seem that your superior
intellect is cutting through all the excess verbiage to the very heart
of the matter. -- from the Symbolics Guidelines for Sending Mail
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-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Various performance questions
In-Reply-To: <m3isman8qx.fsf@wolfe.cbbrowne.com>
* 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