pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
7.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>
  2006-08-24 14:52 ` Re: 7.4 PG_CLOG problems Tom Lane <tgl@sss.pgh.pa.us>
  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: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   ` Re: 7.4 PG_CLOG problems 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 14:11 7.4 PG_CLOG problems Pallav Kalva <pkalva@livedatagroup.com>
  2006-08-24 14:52 ` Re: 7.4 PG_CLOG problems Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-08-24 15:03   ` Pallav Kalva <pkalva@livedatagroup.com>
  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