Hannu, On 4/10/06 2:23 AM, "Hannu Krosing" <[EMAIL PROTECTED]> wrote:
>> The cost of fetching a page from the OS is not really much of an >> overhead, > > Have you tested this ? I have - the overhead of fetching a page from Linux I/O cache to buffer cache is about an additional 20% over fetching it directly from buffer cache on PG 7.4. Haven't tested it on 8.1. - Luke ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match