Re: [ADMIN] another transaction ID question:

2007-10-30 Thread Tom Lane
Kevin Kempter <[EMAIL PROTECTED]> writes: > Do I need to vacuum template0 ? No. regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgre

[ADMIN] another transaction ID question:

2007-10-30 Thread Kevin Kempter
Hi All; In addition to bumping up the max_fsm_pages value, I'm preparing to run a full db vacuum to avoid a transaction ID wrap-around failure for an 8.1.4 server. (we do have autovacuum on, and we're using the 8.2 defaults). I'm doing this based on a recent message from a regular vacuum verb