-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Scott Marlowe wrote:
> > Vacuum full doesn't use fsm, lazy vacuum does (i.e. plain vacuum). Are you sure? Why then after a vacuum full verbose the FSM settings are displayed ? > Is there a reason you're doing a full vacuum? Because I'm only running pg_autovacuum since one month now, but I see that for same table is a disaster do not vacuum full once in a day. > and no, you can't vacuum parts at a time. it's all or nothing. > (*Unless that changes in 8.0...*) I wish that this happen. Regards Gaetano Mendola -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCOfxN7UpzwH2SGd4RArg0AKDn4hDw6aiaQgHW18xBfUsCNWqurgCgtaVj fmDWcXtK+kZsrdSbY6rw3LA= =zZEC -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match