agora inbox for [email protected]
help / color / mirror / Atom feedFrom: Don Baccus <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: Ross J. Reedstrom <[email protected]>
Cc: [email protected]
Subject: Re: again on index usage
Date: Fri, 11 Jan 2002 11:42:38 -0800
Message-ID: <[email protected]> (raw)
References: <[email protected]>
Bruce Momjian wrote:
> Also, when we pull from the kernel cache we have to read into our shared
> buffers; much faster than disk i/o but slower than if they were already
> in the cache.
Yes ... this is one reason why folks like Oracle want to be able to
bypass the kernel cache.
> For me the idea of doing non-cached sequential scans came
> from a Solaris internals book I was reading. I think it will be
> possible to mark large sequential scan buffer i/o with lower priority
> caching that may help performance. However, if others are also doing
> sequential scans of the same table _only_, our normal caching may be
> best. As you can see, this gets quite complicated and I am doubtful
> there will be a general solution to this problem --- more of a feedback
> loop may be the best bet --- determine which sequential scans are wiping
> the cache with little other purpose and start not caching them.
It would be interesting to learn more about the actual hueristic Oracle
uses (straight percents of the buffer cache? Something based on
concurrency? I have no idea). The Oracle folks have got tons and tons
of data on real-world big, busy db installations to draw from when they
investigate such things.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
view thread (49+ messages) latest in thread
reply
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 using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: again on index usage
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox