Re: PostgreSQL strugling during high load - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL strugling during high load
Date
Msg-id 23217.1115991763@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL strugling during high load  ("Mindaugas Riauba" <mind@bi.lt>)
Responses Re: PostgreSQL strugling during high load
List pgsql-performance
"Mindaugas Riauba" <mind@bi.lt> writes:
> ... So contents of database changes very fast. Problem is that when
> pg_autovacuum does vacuum those changes slows down too much.

The "vacuum cost" parameters can be adjusted to make vacuums fired
by pg_autovacuum less of a burden.  I haven't got any specific numbers
to suggest, but perhaps someone else does.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: PostgreSQL strugling during high load
Next
From: "Mindaugas Riauba"
Date:
Subject: Re: PostgreSQL strugling during high load