From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Vikaas BV <vikas(at)cellcloud(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Size of Postgres Transaction Logs |
Date: | 2001-05-18 16:45:47 |
Message-ID: | 20095.990204347@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Vikaas BV <vikas(at)cellcloud(dot)com> writes:
> I find that if there
> are repeated periodic operations on the postgres database, the
> transaction log size increases very rapidly (I was aghast to see that
> after initializing a new database with only 2 tables and a program
> polling one of the tables every 20 secs, the transaction log had grown
> to 120MB overnight) and there appears to be no mechanism of reducing the
> log size except for taking a dump, reinitializing the database and
> reimporting the dump.
The WAL log should be auto-truncated at checkpoints, assuming that the
old entries are no longer needed. However, if you leave uncommitted
transactions sitting around, their WAL entries can't be deleted until
you commit or abort them. I'd only expect massive WAL growth if you
have very long-running transactions ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-18 16:47:27 | Re: Problem while reading from some tables |
Previous Message | Justin Clift | 2001-05-18 16:39:05 | Re: ER diagram generator |