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

Re: Disabling WAL for bulk data loads

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: William Yu <wyu(at)talisys(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disabling WAL for bulk data loads
Date: 2005-09-14 17:58:14
Message-ID: 6159.1126720694@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
William Yu <wyu(at)talisys(dot)com> writes:
> 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.

Really?  That seems pretty counterproductive to me.  I've never seen
a case where reducing checkpoint_segments increased performance.
Checkpoints are expensive, and usually you want 'em far apart.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: William YuDate: 2005-09-14 18:01:11
Subject: Re: Disabling WAL for bulk data loads
Previous:From: William YuDate: 2005-09-14 16:47:54
Subject: Re: Disabling WAL for bulk data loads

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