Re: [GENERAL] calculating shared data memory space

On Jan 7, 2008 11:29 AM, Jean-Michel Pouré <[EMAIL PROTECTED]> wrote: > Dear Friends, > > I am running a phpBB forum with more than 400.000 messages. > I would like to make sure that all indexes fit in shared memory. You're kind of leaning towards tying to optimized things in postgresql the way ot

Re: [GENERAL] calculating shared data memory space

On Mon, 7 Jan 2008, Jean-Michel Pour? wrote: I am running a phpBB forum with more than 400.000 messages. I would like to make sure that all indexes fit in shared memory. How can I calculate the needed space of all indexes? There's a useful commentary on finding the sizes of various objects, i

[GENERAL] calculating shared data memory space

Dear Friends, I am running a phpBB forum with more than 400.000 messages. I would like to make sure that all indexes fit in shared memory. How can I calculate the needed space of all indexes? I remember this was part of VACUUM FULL ANALYSE or the like. Kind regards, Jean-Michel ---