Home > mailing lists

WAL and problems with loading a large table - Mailing list pgsql-general

From	Martin Weinberg
Subject	WAL and problems with loading a large table
Date	June 21, 2001 11:13:38
Msg-id	200106211213.IAA06666@osprey.astro.umass.edu Whole thread Raw
List	pgsql-general

Tree view

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

pgsql-general by date:

From: zilch@home.se
Date: 21 June 2001, 10:51:03
Subject: Foreign Keys to Non-primary keys?

From: "Thalis A. Kalfigopoulos"
Date: 21 June 2001, 14:03:11
Subject: Re: Quick RServ Question

WAL and problems with loading a large table - Mailing list pgsql-general

Previous

Next