Search Postgresql Archives

Re: WARNING: pgstat wait timeout

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <dineshkumar02@xxxxxxxxx> wrote:
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 Message. As discussed, the huge I/O may causing due to the checkpoint occurs on the Database.


How to log the checkpoints information .

===============================

1) Edit the postgresql.conf file as log_checkpoints=on

2) Select Pg_Reload_Conf();


Case 2 {Invalid stats_temp_location}

======

When the postgresql "stats_temp_location" is invalid path, then in this case also we can expect this kind of WARNING Message. If you want to change this location to some other place, then we need to follow the below approach. 


1) Edit the postgresql.conf file as stats_temp_location='<PATH>'

2) Select Pg_Reload_Conf();


Case 3 {Invalid Localhost IP}

======

There might be a chance, we have an invalid Localhost IP. Please check the localhost entires in Hosts file and rectify it if any thing wrong.

Once we made any changes in this file then we need to restart the PostgreSQL Cluster to take it's Effect on autovacuum worker processes.



I hope some one will add more on this. 


Regards,

Dinesh Kumar

manojadinesh.blogspot.com

 



On Mon, Feb 4, 2013 at 5:24 PM, Jake Stride <jake@xxxxxxxxxxxx> wrote:
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




--
Jake Stride

Find out more http://about.me/jakestride or follow me on twitter @jake.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux