Re: 7.3.1 New install, large queries are slow

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 7.3.1 New install, large queries are slow
Date: 2003-01-28 10:54:50
Message-ID: Pine.NEB.4.51.0301281952590.1575@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2003-01-28 15:15:09 Re: Indexing foreign keys
Previous Message Stephan Szabo 2003-01-28 07:49:52 Re: Indexing foreign keys