Re: slow building index and reference after Sybase to Pg

  On 02/28/11 17:56, Andres Freund wrote:
> 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
Already set this.
> You haven't configured shared_buffers at all? I would suggest setting it to 2GB
> or such.
>
It is set to 12GB.

Do you recommend to set fsync to off ?  It needs to restart the server.

Thanks,
Gary