pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (23+ messages)  latest in thread

Message-ID: <m3isman8qx.fsf@wolfe.cbbrowne.com>
Permalink:  ../m3isman8qx.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/m3isman8qx.fsf@wolfe.cbbrowne.com

 · 

reply

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