i have error in a logfile,if anyone faced this issue please give proper solutions,thnaks
using stale statistics instead of current ones because stats collector is not responsing..
on that time database runing the bulk insert operations.
PostgreSQL tracks 'runtime statistics' which is maintained by a separate process known as stats collector. When a backed process/transactions requests some of the stats it requests a recent snapshot of the file from the collector.
As there is bulk inserts going on on the database, the log message you see means that the collector did not handle such requests fast enough, and the backend decided to read an older snapshot instead. This may also easily happen if the I/O system is overloaded.
Also, One of the reason for this message to occur in the logs is when the process is unable to get the required I/O to write the statistics to "stats_temp_location".
Following are some of the solutions you can prefer :
NOTE : This is not a severe error, your queries will execute without any issues, but may be using less than optimal execution plans because they did not see an update to table statistics in a while.