Re: Disabling WAL for bulk data loads

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disabling WAL for bulk data loads
Date: 2005-09-14 16:47:54
Message-ID: dg9k7p$2e7d$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin

Kevin Keith wrote:
> I am coming from an Oracle background - which in the case of bulk data
> loads there were several options I had where I could disable writing to
> the redo log to speed up the bulk data load (i.e. direct load, set the
> user session in no archive logging, set the affected tables to have no
> logging).

If you have enough memory, you can always make a ramdisk to store the
WAL temporarily while you bulk load data. I also temporarily alter the
config to set checkpoint_segments = 1 to use as few pg_xlog files as
possible.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-09-14 17:58:14 Re: Disabling WAL for bulk data loads
Previous Message hubert depesz lubaczewski 2005-09-14 09:47:14 Re: