Re: calculating shared data memory space

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Jean-Michel Pouré <jm(at)poure(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: calculating shared data memory space
Date: 2008-01-07 19:27:40
Message-ID: Pine.GSO.4.64.0801071426060.11996@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,
including indexes, at
http://andreas.scherbaum.la/blog/archives/282-table-size,-database-size.html

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Hunter 2008-01-07 19:32:26 Re: many to one of many modeling question
Previous Message Tom Lane 2008-01-07 19:22:37 Re: Concurrent modification of plpgsql function body