Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-04 Thread Tatsuo Ishii
On Tue, Oct 02, 2007 at 09:07:54PM -0400, Alvaro Herrera wrote: Decibel! wrote: Hrm... what about adding output to vacuum verbose that indicates how many pages in a relation have free space? That would allow something like pgfouine to see how many FSM pages were needed. It would

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-03 Thread Decibel!
On Tue, Oct 02, 2007 at 09:07:54PM -0400, Alvaro Herrera wrote: Decibel! wrote: Hrm... what about adding output to vacuum verbose that indicates how many pages in a relation have free space? That would allow something like pgfouine to see how many FSM pages were needed. It would also

[HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-02 Thread Tatsuo Ishii
Sorry for replying to very old message. But... it seems this was not backported to 8.1 or earlier. If so, how one could determine max_fsm_pages is sufficient or not if he is running 8.1 or earlier? -- Tatsuo Ishii SRA OSS, Inc. Japan Log Message: --- Fix free space map to correctly

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-02 Thread Tom Lane
Tatsuo Ishii [EMAIL PROTECTED] writes: Sorry for replying to very old message. But... it seems this was not backported to 8.1 or earlier. Since it involved a change in the FSM API, it didn't seem reasonable to back-patch it. regards, tom lane

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-02 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: Sorry for replying to very old message. But... it seems this was not backported to 8.1 or earlier. Since it involved a change in the FSM API, it didn't seem reasonable to back-patch it. So for those versions of PostgreSQL the only way to know the

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-02 Thread Decibel!
Dropping -committers. On Oct 2, 2007, at 10:37 AM, Tatsuo Ishii wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: Sorry for replying to very old message. But... it seems this was not backported to 8.1 or earlier. Since it involved a change in the FSM API, it didn't seem reasonable to back-patch

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-02 Thread Alvaro Herrera
Decibel! wrote: Hrm... what about adding output to vacuum verbose that indicates how many pages in a relation have free space? That would allow something like pgfouine to see how many FSM pages were needed. It would also make it easier to identify relations that could stand a vacuum

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix free space map to correctly track the total amount of FSM

2007-10-02 Thread Tom Lane
Decibel! [EMAIL PROTECTED] writes: Hrm... what about adding output to vacuum verbose that indicates how many pages in a relation have free space? Did you forget the context here? This is 8.1 and before that we're worried about; we're not making such changes in stable releases.