Re: PostgreSQL with Zabbix - problem of newbe - Mailing list pgsql-performance

From Robert Haas
Subject Re: PostgreSQL with Zabbix - problem of newbe
Date
Msg-id r2p603c8f071004081244t9542b70fnf20d3001437b0d41@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL with Zabbix - problem of newbe  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: PostgreSQL with Zabbix - problem of newbe
List pgsql-performance
2010/4/8 Merlin Moncure <mmoncure@gmail.com>:
> previous to 8.2, to get good performance on zabbix you need to
> aggressively vacuum the heavily updated tables yourself.

Generally if you DON'T vacuum aggressively enough, then vacuums will
take a really long and painful amount of time, perhaps accounting for
the "hang" the OP observed.  There's really no help for it but to
sweat it out once, and then do it frequently enough afterward that it
doesn't become a problem.

...Robert

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: significant slow down with various LIMIT
Next
From: Richard Yen
Date:
Subject: Re: PostgreSQL with Zabbix - problem of newbe