Re: Don't removes/recycles WAL files at all

Richard Huxton <dev@archonet.com> writes:

> On Wednesday 30 July 2003 18:54, Michael Govorun wrote:
>> Please, help.
>>
>> versions: 7.3.3, 7.3.4
>>
>> Server don't recycles or removes WAL files at all, generating 12-20 files
>> every day.
>>
>> -rw-------    1 postgres postgres 16777216 Jul 29 01:54 0000000000000000
>> -rw-------    1 postgres postgres 16777216 Jul 29 01:55 0000000000000001
> [...etc]
>
> First thing I'd look for is if there is an old uncommitted transaction lurking
> around somewhere. If the transaction doesn't commit, the WAL will need to
> keep that data around.

I have several projects/databases running on this server. How can I
know about who (or at least what db) gives me uncommited transactions?

Also it seems like vulnerability. Every uncommited transaction takes
16Mb of disk space. It frustrates.

--
Michael Govorun            __o
                         _`\<,_
         .............. (_)/'(_) ...................

I do not get viruses because I do not use MS software. If you use
Outlook then please do not put my email address in your address-book
so that WHEN you get a virus it won't use my address in the From:
field.