Re: 7.3.1 New install, large queries are slow - Mailing list pgsql-performance

From Curt Sampson
Subject Re: 7.3.1 New install, large queries are slow
Date
Msg-id Pine.NEB.4.51.0301281952590.1575@angelic.cynic.net
Whole thread Raw
In response to Re: 7.3.1 New install, large queries are slow  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-performance
On Tue, 27 Jan 2003, Ron Johnson wrote:

> [read-ahead detection stuff deleted]
>
> It wouldn't work well, though, in a client-server DB like Postgres,
> which, in a busy multi-user system, is constantly hitting different
> parts of different files.

It works great. You just do it on a file-descriptor by file-descriptor
basis.

Unfortunately, I don't know of any OSes that detect backwards scans.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Indexing foreign keys
Next
From: Ron Johnson
Date:
Subject: Re: Indexing foreign keys