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

2007-10-03 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 neede

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

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.

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 ful

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 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 kn

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 ---

[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 t