Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Tom LaneDate: 2005-09-14 17:58:14
Subject: Re: Disabling WAL for bulk data loads
Previous:From: hubert depesz lubaczewskiDate: 2005-09-14 09:47:14
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group