Re: Possible Bug? TEST CASE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Possible Bug? TEST CASE
Date
Msg-id 13398.1026837425@sss.pgh.pa.us
Whole thread Raw
In response to Re: Possible Bug? TEST CASE  (Francis Reader <freader@imerge.co.uk>)
List pgsql-bugs
Francis Reader <freader@imerge.co.uk> writes:
> To conclude, if you have many clients whose backends have infrequent write
> accesses and then long periods of inactivity, but whose connection to the
> database is left open, and other backends that are active which march on and
> create new wal files, many "(deleted)" wal can be created which are ONLY
> cleared up, with the closing of the backend or when another write access on
> the db from that backend.

And so what?  I don't see any bad effects here (especially not in the
context of 7.2's renaming).

> As another point, is there a way to TURN OFF WAL completely????

No.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: drop database doesn't work
Next
From: Jerome Alet
Date:
Subject: Re: drop database doesn't work