> [EMAIL PROTECTED]
>
> Tomas Szepe <[EMAIL PROTECTED]> writes:
> > We have a production database that happens to receive several
> > thousand row updates per minute. We VACUUM ANALYZE every four
> > hours with max_fsm_pages set to 2100000, and it's no use.
>
> Have you spent any time determining exactly where the problem is?
> I'm suspicious that it's an index-bloat issue.
I'm afraid so. The weird thing is, we once tried running
VACUUM FULL followed by REINDEX and although the process
took ages to complete, it didn't seem to help either. :(
I'll post whatever debug data I'm asked for, just don't make
me run VACUUM FULL or REINDEX again please. (A full redump
is 10-20 times faster. :O)
Thanks,
--
Tomas Szepe <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
