WAL and problems with loading a large table

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL and problems with loading a large table
Date: 2001-06-21 12:13:31
Message-ID: 200106211213.IAA06666@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to load a 200GB table. WAL seems to be using many
GB of disk space and slowing down the load. I tried "-F" and
fync=off in the postmaster.conf (these are supposed to be the
same, right?) but these don't inhibit the WAL use.

What is the right approach here?

Thanks!

--Martin

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2001-06-21 14:51:50 Re: timestamp definition
Previous Message zilch 2001-06-21 11:59:27 Foreign Keys to Non-primary keys?