Juniper NETWORK AND SECURITY MANAGER 2010.4 - REV1, Installation Manual

Page: 235 / 244

Table 36: Profiler Settings in UI System Preferences (continued)
Default Value Description Parameter
7 GMT Database optimization is complex operation. It
occurs at or around the specified hour of day. We
recommend that you set this setting to an hour
of the day when user activities are at a minimum,
such as midnight local time. The time is displayed
as local time of the NSM UI client. If you have
multiple clients operating at varying time zones,
you must set this value to minimize the effect of
the optimization operation. Hour of day to perform
database optimization
(local time)
PostgreSQL Server
You can also configure settings on the PostgreSQL server to improve the performance
of the Profiler DB. These settings appear in the following file on the Device Server:
$NSROOT/DevSvr/var/pgsql/data/postgresql.conf
Most of the changes to improve PostgreSQL performance will increase the shared memory
requirement described in the next section.
Table 37 on page 213 describes parameters in the
postgresql.conf
file that affect Profiler
performance.
Table 37: PostgreSQL Server Settings
Default Value Description Parameter
1000 KB Sets the number of shared memory buffers
(each 8 KB) used by the database server.
Minimum is 2 X max_connections shared_buffers
16384 KB Specifies the amount of memory to be used
by internal sorts and hashes before switching
to temporary disk files. The value is specified
in kilobytes. work_mem
8192 KB Specifies the maximum amount of memory
to be used in maintenance operations, such
as VACUUM. The value is specified in
kilobytes. maintenance_work_mem
20000 Sets the maximum number of disk pages for
which free space is tracked in the shared
free-space map. Six bytes of shared memory
are consumed for each page slot. max_fsm_pages
64 Maximum distance between automatic
checkpoints maintained by postgresql, in log
file segments. checkpoint_segments
600 seconds Maximum time between automatic
checkpoints, in seconds. checkpoint_timeout
213 Copyright © 2010, Juniper Networks, Inc.
Appendix C: Profiler Performance Tuning Recommendations