On Wed, Aug 22, 2012 at 07:38:33PM +0530, Amit Kapila wrote: > I had made sure no full_page_write happens by making checkpoint interval and > checkpoints segments longer. > > > > Original code - 1.8G Modified code - 1.1G Diff - 63% reduction, incase of > fill factor 100. > Original code - 1.6G Modified code - 1.1G Diff - 45% reduction, incase of > fill factor 80. > > > > I am still in process of collecting synchronous commit mode on data.
Wow, that sounds promising. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers