pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
vacuuming 2+ messages / 2 participants [nested] [flat]
* vacuuming @ 2006-08-08 07:39 Eugeny N Dzhurinsky <bofh@redwerk.com> 0 siblings, 1 reply; 2+ messages in thread From: Eugeny N Dzhurinsky @ 2006-08-08 07:39 UTC (permalink / raw) To: pgsql-performance Hello I have pg_autovacuum running with the arguments: pg_autovacuum -D -s 120 -v 10000 the database is postgresql 8.0.0 Sometimes load average on server raises to 20 and it is almost impossible to login via SSH When I'm logging in finally, I see there is cpu usage: 6% and iowait 95% ps ax | grep post gives me postgres: postgres db [local] VACUUM Is there some solution to avoid such cases? -- Eugene N Dzhurinsky ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: vacuuming @ 2006-08-09 21:20 Jim C. Nasby <jnasby@pervasive.com> parent: Eugeny N Dzhurinsky <bofh@redwerk.com> 0 siblings, 0 replies; 2+ messages in thread From: Jim C. Nasby @ 2006-08-09 21:20 UTC (permalink / raw) To: Eugeny N Dzhurinsky <bofh@redwerk.com>; +Cc: pgsql-performance On Tue, Aug 08, 2006 at 10:39:56AM +0300, Eugeny N Dzhurinsky wrote: > Hello > > I have pg_autovacuum running with the arguments: > > pg_autovacuum -D -s 120 -v 10000 It's been a while since I looked at the pg_autovac settings, but I know that it's threasholds were way, way to high. They were set to something like 2, when 0.2 is a better idea. > the database is postgresql 8.0.0 > > Sometimes load average on server raises to 20 and it is almost impossible to > login via SSH > > When I'm logging in finally, I see there is cpu usage: 6% and iowait 95% > > ps ax | grep post gives me > > postgres: postgres db [local] VACUUM > > Is there some solution to avoid such cases? Have you turned on vacuum_cost_delay? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-09 21:20 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-08-08 07:39 vacuuming Eugeny N Dzhurinsky <bofh@redwerk.com> 2006-08-09 21:20 ` Jim C. Nasby <jnasby@pervasive.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