Re: Idea: recycle WAL segments, don't delete/recreate 'em

From: fche(at)redhat(dot)com (Frank Ch(dot) Eigler)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Idea: recycle WAL segments, don't delete/recreate 'em
Date: 2001-07-17 17:53:40
Message-ID: o5ae23o317.fsf@toenail.toronto.redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


tgl wrote:

: [...] (We have to physically fill each segment with zeroes to
: ensure that the system has actually allocated a whole 16MB to it;
: otherwise we fall victim to the "hole-saving" allocation technique
: of most Unix filesystems.) [...]

Could you explain how postgresql can "fall victim" the filesystem hole
mechanism? Just hoping to force actual storage allocation, or hoping
to discourage fragmentation?

- FChE

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Patrick Macdonald 2001-07-17 18:21:19 Re: Idea: recycle WAL segments, don't delete/recreate 'em
Previous Message Peter Eisentraut 2001-07-17 17:43:22 Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results