| From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Odd error during vacuum |
| Date: | 2002-04-11 01:45:04 |
| Message-ID: | Pine.LNX.4.21.0204111143280.20663-100000@linuxworld.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 11 Apr 2002, Christopher Kings-Lynne wrote:
> Hi all,
>
> I got these odd messages while doing a vacuum in 7.1.3 0 - any idea what
> they mean? I assume it's not fatal as they're just notices, but I've never
> had them before and haven't had them since.
>
> NOTICE: RegisterSharedInvalid: SI buffer overflow
> NOTICE: InvalidateSharedInvalid: cache state reset
This just means that the cache invalidation buffer got overloaded and was
reset. Its not really a problem (except in terms of performance). I would
say that if you haven't seen this before your database is getting more
usage and/or more data.
To fix this increase shared_buffers.
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-11 01:55:08 | Re: help with bison |
| Previous Message | Christopher Kings-Lynne | 2002-04-11 01:38:23 | Odd error during vacuum |