On 19/08/07, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:
> Phoenix Kiula wrote:
> > On 19/08/07, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:
> > should we do one (VACUUM FULL) now given that we've overrun our max_fsm_pages?
>
> Yes, but not until you've fixed it. And only once.
>
FIxed what - the max_fsm_pages? That was my question: how to know what
value to set for this. If the "vacuum verbose" won't give me the info
you suggested because it is likely overlapping with autovacuum, should
I temporarily turn autovacuum off and then run vacuum verbose? Also,
while running vacuum full, any precautions to take?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
