Re: [HACKERS] Surprising behaviour of \set AUTOCOMMIT ON

2016-08-10 Thread Venkata Balaji N
On Thu, Aug 11, 2016 at 2:58 PM, Venkata Balaji N wrote: > > On Tue, Aug 9, 2016 at 1:02 AM, Robert Haas wrote: > >> On Mon, Aug 8, 2016 at 10:10 AM, Rahila Syed >> wrote: >> > Thank you for inputs everyone. >> > >> > The opinions on this thread

Re: [HACKERS] Surprising behaviour of \set AUTOCOMMIT ON

2016-08-10 Thread Venkata Balaji N
On Tue, Aug 9, 2016 at 1:02 AM, Robert Haas wrote: > On Mon, Aug 8, 2016 at 10:10 AM, Rahila Syed > wrote: > > Thank you for inputs everyone. > > > > The opinions on this thread can be classified into following > > 1. Commit > > 2. Rollback > > 3. Error > > 4. Warning > > > > As per opinion upth

Re: [HACKERS] pg_rewind in contrib

2015-03-25 Thread Venkata Balaji N
e 1.* *No rewind required.* I am not getting this too. Regards, Venkata Balaji N

Re: [HACKERS] recovery_target_time ignored ?

2015-03-25 Thread Venkata Balaji N
On Wed, Mar 25, 2015 at 1:28 AM, David Steele wrote: > On 3/24/15 6:12 AM, Venkata Balaji N wrote: > > > > On Tue, Mar 24, 2015 at 9:54 AM, David Steele > <mailto:da...@pgmasters.net>> wrote: > > > > On 3/23/15 12:42 AM, Venkata Balaji N wrote: >

Re: [HACKERS] recovery_target_time ignored ?

2015-03-24 Thread Venkata Balaji N
On Tue, Mar 24, 2015 at 9:54 AM, David Steele wrote: > On 3/23/15 12:42 AM, Venkata Balaji N wrote: > > Hi, > > > > Assuming that this might require a patch, i am posting this in > > pgsql-hackers. Apologies, if this is not the appropriate mailing list to > >

[HACKERS] recovery_target_time ignored ?

2015-03-22 Thread Venkata Balaji N
ve='true' If this requires a patch, i would like to take it up. Regards, Venkata Balaji N

Re: [HACKERS] Streaming replication and WAL archive interactions

2015-02-28 Thread Venkata Balaji N
well how to use this. The code should work too, and comments on that > are welcome too, but I haven't tested it much. I'll do more testing next > week. Patch did get applied successfully to the latest master. Can you please rebase. Regards, Venkata Balaji N

Re: [HACKERS] Redesigning checkpoint_segments

2015-02-22 Thread Venkata Balaji N
ansaction log file(s) added, 0 removed, 170 recycled; write=149.432 s, sync=0.664 s, total=150.284 s; sync files=13, longest=0.286 s, average=0.051 s; distance=1244483 kB, estimate=2632860 kB Above checkpoint logs are generated at the time when pg_xlog size was at 5.4G *Code* *Review* I had a look at the code and do not have any comments from my end. Regards, Venkata Balaji N

Re: [HACKERS] Redesigning checkpoint_segments

2015-02-22 Thread Venkata Balaji N
> > I am wondering a bit about interaction with wal_keep_segments. > One thing is that wal_keep_segments is still specified in number of > segments and not size units, maybe it would be worth to change it also? > And the other thing is that, if set, the wal_keep_segments is the real > max_wal_size

Re: [HACKERS] Redesigning checkpoint_segments

2015-02-04 Thread Venkata Balaji N
Missed adding "pgsql-hackers" group while replying. Regards, Venkata Balaji N On Thu, Feb 5, 2015 at 12:48 PM, Venkata Balaji N wrote: > > > On Fri, Jan 30, 2015 at 7:58 PM, Heikki Linnakangas < > hlinnakan...@vmware.com> wrote: > >> On 01/30/2015 04:48

Re: [HACKERS] Redesigning checkpoint_segments

2015-01-29 Thread Venkata Balaji N
Hi, I really like the idea of tuning checkpoint segments based on disk space usage. I performed series of tests for this patch and would like to share the results. My comments are in-line. To start with, I applied this patch to the master successfully - > But ... do I understand things correc