• Spaces
  • Collections
  • Help
    • ×
     
     
    •  
    BMC PATROL for PostgreSQL Database 1.0

    Page tree

    The PATROL for PostgreSQL KM metrics generate events that will help you decide to adjust the number of disk pages for which free space is tracked in the PostgreSQL database shared free-space map. An undersized free space map can cause the database to consume increasing amounts of disk space over time. Free space that is not in the map cannot be re-used so the PostgreSQL database will request more disk space from the operating system, when it needs to store new data.

    These KM metrics generate events that indicate the number of deletions, updates, and inserts in the PostgreSQL database.

    You can use the events generated by these metrics to determine whether it is necessary to increase, or decrease, the maximum number of disk pages (max_fsm_pages) parameter in the PostgreSQL database environment.

    This page includes information about the following PATROL for PostgreSQL KM attributes:

    Related topics

    Using

    Installing

    Defining a monitoring policy

    The following graph shows the number of deletions, updates, and inserts in the PostgreSQL database shared free-space map.

    Number of deletions

    Set the threshold on this attribute to get notified about the number of deletions from the PostgreSQL database. By default, this attribute will not generate an alarm or warning event. For more information about this attribute, see Number of delete attribute page.

    For more information about setting an alarm or warning event for this attribute, or changing the default attribute range, see Defining a monitoring policy.

    Event generated by the KM

    You can see the event in the TrueSight console in Monitoring > Events.

    Suggested action

    The KM event indicates that you might want to increase the maximum number of disk pages in the PostgreSQL database.

    Number of updates

    Set the threshold on this attribute to get notified about the number of updates in the PostgreSQL database. By default, this attribute will not generate an alarm or warning event. For more information about this attribute, see Number of updates attribute page.

    For more information about setting an alarm or warning event for this attribute, or changing the default attribute range, see Defining a monitoring policy.

    Event generated by the KM

    You can see the event in the TrueSight console in Monitoring > Events.

    Suggested action

    The KM event indicates that you might want to increase the maximum number of disk pages in the PostgreSQL database.

    Number of inserts

    Set the threshold on this attribute to get notified about the number of inserts in the PostgreSQL database. By default, this attribute will not generate an alarm or warning event. For more information about this attribute, see Number of inserts attribute page.

    For more information about setting an alarm or warning event for this attribute, or changing the default attribute range, see Defining a monitoring policy.

    Event generated by the KM

    You can see the event in the TrueSight console in Monitoring > Events.

    Suggested action

    The KM event indicates that you might want to increase the maximum number of disk pages in the PostgreSQL database.

    © Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.