Re: BUG #7521: Cannot disable WAL log while using pg_dump

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Gezeala M(dot) Bacuño II <gezeala(at)gmail(dot)com>
Cc: ichbinrene <rene(dot)romero(dot)b(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Date: 2012-10-19 20:25:07
Message-ID: CA+Tgmob1T81Tk+o0ezN3pQvbYvhNThB++GX-AJxOt8oa4EfaCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Thu, Oct 18, 2012 at 3:18 PM, Gezeala M. Bacuño II <gezeala(at)gmail(dot)com> wrote:
> You may disable full_page_writes, but as you can see from my previous
> post, disabling it did not do the trick. My zfs' USED property
> continues to increase.

I think we need somebody to compile with WAL_DEBUG defined and try to
reproduce this with wal_debug = on. Then we will find out what WAL
records are being emitted, which will presumably give us a clue as to
what is really happening here.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thom Brown 2012-10-20 12:30:19 pgbench % output incorrect with large scales
Previous Message Tom Lane 2012-10-19 15:05:18 Re: BUG #7615: CREATE RULE + DEFAULT VALUES + pg_dump trouble

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-10-19 20:40:43 Re: [PATCH] Support for Array ELEMENT Foreign Keys
Previous Message Robert Haas 2012-10-19 20:21:46 Re: [PATCH] Support for Array ELEMENT Foreign Keys