Disadvantages on having too many page slots?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Disadvantages on having too many page slots?
Date: 2007-04-18 15:19:42
Message-ID: cone.1176909582.471250.82153.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At one point the databases we had in a machine used 10 million plus page
slots. We made the number of page slots 14 million.

After a few large system were phased out we now only use about 2 million
page slots. Other than hard disk space, are there any disadvantages on
having a large number of page slots?

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2007-04-18 15:39:27 Re: Disadvantages on having too many page slots?
Previous Message John DeSoi 2007-04-18 15:12:27 Re: issue when export/import table including pictures