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
On Tue, Jan 24, 2012 at 12:16 PM, Dave Crooke wrote:
> Hi folks
>
> This could be a sheer volume issue, but I though I would ask the wisdom of
> this forum as to next investigative steps.
To answers the question in your subject, yes. If the disk head is
positioned to write in one place, it can't
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
On 24.01.2012 23:34, Tony Capobianco wrote:
Here's the explain:
pg=# explain select getMemberAdminPrevious_sp(247815829,
1,'test.em...@hotmail.com', 'Email', 'Test');
QUERY PLAN
--
Result (cost=0.00..0.26 rows=1 width=0)
(1 row)
Time:
