Re: Vacuum Complains

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabrice Scemama <fabrice(at)scemama(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum Complains
Date: 2000-05-29 04:16:08
Message-ID: 4851.959573768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fabrice Scemama <fabrice(at)scemama(dot)org> writes:
> when running a daily vacuum, my cron regularly reports this
> message from Pg (7.0 RC1 / RH5.2 with glibc2.1 / compiled
> with gcc 2.5.2):

> NOTICE: RegisterSharedInvalid: SI buffer overflow
> NOTICE: InvalidateSharedInvalid: cache state reset

> Does anyone know what it means exactly ?

It's not anything to worry about --- those are just for debugging
purposes. I'd expect those to show up if you have other backends
that are hung up in transactions waiting for the vacuum to finish.
Or maybe even without any other backends, if you have large system
catalogs...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-05-29 04:54:13 Re: group by week (ww), plus -S performance
Previous Message Mike Mascari 2000-05-29 03:20:05 Re: Another problem - exporting from access