Francisco Reyes wrote:
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?

They use shared memory.



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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly



--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to