From: William Yu <wyu@talisys.com>
To: pgsql-admin@postgresql.org
Subject: Re: PLEASE GOD HELP US!
Date: Fri, 01 Oct 2004 19:15:42 -0700
Message-ID: <cjl2sp$n2r$1@news.hub.org> (raw)
In-Reply-To: <cjkh7a$1s73$1@news.hub.org>
References: <007301c4a7eb$9353eac0$3402a8c0@shanepc>
<cjkh7a$1s73$1@news.hub.org>
William Yu wrote:
> There are cases where seqscan will be faster than indexscans. For
> example, your query to retrieve the latest 25 threads -- always faster
> using seqscan. If it was using indexscan, that would explain the 9
> seconds to run because the HD heads would have to jump back & forth from
Oops, I didn't write down my thoughts clearly. I meant to say --
DEPENDING ON THE DISTRIBUTION OF THE VALUES -- the query might be faster
using seqscan.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: wyu@talisys.com
Subject: Re: PLEASE GOD HELP US!
In-Reply-To: <cjl2sp$n2r$1@news.hub.org>
References: <007301c4a7eb$9353eac0$3402a8c0@shanepc> <cjkh7a$1s73$1@news.hub.org> <cjl2sp$n2r$1@news.hub.org>
* 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