> 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
I can not see any disadvantage.
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2011-07-30 05:56:39|
|Subject: Fix for pg_update on win32|
|Previous:||From: Nikhil Sontakke||Date: 2011-07-30 04:55:44|
|Subject: Re: Check constraints on partition parents only?|