Re: Full page images in WAL & Cache Invalidation - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Full page images in WAL & Cache Invalidation
Date
Msg-id 1185143422.4284.92.camel@ebony.site
Whole thread Raw
In response to Full page images in WAL & Cache Invalidation  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
On Sun, 2007-07-22 at 17:54 +0200, Florian G. Pflug wrote:

> 1) It seems that the btree code sends out relcache
>     invalidation msgs during normal operation
>     (No DDL statements are executed). This lets any
>     simple flush-all-caches-if-ddl-was-execute scheme
>     fail.

Cache invalidation is uniquely associated with these WAL record types:

XLOG_BTREE_NEWROOT
XLOG_BTREE_INSERT_META
XLOG_BTREE_DELETE_PAGE_META

None of those things happen with any real frequency in most use cases.
We don't increase or reduce the number of levels of an index very
frequently.

--  Simon Riggs EnterpriseDB  http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Full page images in WAL & Cache Invalidation
Next
From: Gregory Stark
Date:
Subject: Re: Full page images in WAL & Cache Invalidation