Search Postgresql Archives

Re: autovacuum: 50% iowait for hours

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

 



Joao Ferreira <joao.miguel.c.ferreira@xxxxxxxxx> writes:
> I have a hard situation in hands. my autovacuum does not seem to be able
> to get his job done;

> database is under active INSERTs/UPDATEs;
> CPU is in aprox 50% iowait for the past 5 hours;

> I've tried turning off autovacuum and the effect goes away; I turn it back
> on and it goes back to 50% iowait; my IO system is nothing special at all;

Indeed, it sounds like you don't have enough I/O capacity for the size
of database you are running.

Turning off autovacuum is extremely unlikely to be a good solution;
it might reduce the bandwidth demand but it will just hasten the
database's bloating into unusability.

> 2010-05-13 21:44:59 WEST   ERROR:  failed to re-find parent key in
> "timeslots_strs_var_ts_key"

You seem to have some worse problems than disk bandwidth, though :-(.
The above is not good at all.  What PG version is this?  If not recent,
update, then reindex that index.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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