Re: Disadvantages on having too many page slots?

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Francisco Reyes <lists(at)stringsutils(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Disadvantages on having too many page slots?
Date: 2007-04-30 12:42:44
Message-ID: 993EB07C-F6E1-4816-912F-6CEA5D218568@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 18, 2007, at 4:39 PM, Csaba Nagy wrote:
>> 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...

AFAIK, the FSM is written out during a clean shutdown... so from that
standpoint it does take disk space. But obviously the memory usage is
the only real concern.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2007-04-30 12:45:09 Re: permissions
Previous Message Greg Smith 2007-04-30 11:48:24 Re: Feature Request --- was: PostgreSQL Performance Tuning