pg_stat wait timeout

解决pgstatwaittimeout警告

最新推荐文章于 2024-08-16 14:45:54 发布

weixin_34001430

最新推荐文章于 2024-08-16 14:45:54 发布

阅读量331

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：https://my.oschina.net/innovation/blog/689957

本文探讨了在PostgreSQL中遇到pgstatwaittimeout警告的原因及解决办法。主要分为三种情况：由于大量I/O操作导致的问题、无效的stats_temp_location路径问题以及无效的本地主机IP问题。文中提供了修改postgresql.conf文件的具体步骤。

2019独角兽企业重金招聘Python工程师标准>>>

Re: WARNING: pgstat wait timeout

From: dinesh kumar <dineshkumar02(at)gmail(dot)com> To: Jake Stride <jake(at)stride(dot)me(dot)uk> Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> Subject: Re: WARNING: pgstat wait timeout Date: 2013-02-04 13:54:52 Message-ID: CALnrH7oHagFUCAzTKSUOMfyT=NyEOdcrCBnJFoQSrnUZ6zDAUQ@mail.gmail.com (view raw or whole thread) Thread: Lists: pgsql-general 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 .

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

Edit the postgresql.conf file as log_checkpoints=on
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.

Edit the postgresql.conf file as stats_temp_location='<PATH>'
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(at)stride(dot)me(dot)uk> 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

转载于:https://my.oschina.net/innovation/blog/689957