>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> I tend to agree with the opinion that Oracle's architecture
Tom> is based on twenty-year-old assumptions. Back then it was
Tom> reasonable to assume that database-specific algorithms could
Tom> outperform a general-purpose operating system. In today's
Tom> environment that assumption is not a given.
In fact:
Michael Stonebraker: Operating System Support for Database Management.
CACM 24(7): 412-418 (1981)
Abstract:
Several operating system services are examined with a
view toward their applicability to support of database
management functions. These services include buffer pool
management; the file system; scheduling, process
management, and interprocess communication; and
consistency control.
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
