Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Inserts optimization?
- From: Vivek Khera <vivek(at)khera(dot)org>
- To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Inserts optimization?
- Date: Thu, 20 Apr 2006 15:45:14 -0400
On Apr 14, 2006, at 8:00 AM, Marc Cousin wrote:
So, you'll probably end up being slowed down by WAL fsyncs ... and you won't have a lot of solutions. Maybe you should start with trying to set fsync=no as a test to confirm that (you should have a lot of iowaits right now if youhaven't disabled fsync).
Instead of doing that, why not use commit_delay to some nominal value to try and group the fsyncs. If they're coming in at 30 per second, this should help a bit, I suspect.
- References:
- Re: Inserts optimization?
- From: Francisco Reyes
- Re: Inserts optimization?
- From: Marc Cousin
- Re: Inserts optimization?
- Prev by Date: Re: Inserts optimization?
- Next by Date: Re: Quick Performance Poll
- Previous by thread: Re: Inserts optimization?
- Next by thread: Re: Inserts optimization?
- Indexes: