Re: Postres dilemma

Tom Lane wrote:

> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>
>>Why are you running a vacuum every 45 seconds? Increase your fsm_pages and
>>run it every hour.
>
>
> If I understood his description correctly, he's turning over 10% of a
> 500-row table every minute. So waiting an hour would mean 3000 dead
> rows in a 500-live-row table, which seems excessive. I'd agree with
> running a vacuum on this specific table every five minutes or so.
>
> Given that he is doing more than enough vacuums, I think that the
> problem is probably not table bloat, but index bloat (ie, from a
> constantly shifting range of live index keys, which pre-7.4 btrees
> didn't handle well at all). This is just speculation though, without
> proof as yet.

Another information to know is if there are connection in the
"unfamous" state: "Idle in transaction".

Is usefull if the OP show us the vacuum verbose output.

Regards
Gaetano Mendola