Monday, March 2, 2009

Configuration file changes when moving to postgresql 8.3

Found this blog entry, which helped me when updating a postgresql.conf file to run under PostgreSQL 8.3. Summary of the changes:

stats_start_collector: This is always on so it is not necessary to configure in PostgreSQL 8.3
stats_command_string: This is now called track_activities.
stats_block_level: This is now combined with stats_row_level and renamed to track_counts
stats_row_level: This is now combined with stats_block_level and renamed to track_counts
stats_reset_on_server_start: This is no longer necessary and is not a configuration option anymore

So now the only additions you will need to make to collect all of the stats you need will be track_counts and track_activities.

Example Configuration Addition:
track_activities = on
track_counts = on

To test that you are collecting the stats run the following command:
select * from pg_stat_all_tables;