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.
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