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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
