Re: Res: Archive files growth!!!

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Cc: GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Res: Archive files growth!!!
Date: 2008-11-20 12:48:15
Message-ID: 49255C8F.7030200@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

paulo matadr wrote:
> see results:
> oid | relname | reltype | reltuples | relpages | size_kb
> -------+--------------+---------+-----------+----------+---------
> 16506 | cliente_fone | 16507 | 341130 | 3345 | 26760

OK, so there is no TOAST table either. I am out of ideas. It's not
indexes, it's not toast table contents, it's not some action being done
by a trigger, so why is so much WAL logging data generated for these
inserts?

Does anybody have any ideas about what's happening, or any suggestions
about how to find out?

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-11-20 12:59:52 Re: hidden errors calling a volatile function inside a stable function
Previous Message Sabin Coanda 2008-11-20 12:43:50 Re: COPY problem on -- strings