[HACKERS] Query got Killed with CTE.

2017-10-17 Thread Prabhat Sahu
Hi, While quering with CTE against PG HEAD , i found that query got killed with this below error logs -- Machine Configuration: (d1.xlarge) CUPs : 8 , RAM : 16GB , SIze : 640GB postgres=# with x as (select 5 c1 from generate_series(1,100) x) select * from x x1 join x x2 using(c1); Killed

Re: [HACKERS] Parallel Hash take II

2017-10-11 Thread Prabhat Sahu
Hi Thomas, I was testing this feature with v20 patch, and I got a crash while doing large joins with small work_mem, and lots of workers as below. -- Machine Configuration: (d1.xlarge) CUPs : 8 , RAM : 16GB , SIze : 640GB -- postgres.conf setting as below: work_mem = *64kB*

Re: [HACKERS] Parallel Hash take II

2017-09-13 Thread Prabhat Sahu
bhat Kumar Sahu* Mob: 7758988455 Skype ID: prabhat.sahu1984 www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/> On Wed, Sep 13, 2017 at 12:34 PM, Prabhat Sahu < prabhat.s...@enterprisedb.com> wrote: > > On Thu, Aug 31, 2017 at 6:23 PM, Thomas Munro <

Re: [HACKERS] Parallel Hash take II

2017-09-13 Thread Prabhat Sahu
On Thu, Aug 31, 2017 at 6:23 PM, Thomas Munro wrote: > Here's a new rebased and debugged patch set. Hi Thomas, I have applied the recent patch (v19) and started testing on this feature and i got a crash with below testcase. with default setting on

Re: [HACKERS] increasing the default WAL segment size

2017-03-13 Thread Prabhat Sahu
Hi, 2)Getting "Aborted (core dumped)" error at the time of running pg_basebackup , *(this issue is only coming on Linux32 ,not on Linux64)* we have double check to confirm it . Steps to reproduce on Linux32 > === >> fetch the sources >> apply both the patches >> ./configure

Re: [HACKERS] Aggregate Push Down - Performing aggregation on foreign server

2016-10-13 Thread Prabhat Sahu
On Fri, Sep 30, 2016 at 5:23 PM, Jeevan Chalke < jeevan.cha...@enterprisedb.com> wrote: > In the attached patch I have fixed all other review comments you have > posted. All the comments were excellent and helped me a lot to improve > in various areas. > Hi, I have tested and created few

Re: [HACKERS] Aggregate Push Down - Performing aggregation on foreign server

2016-09-12 Thread Prabhat Sahu
Hi, While testing "Aggregate pushdown", i found the below error: -- GROUP BY alias showing different behavior after adding patch. -- Create table "t1", insert few records. create table t1(c1 int); insert into t1 values(10), (20); -- Create foreign table: create foreign table f_t1 (c1 int)