pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgstat wait timeout 2+ messages / 1 participants [nested] [flat]
* pgstat wait timeout @ 2012-07-27 22:03 Anibal David Acosta <aa@devshock.com> 0 siblings, 0 replies; 2+ messages in thread From: Anibal David Acosta @ 2012-07-27 22:03 UTC (permalink / raw) To: pgsql-performance In my postgres log I saw a lot of warning like this. WARNING: pgstat wait timeout Every 10 seconds aprox since yesterday and after one year working without any warning I have postgres 9.0.3 on a Windows Server 2008 R2. I have only one big table with aprox. 1,300,000,000 (yes 1,300 millions) rows the table is not used just keep historical record, could be this the reason, some autovacuum over this table? pg_stat_activity not show any autovacuum over this table but yes over the transactional table, right now the autovacuum about transactional table is taking 30 minutes (now() - xact_start ) Thanks ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgstat wait timeout @ 2012-07-27 22:31 Anibal David Acosta <aa@devshock.com> 0 siblings, 0 replies; 2+ messages in thread From: Anibal David Acosta @ 2012-07-27 22:31 UTC (permalink / raw) To: pgsql-performance More information. After many "WARNING: pgstat wait timeout" in the log also appear "ERROR: canceling autovacuum task " De: Anibal David Acosta [mailto:aa@devshock.com] Enviado el: viernes, 27 de julio de 2012 06:04 p.m. Para: pgsql-performance@postgresql.org Asunto: pgstat wait timeout In my postgres log I saw a lot of warning like this. WARNING: pgstat wait timeout Every 10 seconds aprox since yesterday and after one year working without any warning I have postgres 9.0.3 on a Windows Server 2008 R2. I have only one big table with aprox. 1,300,000,000 (yes 1,300 millions) rows the table is not used just keep historical record, could be this the reason, some autovacuum over this table? pg_stat_activity not show any autovacuum over this table but yes over the transactional table, right now the autovacuum about transactional table is taking 30 minutes (now() - xact_start ) Thanks ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-07-27 22:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-07-27 22:03 pgstat wait timeout Anibal David Acosta <aa@devshock.com> 2012-07-27 22:31 Re: pgstat wait timeout Anibal David Acosta <aa@devshock.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox