Re: PLEASE GOD HELP US! - Mailing list pgsql-admin

From William Yu
Subject Re: PLEASE GOD HELP US!
Date
Msg-id cjl2sp$n2r$1@news.hub.org
Whole thread Raw
In response to Re: PLEASE GOD HELP US!  (William Yu <wyu@talisys.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Does PostgreSQL Stores its database in multiple disks?
Next
From: "Scott Marlowe"
Date:
Subject: Re: PLEASE GOD HELP US!