Re: VLDB Features - Mailing list pgsql-hackers

From Decibel!
Subject Re: VLDB Features
Date
Msg-id 1469D789-B496-4252-851A-986BE62AD03D@decibel.org
Whole thread Raw
In response to Re: VLDB Features  (Markus Schiltknecht <markus@bluegap.ch>)
List pgsql-hackers
On Dec 12, 2007, at 1:26 PM, Markus Schiltknecht wrote:
> Josh Berkus wrote:
>> Sure.  Imagine you have a 5TB database on a machine with 8 cores  
>> and only one concurrent user.  You'd like to have 1 core doing I/ 
>> O, and say 4-5 cores dividing the scan and join processing into  
>> 4-5 chunks.
>
> Ah, right, thank for enlightenment. Heck, I'm definitely too  
> focused on replication and distributed databases :-)
>
> However, there's certainly a great deal of an intersection between  
> parallel processing on different machines and parallel processing  
> on multiple CPUs - especially considering NUMA architecture. *comes- 
> to-think-again*...


Except that doing something in-machine is often far simpler than  
trying to go cross-machine, especially when that something is a  
background reader.

Let's walk before we run. :)
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ecxt_scantuple has wrong TupleDesc
Next
From: Decibel!
Date:
Subject: Re: WORM and Read Only Tables (v0.1)