Re: Incremental checkopints - Mailing list pgsql-hackers

From jordani@go-link.net
Subject Re: Incremental checkopints
Date
Msg-id 5122746bc3b5a016d33c118f882bfa2b.squirrel@mail.go-link.net
Whole thread Raw
In response to Incremental checkopints  (jordani@go-link.net)
List 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:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Reduced power consumption in autovacuum launcher process
Next
From: Nikhil Sontakke
Date:
Subject: Re: Check constraints on partition parents only?