Hi Dinesh,
Thanks for that - it's when it's vacuuming a DB on Amazon EC2 so I think
case 1 is probably the culprit.
Jake
On 5 February 2013 00:54, dinesh kumar dineshkuma...@gmail.com wrote:
Hi,
As of now, i found the following cases where we can expect these kind of
WARNING message in
I have had some issues with a database on EC2 and I have restored it to a
new instance. When vacuuming the database I am getting the following in the
logs;
WARNING: pgstat wait timeout
Is this normal/acceptable?
Thanks
Hi,
As of now, i found the following cases where we can expect these kind of
WARNING message in pg_log.
Case 1 { Huge I/O }
==
When the postgresql autovacuum process is not able to get the required I/O
to write the statistics to stats_temp_location then we can get this kind
of WARNING