Skip site navigation (1) Skip section navigation (2)

Re: Deleted WAL files held open by backends in Linux

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Deleted WAL files held open by backends in Linux
Date: 2009-12-01 19:14:54
Message-ID: 4B1516CE020000250002CE95@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
 
> Perhaps, if you didn't mind sometimes getting a wrong answer.
 
Well, it would be a heuristic which would close the deleted file
*almost* all the time.  When it didn't, the next check would
probably catch it.  Assuming that you would never get an indication
that it was different when it hadn't changed, the worst that could
happen is that you infrequently get the current behavior.
 
That all *seems* sane to me, if low priroity.  Any objections to my
putting it on the TODO list?
 
-Kevin

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-12-01 19:17:52
Subject: Re: Block-level CRC checks
Previous:From: Greg StarkDate: 2009-12-01 19:10:07
Subject: Re: Block-level CRC checks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group