pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Jeremy Dunn <jdunn@autorevenue.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: index v. seqscan for certain values
Date: Mon, 12 Apr 2004 14:55:52 -0500
Message-ID: <20040412195552.GA24133@wolff.to> (raw)
In-Reply-To: <001d01c420c1$0ed23290$4f01a8c0@jeremydunn>
References: <12037.1081792288@sss.pgh.pa.us>
	<001d01c420c1$0ed23290$4f01a8c0@jeremydunn>

On Mon, Apr 12, 2004 at 15:05:02 -0400,
  Jeremy Dunn <jdunn@autorevenue.com> wrote:
> 
> Agreed.  However, given that count(*) is a question that can be answered
> _solely_ using the index (without reference to the actual data blocks),
> I'd expect that the break-even point would be considerably higher than
> the < 3% (~38,000 / ~1.3M) I'm currently getting.  Does PG not use
> solely the index in this situation??

That isn't true. In order to check visibility you need to look at the
data blocks.



view thread (13+ messages)  latest in thread

Message-ID: <20040412195552.GA24133@wolff.to>
Permalink:  ../20040412195552.GA24133@wolff.to/
Also on:    postgresql.org/message-id/20040412195552.GA24133@wolff.to

 · 

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: bruno@wolff.to, jdunn@autorevenue.com
  Subject: Re: index v. seqscan for certain values
  In-Reply-To: <20040412195552.GA24133@wolff.to>

* 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