order by name desc nulls last;
--check the explain plan
explain plan select * from fdw_sort_test order by name desc nulls last;
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
Thanks Ashutosh. Retested the issue after applying given patch,It is fine
now.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Wed, Mar 2, 2016 at 2:35 PM, Ashutosh Bapat <
ashutosh.ba...@enterprisedb.com> wrote:
> Thanks Rajkumar for your report. Let m
terminated abnormally
before or while processing the request.
connection to server was lost
Facing the same crash while doing left outer join, right outer join or
combination of left-right outer joins for three tables and one local and
two foreign tables.
Thanks & Regards,
Rajkumar Raghuwa
Thanks Ashutosh for the patch. I have apply and retested it, now not
getting server crash.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Mon, Mar 21, 2016 at 8:02 PM, Ashutosh Bapat <
ashutosh.ba...@enterprisedb.com> wrote:
> Thanks Michael for look
and full outer join on corresponding foreign tables
SELECT t1.c1,t2.c1,t3.c1 FROM ft t1 INNER JOIN ft t2 ON (t1.c1 = t2.c1)
FULL JOIN ft t3 ON (t2.c1 = t3.c1);
c1 | c1 | c1
++
1 | 1 | 1
1 | 2 |
2 | 1 |
2 | 2 | 2
(4 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
>
Thanks Ashutosh for the patch. I have applied and tested it. Now getting
proper result for reported issue.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Tue, Mar 29, 2016 at 7:50 PM, Ashutosh Bapat <
ashutosh.ba...@enterprisedb.com> wrote:
>
> Observat
3| | A
(8 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Tue, Sep 6, 2016 at 1:37 PM, Amit Langote
wrote:
>
> Hi,
>
> On 2016/09/06 16:13, Ashutosh Bapat wrote:
> > I found a server crash while running make check in regress folder
in ('IT');
create table emp_p2 partition of employee for values in ('HR');
create table emp_p3 partition of employee for values in (??);
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Tue, Sep 6, 2016 at 6:37 PM, Amit Langote
wrote:
> On Tue, Sep 6
On Wed, Sep 7, 2016 at 3:58 PM, Amit Langote
wrote:
>
> Hi,
>
> On 2016/09/07 17:56, Rajkumar Raghuwanshi wrote:
> > Hi,
> >
> > I have a query regarding list partitioning,
> >
> > For example if I want to store employee data in a table, with "IT&qu
-+-+-
test_array_p1 | 1 | {1} | {1}
(1 row)
postgres=# SELECT tableoid::regclass,* FROM test_array_p2;
tableoid| i | j | k
---+---+---+-
test_array_p2 | 2 | {2,2} | {2}
(1 row)
postgres=# SELECT tableoid::regclass,* FROM test_array;
ERROR: cache lo
ktop/edb_work/WO
RKDB/PG/postgresql/src'
make: *** [all-src-recurse] Error 2
PS : I am using - gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17)
Attached the patch for the fix of above error.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
diff --git a/src/include/nodes/relation.h
connection to the server was lost. Attempting reset: Failed.
!>
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
ata*PartitionScheme; */
Thanks & Regards,
Rajkumar Raghuwanshi
On Thu, Oct 19, 2017 at 12:16 PM, Amit Langote <
langote_amit...@lab.ntt.co.jp> wrote:
> Description of the attached patches:
>
> 0001: add new tests for partition-pruning
>
> 0002: patch that makes all the changes needed in the planer (adds a stub
> function in partition.c)
>
> 0003: patch
lt;= 1;
QUERY PLAN
--
Append
-> Seq Scan on rp_p2
Filter: (a <= 1)
(3 rows)
postgres=# select * from rp where a <= 1;
a | b
---+
1 | p2
(1 row)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
Append
-> Foreign Scan on ftplt1_p1 t1
-> Foreign Scan on ftplt1_p2 t1_1
-> Unique
-> Append
-> Foreign Scan on ftplt1_p1 t2
-> Foreign Scan on ftplt1_p2 t2_1
(8 rows)
--PG-HEAD +v5 patches
postgres=# EXPLAIN (COSTS
AND
c2 < 300;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
WHERE a IS NOT NULL ORDER
BY 1;
tableoid | a | b | c
--+---+---+---
lpd_p1 | 1 | 1 | 1
lpd_p1 | 2 | 2 | 2
lpd_p1 | 3 | 3 | 3
lpd_p2 | 4 | 4 | 4
lpd_p2 | 5 | 5 | 5
(5 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
6)
Delete on lp1
Delete on lp2
Delete on lp3
-> Seq Scan on lp1 (cost=0.00..29.05 rows=6 width=6)
Filter: ((c1 >= 1) AND (c1 < 2))
-> Seq Scan on lp2 (cost=0.00..29.05 rows=6 width=6)
Filter: ((c1 >= 1) AND (c1 < 2))
-> Seq Scan on lp3
(5),(25),(15);
INSERT 0 3
postgres=# select tableoid::regclass, * from test_range;
tableoid | a
--+
ft_test_range_p1 | 5
ft_test_range_p2 | 15
ft_test_range_p3 | 25
(3 rows)
--Here ft_test_range_p2 is created for range 20-30 having value 15.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Thu, Oct 6, 2016 at 12:44 PM, Amit Langote wrote:
>
> Attached revised patches. Also, includes a fix for an issue reported by
> Rajkumar Raghuwanshi [1] which turned out to be a bug in one of the later
> patches. I will now move on to addressing the comments on patch 0003.
>
tgres (select only)
application_namewait_event_typewait_event query
pgbench IO ReadDataBlock
SELECT abalance FROM
Attached excel with all IO event values.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
wait_event_for_d
On Thu, Mar 9, 2017 at 10:54 AM, Rushabh Lathia
wrote:
> Thanks Rajkumar for performing tests on this patch.
>
> Yes, I also noticed similar results in my testing. Additionally sometime I
> also
> noticed ReadSLRUPage event on my system.
>
> I also run the reindex database command and I notices be
without
>> clearing the wait event.
>>
Thanks, I ran pgbench with shared_buffers set to 128kB, able to see
below wait IO events.
DataFileRead
DataFileWrite
WALInitSync
WALInitWrite
WALWrite
DataFileSync
WALRead
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporatio
> On Mon, Mar 20, 2017 at 1:19 PM, Ashutosh Bapat
> wrote:
I have created some test to cover partition wise joins with
postgres_fdw, also verified make check.
patch attached.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
diff --git a/contrib/postgres_fd
ev/null" 2>&1
400kB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... TRAP:
FailedAssertion("!(LWLockTranchesAllocated >=
LWTRANCHE_FIRST_USER_DEFINED)", File: "lwlock.c", Line: 501)
child process was terminated by signal 6: Aborted
initdb: removing data directory "data"
[edb@localhost bin]$
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
pclass_test%';
opfmethod | opfname | opfnamespace | opfowner
---+-+--+--
405 | custom_opclass_test |16409 | 10
(1 row)
Is this expected behaviour??
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
0 |
0 part_upd4 | 10 | 0 part_upd4 | 10 | 0 part_upd4 | 10 |
0 part_upd4 | 10 | 0*(27 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Tue, Jul 25, 2017 at 3:54 PM, Amit Khandekar
wrote:
> On 25 July 2017 at 15:02, Rajkumar Raghuwanshi
> wrote:
> > On Mon, Jul 24, 2017 at 11:23 AM, Amit Khandekar >
> > wrote:
> >>
> >>
> >> Attached update-partition-key_v13.patch now contains
which is explained below.
>
Hi Amit,
I have applied v14 patch and tested from my side, everything looks good to
me. attaching some of test case and out file for reference.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
update_
--schema=a -f d1.dump -Fp
[edb@localhost bin]$ ./pg_dump -d postgres --load-via-partition-root -f
d2.dump -Fp
[edb@localhost bin]$ ./pg_dump -d postgres --load-via-partition-root
--schema=a -f d3.dump -Fp
pg_dump: pg_dump.c:2063: getRootTableInfo: Assertion `tbinfo->numParents ==
1' f
enerate_series(1,15) i;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Wed, Aug 9, 2017 at 1:54 PM, Beena Emerson
wrote:
> Hello Rajkumar,
>
> On Wed, Aug 9, 2017 at 12:37 PM, Rajkumar Raghuwanshi
> wrote:
> >
> > Hi Beena,
> >
> > I have applied Jeevan's v24 patches and then your v9 patch over commit
> > 5ff3d738
| tg_when
--+---+---+-
pt_trigger_after_p1 | pt1 | STATEMENT | AFTER
pt_trigger_before_p1 | pt1 | STATEMENT | BEFORE
(2 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
=
t2.a AND t2.a = t3.a;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
| STATEMENT | AFTER | |
| |
trigger_test12 | pt1 | STATEMENT | AFTER | |
| |
(6 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB
DELETE FROM trigger_test_table WHERE a = 10;
DELETE 0
postgres=# SELECT * FROM trigger_test_statatics;
tg_name | tg_table_name | tg_level | tg_when | tg_op
-+---+--+-+---
(0 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Thu, May 4, 2017 at 5:14 PM, Rahila Syed wrote:
> The syntax implemented in this patch is as follows,
>
> CREATE TABLE p11 PARTITION OF p1 DEFAULT;
>
> Applied v9 patches, table description still showing old pattern of default
partition. Is it expected?
create table lpd (a int, b int, c varch
Hi Rahila,
pg_restore is failing for default partition, dump file still storing old
syntax of default partition.
create table lpd (a int, b int, c varchar) partition by list(a);
create table lpd_d partition of lpd DEFAULT;
create database bkp owner 'edb';
grant all on DATABASE bkp to edb;
--tak
| Nullable | Default | Storage | Stats target
| Description
+-+---+--+-+
-+--+-
c1 | integer | | not null | | plain |
|
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
ver was lost. Attempting reset: Failed.
!>
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
ile for reference.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
hash_partition_test.out
Description: Binary data
--Testing CREATE TABLE...PARTITION BY HASH syntax
--
--basic syntax --should pass
CREATE TABLE hp_tbl (a int)
On Tue, Sep 5, 2017 at 4:34 PM, Ashutosh Bapat <
ashutosh.ba...@enterprisedb.com> wrote:
> I have fixed the issues which were marked as TODOs in the attached
> patches. Also, I have included your test change patch in my series of
> patches. Are there any other issues you have commented out?
>
> Th
AND ((a > 0)
OR ((a = 0) AND (b >= 0
postgres=# select tableoid::regclass,* from d0;
tableoid | a | b
--+---+---
*d1 | 0 | *
(1 row)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
al HashAggregate
Output: pagg_tab_p3.b, pagg_tab_p3.a, PARTIAL count(*)
Group Key: pagg_tab_p3.b, pagg_tab_p3.a
-> Seq Scan on public.pagg_tab_p3
Output: pagg_tab_p3.b, pagg_tab_p3.a
(22 rows)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Mon, Sep 18, 2017 at 12:37 PM, Jeevan Chalke <
jeevan.cha...@enterprisedb.com> wrote:
>
>
> On Tue, Sep 12, 2017 at 6:21 PM, Jeevan Chalke <
> jeevan.cha...@enterprisedb.com> wrote:
>
>>
>>
>> On Tue, Sep 12, 2017 at 3:24 PM, Rajkumar Raghuwans
/ 19
src/backend/optimizer/util/relnode.c 95.3 % 548 / 575 100.0 % 24 / 24
95.3 % 548
/ 575 100.0 % 24 / 24
src/backend/utils/misc/guc.c 67.4 % 1536 / 2278 89.7 % 113 / 126 67.4 % 1536
/ 2278 89.7 % 113 / 126
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
diff --
On Mon, Sep 18, 2017 at 12:37 PM, Jeevan Chalke <
jeevan.cha...@enterprisedb.com> wrote:
>
> On Tue, Sep 12, 2017 at 6:21 PM, Jeevan Chalke <
> jeevan.cha...@enterprisedb.com> wrote:
>
>>
>>
>> On Tue, Sep 12, 2017 at 3:24 PM, Rajkumar Raghuwanshi <
&g
he connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Tue, Dec 27, 2016 at 3:24 PM, Amit Langote wrote:
> On 2016/12/27 18:30, Rajkumar Raghuwanshi wrote:
> > Hi Amit,
> >
> > I have pulled latest sources from git and tried to create multi-level
> > partition, getting a server crash, below are steps to reproduce
On Wed, Jan 4, 2017 at 10:37 AM, Amit Langote wrote:
> On 2017/01/03 19:04, Rajkumar Raghuwanshi wrote:
> > On Tue, Dec 27, 2016 at 3:24 PM, Amit Langote wrote:
> >>
> >> Attached patch should fix the same.
> >
> > I have applied attached patch, ser
utput: c1, c2
Remote SQL: SELECT c1, c2 FROM s1.lt
(3 rows)
EXECUTE stmt_ft;
c1 | c2
+---
1 | s1.lt
(1 row)
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
>
foreign table refering to local view -- fail, throwing error
update ft set c2 = c1;
psql:/home/edb/Desktop/edb_work/Postgres_Fdw/dml_pushdown_35882/observation_view.sql:24:
ERROR: column "ctid" does not exist
CONTEXT: Remote SQL command: EXPLAIN SELECT c1, ctid FROM public.lt_view
FOR UPDATE
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
>
Thanks for the commit. I have tested it again. Not getting server crash now.
Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation
On Mon, May 16, 2016 at 9:38 PM, Robert Haas wrote:
> On Fri, May 13, 2016 at 6:40 PM, Michael Paquier
> wrote:
> > On Fri, May 1
54 matches
Mail list logo