>> the one which I gave is an example, if I have solution for this then
>> same will be applied for real-time senario
>
> There's no way to execute a single query in a parallel manner and it won't
> be available anytime soon.
>
> This is not an issue unless you have a CPU bound query and you have u
On 27 Leden 2012, 13:16, sridhar bamandlapally wrote:
> For security reasons, I cannot put real-time senario into loop,
The point of Marti's comment was that the estimates (as presented by
EXPLAIN PLAN FOR in Oracle) are inherently imprecise. Don't trust what
Oracle is telling you about the expect
For security reasons, I cannot put real-time senario into loop,
the one which I gave is an example, if I have solution for this then
same will be applied for real-time senario
We have implemented PARALLEL technology into our database and same
expecting after migration to PostgreSQL,
The real-tim
sridhar bamandlapally, 27.01.2012 05:31:
SQL> explain plan for select * from hr.emp ;
Explained.
PLAN
--
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-
On 27 Leden 2012, 10:06, Marti Raudsepp wrote:
> On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally
> wrote:
>> --
>> | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
>> |
>> -
27.01.12 11:06, Marti Raudsepp написав(ла):
On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally
wrote:
--
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
On Fri, Jan 27, 2012 at 06:31, sridhar bamandlapally
wrote:
> --
> | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
> --
> | 0
*Hi ALL*
**
*Please have a look into this,*
*this may help us to think on PARALLEL option*
**
*WITHOUT PARALLEL Option*
SQL> explain plan for select * from hr.emp ;
Explained.
PLAN
--
| Id | Operation | Name | Rows |
On Wed, Jan 25, 2012 at 5:16 PM, Merlin Moncure wrote:
> On Wed, Jan 25, 2012 at 7:43 AM, Claudio Freire
> wrote:
>> I know squat about how to implement this, but I've been considering
>> picking the low hanging fruit on that tree and patching up PG to try
>> the concept. Many of the items above
On Wed, Jan 25, 2012 at 7:43 AM, Claudio Freire wrote:
> I know squat about how to implement this, but I've been considering
> picking the low hanging fruit on that tree and patching up PG to try
> the concept. Many of the items above would require a thread-safe
> execution engine, which may be qu
Yes
"Hint method" is an alternative solution which does not appear to be
exclusive parallelism solution as it is included in comment block and have
no error handling,
and this could be one of the reason against PG policy
"Parameter method" ( which we are thinking about ) can be very exclusive
par
On Wed, Jan 25, 2012 at 6:18 AM, sridhar bamandlapally
wrote:
> I just want to illustrate an idea may possible for bringing up
> parallel process in PostgreSQL at SQL-Query level
>
> The PARALLEL option in Oracle really give great improvment in
> performance, multi-thread concept has great possibi
Hi Everyone
I just want to illustrate an idea may possible for bringing up
parallel process in PostgreSQL at SQL-Query level
The PARALLEL option in Oracle really give great improvment in
performance, multi-thread concept has great possibilities
In Oracle we have hints ( see below ) :
SELECT /*+P
13 matches
Mail list logo