2008/1/6, Scott Marlowe <scott.marlowe@xxxxxxxxx>: > On Jan 6, 2008 5:06 AM, Clodoaldo <clodoaldo.pinto.neto@xxxxxxxxx> 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
