pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed7.4 PG_CLOG problems
3+ messages / 2 participants
[nested] [flat]
* 7.4 PG_CLOG problems
@ 2006-08-24 14:11 Pallav Kalva <pkalva@livedatagroup.com>
0 siblings, 1 reply; 3+ messages in thread
From: Pallav Kalva @ 2006-08-24 14:11 UTC (permalink / raw)
To: pgsql-admin
Hi,
Does anybody know what this means ? "LOG: removing file
"/var/lib/pgsql/data/pg_clog/0000",
There were whole bunch of files got removed from the pg_clog
directory. I saw this on my postgres 7.4 log while doing a vacuum
on a database last night, this database was never vacuumed before for
past one year. The reason we didnt do any vacuum's before on this
because it was used only for SELECTS.
Is this a problem something to worry about ? my database seems to
working fine , I could run all my queries and everything seems to be fine.
Thanks!
Pallav.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 7.4 PG_CLOG problems
@ 2006-08-24 14:52 Tom Lane <tgl@sss.pgh.pa.us>
parent: Pallav Kalva <pkalva@livedatagroup.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2006-08-24 14:52 UTC (permalink / raw)
To: Pallav Kalva <pkalva@livedatagroup.com>; +Cc: pgsql-admin
Pallav Kalva <pkalva@livedatagroup.com> writes:
> Does anybody know what this means ? "LOG: removing file
> "/var/lib/pgsql/data/pg_clog/0000",
Routine maintenance; don't worry about it.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 7.4 PG_CLOG problems
@ 2006-08-24 15:03 Pallav Kalva <pkalva@livedatagroup.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Pallav Kalva @ 2006-08-24 15:03 UTC (permalink / raw)
To: pgsql-admin
Hi Tom,
Thanks! for the reply, I just realized that yesterday by mistake the
vacuum script also included "template0" database and it vacuumed that
one too.
Would that cause any problems ?
Pallav.
Tom Lane wrote:
> Pallav Kalva <pkalva@livedatagroup.com> writes:
>
>> Does anybody know what this means ? "LOG: removing file
>> "/var/lib/pgsql/data/pg_clog/0000",
>>
>
> Routine maintenance; don't worry about it.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-08-24 15:03 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-24 14:11 7.4 PG_CLOG problems Pallav Kalva <pkalva@livedatagroup.com>
2006-08-24 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-08-24 15:03 ` Pallav Kalva <pkalva@livedatagroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox