| From: | JanWieck(at)t-online(dot)de (Jan Wieck) |
|---|---|
| To: | PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | TOAST & vacuum |
| Date: | 2000-07-21 10:30:36 |
| Message-ID: | 200007211030.MAA03775@hot.jw.home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
FYI,
TOAST is now vacuum-safe. When needed, the toaster creates a
second heap tuple, containing only plain or compressed
values. This one is then returned by the heap access methods
to the caller, so indices will never contain external
references.
The changes are covered by #ifdef TOAST_INDICES, so can
easily be disabled at the time we have file versioning and
can recreate indices during vacuum.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2000-07-21 11:11:32 | Geometry test broken |
| Previous Message | Stephane Bortzmeyer | 2000-07-21 07:39:34 | Re: Re: [HACKERS] 8Ko limitation |