On Tue, Jan 17, 2006 at 05:12:09PM -0500, Tom Lane wrote: > However, that's always been the case, so I don't understand > why your stats file is so much bigger in 8.1. Have you changed your > vacuuming strategy at all since the 8.0 installation? Perhaps row or > block statistics weren't enabled in the 8.0 installation and are now?
The only change was the upgrade to 8.1. I run VACUUM FULL everyday, and double checked that it finished succesfully in last two days. The block and row statistics are disabled: stats_start_collector = on stats_command_string = off stats_block_level = off stats_row_level = off stats_reset_on_server_start = off I have no idea, why the pgstat.stat is so large. I just shutdown the idle backend connection, so there're only 30 left (instead of 200), and the pgstat size decreases by 200KB from 8.8 to 8.6 MB. The lowest size of pgstat in last six hours was 8.5 MB. -- Marcin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
