2008/1/6, Scott Marlowe <[EMAIL PROTECTED]>: > On Jan 6, 2008 5:06 AM, Clodoaldo <[EMAIL PROTECTED]> wrote: > > > > Then I rebuilt and reinstalled postgresql with the xlog_seg_size set > > to the default 16MB and did initdb. Now the time is 7,642 sec. > > > > I'm lost. It looks like 1GB xlog_seg_size is indeed faster than 16MB > > but again it is slower than the production server which uses the > > default xlog_seg_size. > > How fast was it the second time you ran it?
You mean the new server with 16MB xlog_seg_size? Yes, I did run it twice and both took about the same time. In all tests (all configurations) I did an analyze before running so I think that is the real time. Regards, Clodoaldo Pinto Neto ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
