Re: slow building index and reference after Sybase to Pg

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: Gary Fu <gfu(at)sigmaspace(dot)com>
Subject: Re: slow building index and reference after Sybase to Pg
Date: 2011-02-28 22:56:49
Message-ID: 201102282356.50428.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Saturday, February 26, 2011 12:11:19 AM Gary Fu wrote:
> wal_buffers = 16MB
sensible
> checkpoint_segments = 256
A setting that high seems unlikely to be beneficial... I suggest you configure
log_checkpoints to monitor this.

> effective_cache_size = 30GB
Not likely to matter in this case.

> maintenance_work_mem = 2GB
1GB is the max value taking effect.

I would also suggest setting
wal_sync_method=fdatasync

You haven't configured shared_buffers at all? I would suggest setting it to 2GB
or such.

Andres

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2011-02-28 22:59:29 Re: Lock ACCESS EXCLUSIVE and Select question !
Previous Message Adrian Klaver 2011-02-28 22:51:57 Re: Lock ACCESS EXCLUSIVE and Select question !