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: (view raw or whole 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      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-2015 The PostgreSQL Global Development Group