Managing the database free space

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

Installing

Defining a monitoring policy

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

Free Space.png

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.

Delete event.png

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.

Update event.png

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.

Insert event.png

Suggested action

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*