Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Ron JohnsonDate: 2003-01-28 15:15:09
Subject: Re: Indexing foreign keys
Previous:From: Stephan SzaboDate: 2003-01-28 07:49:52
Subject: Re: Indexing foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group