Re: wal files on temporary tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: wal files on temporary tables
Date: 2006-08-14 21:27:25
Message-ID: 15038.1155590845@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> writes:
> Then i've created "normal" tables but the wal file
> generated by this tables grows and grows.

The WAL files shouldn't grow indefinitely unless you've got some
fairly serious problem that is preventing checkpoints from occurring.
Look in the server log file to see if there are any error messages
about that.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2006-08-14 21:46:17 Re: Best approach for a "gap-less" sequence
Previous Message Enver ALTIN 2006-08-14 21:23:40 Re: wal files on temporary tables