Joshua D. Drake a écrit :
No wonder, I got IO problems with such a fragmentation.
For people not very familiar with postgres especially those coming
from mysql,
i'd recommend paying attention to this.
Definitely. The problem here is that you just aren't vacuuming enough,
not that you didn't vacuum full. I would suggest reviewing autovacuum
and seeing if that will help you.
And paying attention to the max_fsm_pages setting. A value too low won't
help vacuum's work.
Regards.
--
Guillaume.
http://www.postgresqlfr.org
http://docs.postgresqlfr.org
---------------------------(end of broadcast)---------------------------
TIP 1: 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
