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

Re: Incremental checkopints

From: jordani(at)go-link(dot)net
To: greg(at)2ndQuadrant(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incremental checkopints
Date: 2011-07-30 05:23:44
Message-ID: 5122746bc3b5a016d33c118f882bfa2b.squirrel@mail.go-link.net (view raw or flat)
Thread:
Lists: pgsql-hackers
> If you make writes go out more often, they will be less efficient

I think fsync is more important. But many writes + fsync is no good too.
Let suppose that 30 WAL segments are good for performance (to be written
at once). In incremental approach we can have 60 segments and we can write
30 at once. There is no checkpoint_timeout - more buffers will stay more
time.

I can not see any disadvantage.

Jordan Ivanov


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2011-07-30 05:56:39
Subject: Fix for pg_update on win32
Previous:From: Nikhil SontakkeDate: 2011-07-30 04:55:44
Subject: Re: Check constraints on partition parents only?

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