Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL Parallel Processing !

From: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Parallel Processing !
Date: 2012-01-27 09:19:25
Message-ID: 4F226C1D.3020905@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
27.01.12 11:06, Marti Raudsepp написав(ла):
> On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally
> <sridhar(dot)bn1(at)gmail(dot)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.

In response to

pgsql-performance by date

Next:From: Tomas VondraDate: 2012-01-27 09:46:03
Subject: Re: PostgreSQL Parallel Processing !
Previous:From: Marti RaudseppDate: 2012-01-27 09:06:14
Subject: Re: PostgreSQL Parallel Processing !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group