Re: Disadvantages on having too many page slots?

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Disadvantages on having too many page slots?
Date: 2007-04-18 15:39:27
Message-ID: 1176910767.16187.79.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Other than hard disk space, are there any disadvantages on
> having a large number of page slots?

It's not using hard disk space, it's using shared memory, so you might
want to adjust it to make that memory available for other purposes...

> DETAIL: A total of 2233472 page slots are in use (including overhead).
> 2233472 page slots are required to track all free space.
> Current limits are: 14000000 page slots, 1000 relations, using 82096 KB.

I'm not sure how much a difference would make to have ~60M of memory
more, but it could mean one more index in memory ;-)

Cheers,
Csaba.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-04-18 16:32:31 Re: Disadvantages on having too many page slots?
Previous Message Francisco Reyes 2007-04-18 15:19:42 Disadvantages on having too many page slots?