Suppose I have a large table with no indexes, and I scan the entire
thing. What is the impact on the shared buffers? I'm interested in
three scenarios:
- Scan done in SQL using SELECT, (via JDBC if it matters).
- Scan done using SQL COPY.
- Scan done using psql COPY.
I suspect that the SELECT
On Tue, 2007-11-13 at 17:10 -0500, Morris Goldstein wrote:
I suspect that the SELECT scan will tend to displace everything else
in shared buffers, and I hope that the two forms of COPY do not. Is
that correct?
In 7.4 that may be true, but in later versions it's not.
8.0+ use multiple LRU