Hi Fabien, On 2015-06-01 PM 08:40, Fabien COELHO wrote: > > Turning "checkpoint_flush_to_disk = on" reduces significantly the number > of late transactions. These late transactions are not uniformly distributed, > but are rather clustered around times when pg is stalled, i.e. more or less > unresponsive. > > bgwriter_flush_to_disk does not seem to have a significant impact on these > tests, maybe because pg shared_buffers size is much larger than the database, > so the bgwriter is seldom active. >
Not that the GUC naming is the most pressing issue here, but do you think "*_flush_on_write" describes what the patch does? Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers