Re: PostgreSQL Parallel Processing !

27.01.12 11:06, Marti Raudsepp написав(ла):
> On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally
> <sridhar.bn1@gmail.com>  wrote:
>> --------------------------------------------------------------------------
>> | Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
>> --------------------------------------------------------------------------
>> |   0 | SELECT STATEMENT  |      |  7444K|   944M| 16077   (4)| 00:03:13 |
>> |   1 |  TABLE ACCESS FULL| EMP  |  7444K|   944M| 16077   (4)| 00:03:13 |
>> --------------------------------------------------------------------------
> Sorry to take this off topic, but... Seriously, over 3 minutes to read
> 944 MB of data? That's less than 5 MB/s, what's wrong with your
> database? :)
Actually I'd ask how parallel CPU may help table sequence scan? Usually
sequence scan does not take large amount of cpu time, so I see no point
in parallelism.