Re: checkpoints/bgwriter tuning verification

From: Vick Khera <vivek(at)khera(dot)org>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: checkpoints/bgwriter tuning verification
Date: 2009-10-30 14:24:01
Message-ID: 2968dfd60910300724n1d085e59pedfb20b2a5ffc62f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 29, 2009 at 4:42 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> First step to speed things up is putting pg_xlog on its own disk(s).
> Since pg_xlog is mostly sequentially access, it's much faster when
>

Did that with a symlink. I always do that.

My frustration is that I have this really fast RAID subsystem
connected via fibre channel to a Sun X4100 with 20GB RAM and AMD
Opterons. I don't seem to be able to squeeze out the update
performance I really need out of it.

I'm wondering if it is all the FK checks that are slowing me down...

Thanks for responding to help me out.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2009-10-30 14:30:34 Re: checkpoints/bgwriter tuning verification
Previous Message Sam Mason 2009-10-30 14:19:49 Re: Absolute value of intervals