Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group