t-oriented SQL while you're at it:
SELECT DISTINCT(col) FROM mytable WHERE col = 'myval'
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.NetBSD.org
Make up enjoying your city life...produced by BIC CAMERA
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Sun, 24 Oct 2004, Tom Lane wrote:
> Considering that the available numbers suggest we could win just a few
> percent...
I must confess that I was completely unaware of these "numbers." Where
do I find them?
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974
ce. (If a
page has a write queue, you might as well leave it with the page after
flushing it, and get rid of it only when the page leaves memory.)
I see the OS issues related to mapping that much memory as a much bigger
potential problem.
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81
locking issues alone would be painful.
I don't see why they would be any more painful than the current locking
issues. In fact, I don't see any reason to add more locking than we
already use when updating pages.
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http
ousands or tens of
thousands of small mappings (certainly NetBSD isn't), but I've never
done any performance tests to see what kind of strategies might work
well or not.
cjs
--
Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.NetBSD.org
Make up enjoying your city
