From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Re: Idea: recycle WAL segments, don't delete/recreate 'emm |
Date: | 2001-07-17 20:36:56 |
Message-ID: | 200107172036.f6HKaus19637@jupiter.us.greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
>
> Checking application/pgp-signature: FAILURE
> -- Start of PGP signed section.
> > Hi -
> >
> > pgman wrote:
> >
> > : Most Unix filesystems will not allocate disk blocks until you write in
> > : them. [...]
> >
> > Yes, I understand that, but how is it a problem for postgresql?
>
> Uh, I thought we did that so we were not allocating file system blocks
> during WAL writes. Performance is bad when we do that.
Performance isn't the question. The problem is when you get a
"disk full" just in the middle of the need to write important
WAL information. While preallocation of a new WAL file, it's
OK and controlled, but there are more delicate portions of
the code.
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 #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Wood | 2001-07-17 20:54:29 | Re: psql -l |
Previous Message | Tom Lane | 2001-07-17 20:36:45 | Re: Re: Idea: recycle WAL segments, don't delete/recreate 'em |