Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-16 Thread Amit kapila
On Thursday, November 15, 2012 7:30 PM Robert Haas wrote: On Thu, Nov 15, 2012 at 12:08 AM, Amit Kapila wrote: >> Okay. >> So as Robert and Alvaro suggested to have it separate utility rather than >> having options in pg_resetxlog to print MAX LSN seems to be quite >> appropriate. >> I am planning

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-15 Thread Robert Haas
On Thu, Nov 15, 2012 at 12:08 AM, Amit Kapila wrote: > Okay. > So as Robert and Alvaro suggested to have it separate utility rather than > having options in pg_resetxlog to print MAX LSN seems to be quite > appropriate. > I am planning to update the patch to make it a separate utility as > pg_comp

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-14 Thread Amit Kapila
On Wednesday, November 14, 2012 10:19 PM Fujii Masao wrote: > On Thu, Nov 15, 2012 at 12:55 AM, Amit Kapila > wrote: > > Now user can use this utility to decide if new-standby has max LSN > greater > > > And that situation can occur when new-standby has startpoint LSN > greater > > than new-maste

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-14 Thread Fujii Masao
On Thu, Nov 15, 2012 at 12:55 AM, Amit Kapila wrote: > Now user can use this utility to decide if new-standby has max LSN greater > than max LSN of new-master he needs to use fullback-up on new-standby. Is my > understanding right? No. The maximum LSN of data pages in new-standby should be compar

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-14 Thread Amit Kapila
On Wednesday, November 14, 2012 9:12 PM Fujii Masao wrote: > On Wed, Nov 14, 2012 at 5:35 PM, Amit Kapila > wrote: > > On Tuesday, November 13, 2012 10:17 PM Fujii Masao wrote: > >> On Tue, Nov 13, 2012 at 1:23 PM, Amit kapila > >> wrote: > >> > On Monday, November 12, 2012 9:56 PM Alvaro Herrera

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-14 Thread Fujii Masao
On Wed, Nov 14, 2012 at 5:35 PM, Amit Kapila wrote: > On Tuesday, November 13, 2012 10:17 PM Fujii Masao wrote: >> On Tue, Nov 13, 2012 at 1:23 PM, Amit kapila >> wrote: >> > On Monday, November 12, 2012 9:56 PM Alvaro Herrera wrote: >> > Robert Haas escribió: >> >> On Tue, Jul 31, 2012 at 8:09 A

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-14 Thread Fujii Masao
On Wed, Nov 14, 2012 at 5:53 AM, Robert Haas wrote: > On Tue, Nov 13, 2012 at 11:46 AM, Fujii Masao wrote: >> Without this utility, it's difficult to calculate the maximum LSN of >> data page, so >> basically we needed to take a backup when starting the standby. In the >> future, >> thanks to th

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-14 Thread Amit Kapila
On Tuesday, November 13, 2012 10:17 PM Fujii Masao wrote: > On Tue, Nov 13, 2012 at 1:23 PM, Amit kapila > wrote: > > On Monday, November 12, 2012 9:56 PM Alvaro Herrera wrote: > > Robert Haas escribió: > >> On Tue, Jul 31, 2012 at 8:09 AM, Amit kapila > wrote: > > > >>> >> I think I can see all

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-13 Thread Robert Haas
On Tue, Nov 13, 2012 at 11:46 AM, Fujii Masao wrote: > Without this utility, it's difficult to calculate the maximum LSN of > data page, so > basically we needed to take a backup when starting the standby. In the future, > thanks to this utility, we can calculate the maximum LSN, and can skip a >

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-13 Thread Fujii Masao
On Tue, Nov 13, 2012 at 1:23 PM, Amit kapila wrote: > On Monday, November 12, 2012 9:56 PM Alvaro Herrera wrote: > Robert Haas escribió: >> On Tue, Jul 31, 2012 at 8:09 AM, Amit kapila wrote: > >>> >> I think I can see all of those things being potentially useful. There >>> >> are a couple of pe

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-12 Thread Amit kapila
On Monday, November 12, 2012 9:56 PM Alvaro Herrera wrote: Robert Haas escribió: > On Tue, Jul 31, 2012 at 8:09 AM, Amit kapila wrote: >> >> I think I can see all of those things being potentially useful. There >> >> are a couple of pending patches that will revise the WAL format >> >> slightly;

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-12 Thread Alvaro Herrera
Noah Misch wrote: > On Sun, Nov 11, 2012 at 02:18:11AM -0300, Alvaro Herrera wrote: > > I will > > move all the open patches to CF3, unless someone beats me to it. I > > probably won't be able to get anything done tomorrow, so if somebody has > > a boring Sunday I would appreciate the help. > >

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-12 Thread Alvaro Herrera
Robert Haas escribió: > On Tue, Jul 31, 2012 at 8:09 AM, Amit kapila wrote: > >> I think I can see all of those things being potentially useful. There > >> are a couple of pending patches that will revise the WAL format > >> slightly; not sure how much those are likely to interfere with any > >>

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-12 Thread Robert Haas
On Tue, Jul 31, 2012 at 8:09 AM, Amit kapila wrote: >>> Based on the discussion and suggestions in this mail chain, following >>> features can be implemented: >>> >>> 1. To compute the value of max LSN in data pages based on user input >>> whether he wants it for an individual > >>> file, a par

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-11 Thread Noah Misch
On Sun, Nov 11, 2012 at 02:18:11AM -0300, Alvaro Herrera wrote: > Amit kapila wrote: > > On Saturday, November 10, 2012 10:19 PM Noah Misch wrote: > > > This patch is now marked Returned with Feedback in the CF, but I see no > > > on-list feedback. Did some review happen? > > > > No review happen

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-10 Thread Alvaro Herrera
Amit kapila wrote: > > On Saturday, November 10, 2012 10:19 PM Noah Misch wrote: > > This patch is now marked Returned with Feedback in the CF, but I see no > > on-list feedback. Did some review happen? > > No review happened for this patch. > It has returned due to slight confusion thinking tha

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-10 Thread Amit kapila
On Saturday, November 10, 2012 10:19 PM Noah Misch wrote: > This patch is now marked Returned with Feedback in the CF, but I see no > on-list feedback. Did some review happen? No review happened for this patch. It has returned due to slight confusion thinking that this is same as: Patch for opti

Re: [HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-11-10 Thread Noah Misch
This patch is now marked Returned with Feedback in the CF, but I see no on-list feedback. Did some review happen? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] [PATCH] Patch to compute Max LSN of Data Pages

2012-07-31 Thread Amit kapila
>> Based on the discussion and suggestions in this mail chain, following >> features can be implemented: >> >> 1. To compute the value of max LSN in data pages based on user input whether >> he wants it for an individual >> file, a particular directory or whole database. >> >> 2a. To search t