Ok, if autovacuum doesn't actually lock the tables for this long time
then it's fine. But I started investigating this because the inserts
were hanging and I'm still puzzled why it's active when it shouldn't be :)
In principle you are right, but in this particular case autovacuum gets
in the w
On Fri, Jul 31, 2009 at 12:24 AM, Costin Grigoras wrote:
> => show autovacuum;
> autovacuum
>
> off
>
> I really overdid it, I know, but this issue is very annoying. Even with
> these settings it's still ongoing.
>
> The IO doesn't seem to be an issue, the DB sits on a RAID6 of 8 10K
On Fri, Jul 31, 2009 at 12:24 AM, Costin Grigoras wrote:
>
>> Anytime autovacuum is instrusive look at incrementing the nap time to
>> 10 to 20 ms. If that doesn't help then you're already running on the
>> ragged edge of IO throughput and might need to look into a faster RAID
>> array or somethin
Anytime autovacuum is instrusive look at incrementing the nap time to
10 to 20 ms. If that doesn't help then you're already running on the
ragged edge of IO throughput and might need to look into a faster RAID
array or something.
=> show autovacuum_naptime;
autovacuum_naptime
--
On Thu, Jul 30, 2009 at 10:56 PM, Costin Grigoras wrote:
> The insertion rate is ~250 records / second, quite uniformly spread in time
> over ~3000 tables. To reach 2^31 something like 100 days are needed and the
> cluster is less than 10 days old. And we do vacuuming :)
I do believe there are som
The insertion rate is ~250 records / second, quite uniformly spread in
time over ~3000 tables. To reach 2^31 something like 100 days are needed
and the cluster is less than 10 days old. And we do vacuuming :) So as
far as I understand, the wraparound shouldn't happen. In fact before 8.4
we ran
On Thu, Jul 30, 2009 at 2:52 PM, Costin Grigoras wrote:
> Hi,
>
> I'm running 8.4 and I've tried to disable autovacuum since the vacuuming is
> taken care internally in the code. The same was true with the previous
> version (8.0 to 8.3) and there was never any problem. However now in 8.4 the
> "of
Hi,
I'm running 8.4 and I've tried to disable autovacuum since the vacuuming is
taken care internally in the code. The same was true with the previous
version (8.0 to 8.3) and there was never any problem. However now in 8.4 the
"off" setting seems to be ignored even if "track_counts = off" and hug