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? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
