Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Fwd: vacuuming template0 gave ERROR
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: adey <adey11(at)gmail(dot)com>
- Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "PostgreSQL Admin" <postgres(at)productivitymedia(dot)com>, postgresql-l <postgresql-l(at)Groups(dot)ittoolbox(dot)com>
- Subject: Re: Fwd: vacuuming template0 gave ERROR
- Date: Sun, 30 Jul 2006 21:30:24 -0400
adey <adey11(at)gmail(dot)com> writes: > select datname, age(datfrozenxid), datfrozenxid, current_date, current_time > FROM pg_database > If template0 shouldn't be touched (and I don't know of deliberate access to > it), why is this changing please? Because current xid is changing and template0's datfrozenxid is not. Nonetheless, if template0 is properly frozen then you don't need to vacuum it, regardless of what age(datfrozenxid) says. regards, tom lane
- Follow-Ups:
- Re: Fwd: vacuuming template0 gave ERROR
- From: adey
- Re: Fwd: vacuuming template0 gave ERROR
- References:
- Fwd: vacuuming template0 gave ERROR
- From: adey
- Fwd: vacuuming template0 gave ERROR
- Prev by Date: Fwd: vacuuming template0 gave ERROR
- Next by Date: Re: Fwd: vacuuming template0 gave ERROR
- Previous by thread: Fwd: vacuuming template0 gave ERROR
- Next by thread: Re: Fwd: vacuuming template0 gave ERROR
- Indexes: