Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints

2021-12-16 Thread Neha Sharma
est1 alter table t set tablespace tab; \c postgres alter database test1 set tablespace tab1; --cancel the below command alter database test1 set tablespace pg_default; --press ctrl+c \c test1 alter table t set tablespace tab1; Log file attached for reference. Thanks. -- Regards, Neha Sharma

Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints

2021-12-09 Thread Neha Sharma
On Thu, Dec 9, 2021 at 11:12 AM Ashutosh Sharma wrote: > Hi, > > The issue here is that we are trying to create a table that exists inside > a non-default tablespace when doing ALTER DATABASE. I think this should be > skipped otherwise we will come across the error like shown below: > > ashu@post

Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints

2021-12-08 Thread Neha Sharma
On Thu, Dec 9, 2021 at 4:26 AM Greg Nancarrow wrote: > On Thu, Dec 9, 2021 at 6:57 AM Neha Sharma > wrote: > > > > While testing the v7 patches, I am observing a crash with the below test > case. > > > > Test case: > > create tablespace tab location

Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints

2021-12-08 Thread Neha Sharma
[134251] LOG: checkpointer process (PID 134252) was terminated by signal 6: Aborted Thanks. -- Regards, Neha Sharma On Tue, Dec 7, 2021 at 12:24 PM Dilip Kumar wrote: > On Mon, Dec 6, 2021 at 7:53 PM Ashutosh Sharma > wrote: > > > > Thank you, Dilip for the quick r

Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb

2021-03-22 Thread Neha Sharma
enSmgr() on the index relation. > > > > I did the check for gistBuildCallback() by adding Assert(index->rd_smgr) > before > smgrnblocks() with CCA setting and didn't see any problem there. > > I think the easiest way to find that is to run a regression suite with CCA > build, perhaps, there is no guarantee that regression will hit all smgr* > operations, but that might hit most of them. Sure, will give a regression run with CCA enabled. > > Regards, > Amul > Regards, Neha Sharma

[CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb

2021-03-21 Thread Neha Sharma
tmaster.c:1737 #21 0x55e5c85237ec in PostmasterMain (argc=, argv=0x55e5ca508fe0) at postmaster.c:1409 #22 0x55e5c811a2cf in main (argc=3, argv=0x55e5ca508fe0) at main.c:209 Thanks. -- Regards, Neha Sharma

Re: [HACKERS] Custom compression methods

2021-01-28 Thread Neha Sharma
74.7 87.5 Thanks. -- Regards, Neha Sharma On Wed, Jan 20, 2021 at 10:18 AM Dilip Kumar wrote: > On Wed, Jan 20, 2021 at 12:37 AM Justin Pryzby > wrote: > > > > Thanks for updating the patch. > > Thanks for the review > > > On Mon, Jan 4, 2021 at 6:52 AM Justi

Re: Subscription test 013_partition.pl fails under CLOBBER_CACHE_ALWAYS

2020-09-15 Thread Neha Sharma
26427] LOG: background worker "logical replication worker" (PID 27868) exited with exit code 1 2020-09-15 08:42:21.921 UTC [27870] LOG: logical replication apply worker for subscription "sub1" has started 2020-09-15 08:42:22.551 UTC [27870] ERROR: cache lookup failed for rel

Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions

2020-08-31 Thread Neha Sharma
st port=5432 dbname=postgres user=edb' PUBLICATION test_pub WITH ( slot_name = test_slot_sub1,streaming=on); Thanks. -- Regards, Neha Sharma On Mon, Aug 31, 2020 at 1:25 PM Amit Kapila wrote: > On Mon, Aug 31, 2020 at 10:49 AM Amit Kapila > wrote: > > > > On Sun, Au

Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions

2020-08-28 Thread Neha Sharma
/sharedtuplestore.c 90.1 90.9 90.1 90.9 90.1 90.9 Thanks. -- Regards, Neha Sharma On Thu, Aug 27, 2020 at 11:16 AM Amit Kapila wrote: > On Wed, Aug 26, 2020 at 11:22 PM Jeff Janes wrote: > > > > > > On Tue, Aug 25, 2020 at 8:58 AM Amit Kapila > wrote: > > > >> >

Re: [Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDE

2020-01-08 Thread Neha Sharma
Hi Michael, Thanks for looking into the issue. Sorry by mistake I had mentioned the incorrect DML query,please use the query as mentioned below. On Thu, Jan 9, 2020 at 11:38 AM Michael Paquier wrote: > On Tue, Jan 07, 2020 at 05:38:49PM +0530, Neha Sharma wrote: > > I am getting a ser

[Logical Replication] TRAP: FailedAssertion("rel->rd_rel->relreplident == REPLICA_IDENTITY_DEFAULT || rel->rd_rel->relreplident == REPLICA_IDENTITY_FULL || rel->rd_rel->relreplident == REPLICA_IDENTIT

2020-01-07 Thread Neha Sharma
in (argc=, argv=argv@entry=0xe90a58, dbname=0xe90960 "postgres", username=) at postgres.c:4287 #15 0x00482bc7 in BackendRun (port=, port=) at postmaster.c:4498 #16 BackendStartup (port=0xe88920) at postmaster.c:4189 #17 ServerLoop () at postmaster.c:1727 #18 0x0073339f in PostmasterMain (argc=argc@entry=3, argv=argv@entry=0xe5fe20) at postmaster.c:1400 #19 0x0048403f in main (argc=3, argv=0xe5fe20) at main.c:210 Thanks. -- Regards, Neha Sharma

[EUC_CN] Failed to connect through user created user/database using simplified Chinese characters

2019-12-05 Thread Neha Sharma
--+---+ 谨角| 10 |2 | zh_CN | zh_CN| f | t | -1 | 13286 | 561 | 1 | 1663 | (1 row) Just wondering, is there anything wrong I am doing or it's a bug? Thanks. -- Regards, Neha Sharma

Re: New committers announced at PGCon 2018

2018-06-02 Thread Neha Sharma
Congratulations Everyone!!! Thanks. -- Regards, Neha Sharma On Sat, Jun 2, 2018 at 12:12 PM, Ashutosh Sharma wrote: > Congrats everyone and special congratulations to Amit for becoming the > first Indian PostgreSQL committer !! > > On Sat, Jun 2, 2018 at 9:40 AM, Nikolay Samokhva